How to create Vertical Partioning

SQL Server Replication

Index ‹ SQL Server

- Previous
  - 1
    - VS 2005 standard prevents using free SQL Express functionality? Hi, *relative newbie warning* I use Visual Studio Standard edition with the built-in version of SQL Server. Now I chose a new image catalogueing app, IDImager, that uses SQL Server Express to store photo info. The idea is that I can use the database also with my own code, or transfer the data to another app/database in the future if necessary. IDImager needs SQL Express with the 'connectivity components' installed using 'mixed mode'. This is their instruction page: http://www.idfoxx.com/support/idipro/install/ However, that option is not available in VS 2005 Standard and when I try to install these components with SQL Express I get the message that's not possible because VS 2005 restricts the install options. So far I gather that the free SQL Express gives one more options than my paid-for Visual Studio 2005 Standard edition, which seems a bit weird. Can anyone tell me how to work around this problem so I can install the IDImager app and use VS 2005 at the same time Thanks, Philip Tag: How to create Vertical Partioning
  - 2
    - Joining mdx results All, I have two separate mdx queries I want to run. I need to be able to specify a date range for each using the range operator ":". The measures will be the same, just different date ranges specified. I want to take the results of each mdx query, and then join them together, so that I end up with a single result, but the measures from date range 1 in one column and the measures from date range 2 in another column. So I want the result to look something like the following: Measure Name Feb1-March1 June1-July31 Cost $55000 $65700 Quantity 7234 8245 Profit $25300 $31343 Let me know what you think the best way to implement this would be. I was thinking of using two separate mdx statements, and then joining them together in some way, but I haven't found a good way to do this. Please let me know if you have a good way to do this. Thanks. Tag: How to create Vertical Partioning
  - 3
    - import data from excel data sheets Hello A problem with my replication system as occured. I have a working SQL server that can do replication trough internet, everyting works The problem is when I try to import large amount of data (10000 rows) to my database on the SQL server the subscriber on my client don't get the rows. That will say imported data is not being replicated. only rows that i have manually inserted will be replicated. I used the import wizard that came with SQL server. Is there a solution to this problem Tag: How to create Vertical Partioning
  - 4
    - How to display column from Inserted table Hi all, I have created a trigger in SQLExpress which looking for any insertion to a specific table in a database: Create Trigger Tg_Insert on [tablename] FOR Insert AS Select * FROM Inserted --------------------------------------------------------- Assume there is nothing wrong with this trigger as I have already checked the output with Query tool. My question is how can I display the newly inserted data to the client In my case, Console application. I want to do something like Console.WriteLine("data from inserted table here"); How can I achieve this FYI, I'm using VS2005 with sqlexpress 2005. Thanks in advance. Regards, SHAH Tag: How to create Vertical Partioning
  - 5
    - Last working day from last year! Dear Friends, How can I retrieve the last working day from the currentyear-1 Thanks Tag: How to create Vertical Partioning
  - 6
    - Check data changes in table Hi all! I need to check data changes in some tables from specified date. Can it be done without triggers for each table SQL Server Management Studio always says "Data was changed" if another user updates data and you try to update old version. How it checks data modification date I found only this: USE [ScheduleDB] GO SELECT * FROM sys.objects WHERE object_id = OBJECT_ID ( '[dbo].[TTest]' ) AND type in ( 'U' ) but it can only show structure modification date. Tag: How to create Vertical Partioning
  - 7
    - Get certain raw row from table Suppose I have a table with 100 records.. and I wantto get the 3rd record from that table. How can I do it Tag: How to create Vertical Partioning
  - 8
    - SQL Server 2005 Service Pack 2 -- Now Available SQL Server 2005 Service Pack 2 has been released to the web. Many of the questions asked on this forum will be solved by applying Service Pack 2. Please take the time to read about the many benefits this service pack provides. SQL Server 2005 Service Pack 2: http://www.microsoft.com/sql/sp2.mspx SQL Server 2005 Service Pack 2 blogs: http://blogs.msdn.com/sqlrem/archive/tags/SQL+Server+2005+-+SP2/default.aspx Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ Tag: How to create Vertical Partioning
  - 9
    - SQL task works running the package but not when called via C# This should be a very easy question. I'm trying to develop an SSIS package that will eventually do many things, but I can't get it to do very basic things. My current test package has 2 tasks in it: 1) File System Task ( FST ) 2) Execute SQL Task ( EST ) When running just the SSIS package via the VS2005 IDE ( as startup project ), everything works fine. The FST moves a file from DIR_A to DIR_B and the EST inserts a test record into the test table. If I set my C# app to the the startup project and execute the package from within the C#, it kinda works. The FST works fine, but the EST does not work and the package returns a "FAILURE" code to the C#. The EST is incredibly basic. This is the SQL text: insert into tmpssis ( tmpdata ) values ( 66 ); I'm using ADO.NET, Direct input, FALSE for IsQueryStoredProcedure, and it's using the only connection I've set up to the database. The FST block runs - the file gets moved, but then it fails on the SQL block for some reason. I'm open to any suggestions. Thanks, -BEP Tag: How to create Vertical Partioning
  - 10
    - MDX throws error after server upgrade Hi all, I deployed the "Adventure Works DW Standard Edition" cubes on my machine and I wrote the following simple MDX : MDX 1 select { [Measures].[Reseller Tax Amount] } on columns , { ([Geography].[Country].&[Australia]:[Geography].[Country].&[Germany], [Product].[Category].&[1]) } on rows from [Adventure Works] The above MDX runs fine on my machine and gives me the output. The following version of SQL Server 2005 is installed on my machine : Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Standard Edition I tried running the same MDX on a server with the following configuration : Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Enterprise Edition . When I run this MDX I get the following error: "The Tuple function expects a tuple expression for the argument. A tuple set expression was used." I modified this MDX like this : MDX 2 select { [Measures].[Reseller Tax Amount] } on columns , { ([Geography].[Country].&[Australia]:[Geography].[Country].&[Germany] * [Product].[Category].&[1]) } on rows from [Adventure Works] The modified MDX runs fine on the server and gives the output. To summarize, MDX 1 and MDX 2 both run fine on my local machine and give me the same output whereas on the server with a higher build of SQL Server 2005, MDX 2 runs fine while MDX 1 fails with the error - "The Tuple function expects a tuple expression for the argument. A tuple set expression was used." I am unable to understand as to why this is happening Is this a compatibility issue which has been documented or is this a bug I request the community members to help me out. Thanks in advance, CodeKraker. Tag: How to create Vertical Partioning
  - 11
    - System.Data.SqlServerCe Sorry being a little vague but if you can point me in the right direction. I have just created a new VB 每 Windows Mobile 5.0 pocket PC 每 Device Application. (which will be connected to a PDA) Do i have to use System.Data.SqlServerCe or System.Data.SqlClient to connect to my db. Tag: How to create Vertical Partioning
  - 12
    - Cant get Access Database Synchronizer set up on client machine I have created a PPC application that uses ADS to synchronize my sqlce db with a desktop MS Access database. It works fine on my computers, but my client cant get it to work on his. Here is the situation. His "Computer Name" as it's stated in his 'My Computer' properties is " PAVSGP024FE.NWFSC.NOAA.GOV " However his Access.MDW File is located in the directory "C:\Documents and Settings\ Joe Nobody \Application Data\Microsoft\Access\System.MDW". There is no directory called "C:\Documents and Settings\ PAVSGP024FE.NWFSC.NOAA.GOV \Application Data\Microsoft\Access\System.MDW". His current config.xml file looks like this. < xml version="1.0" encoding="UTF-8" > <SystemNode> <AccessDB>C:\Program Files\NOAA Release Logger\NOAA_ReleaseLogger.mdb</AccessDB> <DeviceDB>\Program Files\NOAA Release Logger\NOAA_ReleaseLogger.sdf</DeviceDB> <Login>Joe Nobody</Login> <URL>http://Joe Nobody:1024/</URL> <WinDir>C:\</WinDir> </SystemNode> He has tried adding port 1024 as an exception for his firewall settings, has installed Access Database Synchronizer on his computer, and I have also tried using the "long" computer name as the url setting in the config file. (i.e. <URL>http:// PAVSGP024FE.NWFSC.NOAA.GOV :1024/</URL> but this throws the error "The HTTP request failed due to incorrect format or content. Try restarting the IIS server.[]" I dont know what else to try! Anybody have any suggestions Tag: How to create Vertical Partioning
  - 13
    - SQL Server slower after 2005 upgrade We have an extensive stress test for our OLTP application.that runs slower after upgrading to SQL Server 2005. We have done the following: - applied SP1 and SP2 - updated statistics (sp_updatestats) - recompiled all stored procedures Some behavior we notice in Perfmon over the course of the 1-hour test is: - Average CPU Utilization is up from 22% to 32% and we're trying to figure out why - Compilations per second are up from 200 to 250 - Recompilations per second are down from 5 to 1 (which is good). - Memory utilization is identical. - We see exagerated spikes in response times. The general performance seems pretty good - but there are periodic spikes that hurt our averages. - I examined perfmon for waits and nothing jumped out. - A small handful of application workflows are much slower, while most are roughly identical. I realize there could be a zillion different causes. But if anyone has experience upgrading a large OLTP solution which uses a mixture of dynamic SQL and stored procedures to SS2005 - and tuning the upgraded database - please offer any suggestions. Our current plan includes (a) running the Best Practices analyzer which already uncovered a trace flag we may want to use since we're running on an 8-way, (b) rebuilding indexes, and (c) examine a SQL Trace this time around too since it appears the slowness is isolated to certain application workflows. Please offer any suggestions that have worked for your team. Thanks so much! Mike PS I will post all the things we end up doing in the end once we get performance equal or better - hopefully the latter!!! Tag: How to create Vertical Partioning
  - 14
    - Filtering on a part of a field - 3 Hello, new question about an old topic ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1232451&SiteID=1 ): I want to set a filter on a field, but the it must set a filter on a part of the field. I think it will be more clear with an example: I have a list with ItemNumbers and ItemDescriptions. ItemNo ItemDescription 1 Pineapple yellow 2 Cauliflower size 6 3 Orange sweet yellow etc. etc. Now I want that the user of this report can set a filter just by entering a part of the description. So, if he enters 'flower' he only see the cauliflower. If he enters 'yellow' he only see the pineapple and the orange, etc. etc. If a blank value is left, all the items must be shown. After this, Jarret, suggest to me to insert the next code into my query: where ItemDescription like '%' + @ItemDescParam + '%' This helped, but I want to have 2 options extra: 1) The part of the description which the user inserts must be independent of capitals 2) It also have to be possible that the user inserts more than one part. For example "pine" and "fellow" Can some one help me out Thx again Tag: How to create Vertical Partioning
  - 15
    - Multi-user access through a data-access layer/remoting server Hi guys, I've been developing desktop client-server and web apps and have used Access and SQL Server Standard most of the time. I'm looking into using SQL CE, and had a few questions that I can't seem to get a clear picture on: - The documentation for CE says that it supports 256 simultaneous connections and offers the Isolation levels, Transactions, Locking, etc with a 4GB DB. But most people say that CE is strictly a single-user DB and should not be used as a DB Server. Could CE be extended for use as a multi-user DB Server by creating a custom server such as a .NET Remoting Server hosted through a Windows Service (or any other custom host) on a machine whereby the CE DB would run in-process with this server on the machine which would then be accessed by multiple users from multiple machines Clients PCs -> Server PC hosting Remoting Service -> ADO.NET -> SQL CE - and further more can we use Enterprise Services (Serviced Components) to connect to SQL CE and further extend this model to offer a pure high-quality DB Server Clients PCs -> Server PC hosting Remoting Service -> Enterprise Services -> ADO.NET -> SQL CE Seems quite doable to me, but I may be wrong..please let me know either ways Thanks, CP Tag: How to create Vertical Partioning
  - 16
    - How To Connect From SQL Server Database To Another SQL Server Database I want to be able to access a table from another server for example using a stored procedure: I am in server A I want to do a select in a table (dbo.test) that is located on server b. so how can i connect to server b using windows authentication then access the table dbo.test thanks Tag: How to create Vertical Partioning
- Next
  - 1
    - xp_smtp_sendmail My DTS program requires an email functionality. But I cant use xp_SendMail , its already configured to use for some other purposes. Then I came to knew about master.dbo.xp_smtp_sendmail, but my problem is its not executing (giving a procedure not found message). What may be the possible causes How can we able to rectify it Thanks in advance Tag: How to create Vertical Partioning
  - 2
    - Error Message Text in Multi Languages Basically I am making ETL Project in which there is need to display Error Message in Multi Languages e.g.: US English, Japanese. User may have option to see Error Log Table in Japanese or US English, so I was working on it and found solution is below Sample Code, in which I＊m checking same validation twice first for US English language and second for Japanese language. I feel it will take little bit extra time. Is there any better option to achieve this Please Help＃＃.. SIMPLY COPY PASTE AND RUN SET NOCOUNT ON --> DECLARING @PhoneNumber TABLE VARIABLE HAVING PhoneNumber List DECLARE @PhoneNumber TABLE ( PhoneNumbebr NVARCHAR ( 7 )) --> INSERTING PhoneNumber List INTO it. --> Phone Number should be Integer Type. INSERT INTO @PhoneNumber VALUES ( '2766105' ) INSERT INTO @PhoneNumber VALUES ( '2766110' ) INSERT INTO @PhoneNumber VALUES ( '2766112' ) INSERT INTO @PhoneNumber VALUES ( '2710XYZ' ) --> Invalid Phone Number INSERT INTO @PhoneNumber VALUES ( '2766116' ) INSERT INTO @PhoneNumber VALUES ( 'ABC6105' ) --> Invalid Phone Number INSERT INTO @PhoneNumber VALUES ( '2766199' ) INSERT INTO @PhoneNumber VALUES ( '2766120' ) --> DECLARING @ErrorTable TABLE VARIABLE FOR STORING Error Messages in English and Japanese Lenguages. DECLARE @ErrorTable TABLE ( EnglishErrorText NVARCHAR ( 1000 ), JapaneseErrorText NVARCHAR ( 1000 )) --> DECLARING @DistinationTable TABLE VARIABLE WILL STORE VALIDATED Phone List. DECLARE @DistinationTable TABLE ( PhoneNumbebr INT ) --> DECLARING THE VARIABLES TO STORE THE VALUES RETURED BY FETCH DECLARE @PhoneNo NVARCHAR ( 50 ), @EnglishText NVARCHAR ( 1000 ), @JapaneseText NVARCHAR ( 1000 ) DECLARE MultiLanguageErrorCursor CURSOR FOR SELECT PhoneNumbebr FROM @PhoneNumber OPEN MultiLanguageErrorCursor /* PERFORM THE FIRST FETCH AND STORE THE VALUES IN VARIABLES. NOTE: THE VARIABLES ARE IN THE SAME ORDER AS THE COLUMNS IN THE SELECT STATEMENT. */ FETCH NEXT FROM MultiLanguageErrorCursor INTO @PhoneNo --> CHECK @@FETCH_STATUS TO SEE IF THERE ARE ANY MORE ROWS TO FETCH. WHILE @@FETCH_STATUS = 0 BEGIN --> INITILISATION OT VARIABLES SET @EnglishText = '' SET @JapaneseText = '' BEGIN TRY --> CHANGING LANGUAGE SETTING TO us_english SET LANGUAGE us_english INSERT INTO @DistinationTable SELECT CONVERT ( INT , @PhoneNo ) FETCH NEXT FROM MultiLanguageErrorCursor INTO @PhoneNo END TRY BEGIN CATCH SET @EnglishText = ERROR_MESSAGE () --> IT WILL RETURN English ERROR MESSAGE TEXT. --> CHANGING LANGUAGE SETTING TO Japanese TO GET ABOVE ERROR IN JAPANESE. SET LANGUAGE Japanese BEGIN TRY INSERT INTO @DistinationTable SELECT CONVERT ( INT , @PhoneNo ) END TRY BEGIN CATCH SET @JapaneseText = ERROR_MESSAGE () --> IT WILL RETURN Japanese ERROR MESSAGE TEXT. END CATCH /* RESETTING THE LANGUAGE TO us_english TO PREVENT FROM ERROR NO 16958: Could not complete cursor operation because the set options have changed since the cursor was declared. */ SET LANGUAGE us_english --> INSERTING ERROR MESSAGE TEXT INTO @ErrorTable TABLE VARIABLE. INSERT INTO @ErrorTable VALUES ( @EnglishText , @JapaneseText ) FETCH NEXT FROM MultiLanguageErrorCursor INTO @PhoneNo CONTINUE END CATCH ; END CLOSE MultiLanguageErrorCursor DEALLOCATE MultiLanguageErrorCursor SELECT * FROM @ErrorTable GO Tag: How to create Vertical Partioning
  - 3
    - Copy Folders and Files to different location I have a situation from where I need to loop through different folders and files in these folders. After processing these files, I need to archive these folders to different location. e.g., C:\MainFolder\Mar01 ==> Multiple files in Mar01 folder C:\MainFolder\Mar02 ==> Multiple files in Mar02 folder Does any one know the best way to do this in SSIS Thanks in advance. BC Tag: How to create Vertical Partioning
  - 4
    - Permissions to view Stored Procedure Property My Production servers are SQL Server 2005 x64. I would like to allow my developers the ability to look at permissions on production stored procedures but not be able to change those permissions or alter the production code. What has to be set to allow this sort of security. Tag: How to create Vertical Partioning
  - 5
    - data file blanks to nulls Hi, With DTS, the default behavior is to import blanks ("") in a data file as nulls in the table. However, in SSIS, the default behavior is to import blanks as blanks. I need to ensure that the packages I'm migrating import the data in the exact same way. I am wondering what is the easiest way to convert blanks to nulls Right now I'm using a script to convert the blanks to nulls before they are written to the table, but just wondering if there's an easier way. Thanks Tag: How to create Vertical Partioning
  - 6
    - Send an email on non-fatal errors from Data Flow Ok, I'm incredibly new to all of this so please bear with me. I took the Integration Services tutorial, and that's pretty much all that I have done. I'm creating my first package and I want to be able to email myself when certain non-fatal conditions occur. I still want the entire row to flow into my table. My understanding is that this type of checking should be done in the "Data Flow" tab not the "Control Flow" tab. However, I can't see a toolbox item in "Data Flow" to create a SQL script like this. I can see that the "Lookup" toolbox item will allow me to write a SQL script but how do I get it to send out the email Or should I really be doing this type of checking in "Control Flow" where there is an "Send email task" item Any help is greatly appreciated! Thanks! Tag: How to create Vertical Partioning
  - 7
    - Service Broker "TO service could not be found" Message origin: "Transport" I am trying to send a message between to SQL Server 2005 instances on two different machines. I have checked all my routes and all my objects appear to be setup correctly. However, when running Profiler on the target machine, I receive the "This message has been dropped because the TO service could not be found. Service name: "[tcp://mydomain.com/TARGET/MyService]". Message origin: "Transport". This is my activated stored procedure that is sending the message to the target service. I am using certificate security. Any help appreciated.... CREATE PROCEDURE [usp_ProcessMessage] AS BEGIN SET NOCOUNT ON ; DECLARE @conversation_handle uniqueidentifier DECLARE @message_body AS VARBINARY ( MAX ) WHILE ( 1 = 1 ) BEGIN BEGIN TRANSACTION ; WAITFOR ( RECEIVE TOP ( 1 ) @conversation_handle = conversation_handle , @message_body = message_body FROM [tcp://mydomain.com/INITIATE/MyQueue] ), TIMEOUT 1000 ; IF ( @@ROWCOUNT = 0 ) BEGIN COMMIT ; BREAK ; END END CONVERSATION @conversation_handle IF @message_body IS NOT NULL BEGIN BEGIN DIALOG CONVERSATION @conversation_handle FROM SERVICE [tcp://mydomain.com/INITIATE/MyService] TO SERVICE '[tcp://mydomain.com/TARGET/MyService]' ON CONTRACT [tcp://mydomain.com/INITIATE/MyMessage/v1.0] WITH ENCRYPTION = ON , LIFETIME = 600 ; SEND ON CONVERSATION @conversation_handle MESSAGE TYPE [tcp://mydomain.com/TARGET/VisitMessage] ( @message_body ); END COMMIT ; END END GO My endpoints are created like so: CREATE ENDPOINT MyEndpoint STATE = STARTED AS TCP ( LISTENER_PORT = 4022 ) FOR SERVICE_BROKER ( AUTHENTICATION = CERTIFICATE MasterCertificate ) GO GRANT CONNECT TO CertOwner GRANT CONNECT ON ENDPOINT :: MyEndpoint TO CertOwner GO And my routes like so: GRANT SEND ON SERVICE :: [tcp://mydomain.com/INITIATE/MyService] TO CertOwner GO CREATE REMOTE SERVICE BINDING [MyCertificateBinding] TO SERVICE '[tcp://mydomain.com/TARGET/MyService]' WITH USER = CertOwner , ANONYMOUS = OFF CREATE ROUTE [tcp://mydomain.com/INITIATE/MyRoute] WITH SERVICE_NAME = '[tcp://mydomain.com/TARGET/MyService]' , BROKER_INSTANCE = N 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx' , ADDRESS = N 'TCP://xxx.xx.xx.xx:4022' GO Tag: How to create Vertical Partioning
  - 8
    - Distinct Count with Junk Dimension Attribute Hi, Suppose I have following Model Dimension which is formed based on Junk Dimension definition. JunkID ModelID ModelCode ModelTypeID ModelTypeCode ModelSpecificationID ModelSpecificationCode 50 50 BAO 2 FFCVT 2 F1C1 53 53 BGO 1 FFAT 1 FW4A4 55 55 NBO 3 FRAT 9 V4A5 60 60 NCO 3 FRAT 9 V5A5 97 55 NBO 3 FRAT 11 V4A5 99 53 BGO 1 FFAT 13 F4A4 And In Fact Table Suppose there is data as below... JunkID Amount 50 5210983 53 9576 55 7994 60 7872 97 4306 99 6519 Now my requirement is to make Distinct Count on ModelID. If I makes Distinct Count on DimModel.ModelID then it gives me 5 on every combination in Cube. If I make Distinct Count on FactTable.JunkID then it gives me 6 in places of 5 as above seen data. Please help, how can I make Distinct Count on ModelID in this situation Thanks in Advance Bhudev Tag: How to create Vertical Partioning
  - 9
    - Trying to set output variable to row count result of SQL Execute Task I am building this as an expression, but it is not working. I am trying to return the row count into a variable to use later in an update statement. What am I doing wrong I am using a single row result set. I have one variable defined in my result set. I am receiving an error stating: Execute SQL Task: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_SingleRow". Any help is appreciated! SELECT count(*) FROM hsi.itemdata a JOIN hsi.keyitem105 b on a.itemnum = b.itemnum JOIN hsi.keyitem106 c on a.itemnum = c.itemnum JOIN hsi.keyitem108 d on a.itemnum = d.itemnum WHERE a.itemtypegroupnum = 102 AND a.itemtypenum = 108 AND b.keyvaluechar = " + (DT_WSTR,2)@[User::Branch] + " AND c.keyvaluechar = " + (DT_WSTR,2)@[User: epartment] + " AND d.keyvaluesmall = " + (DT_WSTR,7)@[User::InvoiceNumber] + ") Tag: How to create Vertical Partioning
  - 10
    - How can I set SO_TIMEOUT on the sockets used by the JDBC 2005 driver? Hello, One of our customers is experiencing a problem that makes me think there is a network problem, because we make a request and never return from the driver, but the transaction is still open on the server awaiting the next command (and holding locks blocking other processes). I see a number of other driver writers have described similar problems, and their "workaround" is to set SO_TIMEOUT on the sockets (setSoTimeout) they create which is a last defense so that the transaction won't block forever. I do not see this in the API documentation- how can I set this Many other drivers use a connection string parameter, do you offer the same Is there any logging I can enable that can show me for sure that the driver is waiting indefinately on socket.read (thats not terribly expensive) Thanks, Steve Tag: How to create Vertical Partioning
  - 11
    - xquery - order by problem Hi! In MSS Management Studio it is very irritating that queries not can be sorted. So I looked at the ssmssqlproj-file. I want to order by filename, but: declare @x xml ; select @x = '<LogicalFolder Name="Queries" Type="0"> <Items> <FileNode Name="updateTbl.sql"> <AssociatedConnectionMoniker /> <AssociatedConnSrvName /> <AssociatedConnUserName /> <FullPath>updateTbl.sql</FullPath> </FileNode> <FileNode Name="insertTbl.sql"> <AssociatedConnUserName /> <FullPath>insertTbl.sql</FullPath> </FileNode> <FileNode Name="selectTbl.sql"> <AssociatedConnUserName /> <FullPath>selectTbl.sql</FullPath> </FileNode> <FileNode Name="deleteTbl.sql"> <AssociatedConnUserName /> <FullPath>deleteTbl.sql</FullPath> </FileNode> </Items> </LogicalFolder>' ; --select @x.query('for $item in /LogicalFolder/Items -- return count($item/FileNode) ') select @x . query ( 'for $x in /LogicalFolder/Items/FileNode order by $x/FullPath return $x ' ) --for xml path(''), root('LogicalFolder'); --Msg 2389, Level 16, State 1, Line 29 --XQuery [query()]: 'order by' requires a singleton (or empty sequence), found operand of type 'xdt:untypedAtomic Can anyone help Thanks Bjorn Tag: How to create Vertical Partioning
  - 12
    - Very hard question on how to query data and return by months I have a data set that returns the following Customer pncount pn% monthval ABC 5 30 01/01/2007 DEF 9 20 01/01/2007 GHI 4 40 01/01/2007 ABC DEF 4 90 02/01/2007 GHI 7 10 02/01/2007 ABC 4 5 03/01/2007 DEF GHI 6 100 03/01/2007 but I need this 01/01/2007 01/01/2007 02/01/2007 02/01/2007 03/01/2007 03/01/2007 abc 5 30 4 5 def 9 20 4 90 ghi 4 40 7 10 6 100 Any Idea Help Tag: How to create Vertical Partioning
  - 13
    - Database attach at setup Hello, Our product has a MDF file included with the setup, this needs to be attached at the current SQL Server (Express or not). Where can we copy the MDF file during setup so it can be attached successfully We need a place where the account SQL Server is running under has write permissions. Please help ! Thanks Tag: How to create Vertical Partioning
  - 14
    - File System Watcher can not read excel from SharePoint I used file system watcher to read excel on my pc it worked fine, but when I tried to read the excel from SharePoint it did't work. The FileWatcher box showing the yellow color for long time that I had to stop the ssis. So my question what is the cause of this. Do i need to set something or am i missing something Please help. Tag: How to create Vertical Partioning
  - 15
    - how to set date field in sql server 2005 table hi friends i wish to set a date data type to a column "Date". when i use datetime format, the values is inserted in the U.S. date & time format. i want the values to be in the british english format. i.e dd/mm/yyyy only and does not require time value. can any one help me to insert the date values in the british english format regards.., sekar. Tag: How to create Vertical Partioning
  - 16
    - SQLSTATE 42000- Error 15404 with ADS Hello, I'm having trouble running jobs with my active directory (ADS) account. I've setup my SQL services to run under an ADS account, but jobs cannot seem to query ADS for user information. We're running Windows Server 2003 and SQL Server 2005 SP2. Here is the error message: == The job failed. Unable to determine if the owner (ADS\me) of job eFASRtest has server access (reason: Could not obtain information about Windows NT group/user 'ADS\me', error code 0x5. [SQLSTATE 42000] (Error 15404)). == also this message in log: == [298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'ADS\me, error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin) == I already tested the suggested: execute as login='ads\me' and I get the same error on both (my local installations and production) appreciate your help Tag: How to create Vertical Partioning

TJ_1

Hi All,

I setup a Transactional replication between SQL Server 2000 and SQL Server 2005 via
wide area network.

The intial snapshoot failed because run into problems on a table with column 379 columns.

How do ceate Vertical Partioning a table on Publication

Thank you.
TJ_1

Top

Re: How to create Vertical Partioning

Gary Chen

You can take a look at

How to: Define and Modify a Column Filter (Replication Transact-SQL Programming)

http://msdn2.microsoft.com/en-us/library/ms146925.aspx

Gary

Top

Re: How to create Vertical Partioning

TJ_1

The link is not working!!

Top

Re: How to create Vertical Partioning

Gary Chen

Try again, it should be working now.

Gary

Top