Good news: there's a SP3 Beta!! http://www.microsoft.com/downloads/details.aspx?FamilyId=D22317E1-BC64-4936-A14B-7A632B50A4CA&displaylang=en What's...
Hi All, Is this a Bug in SQL 2005 I wants to keep select into/bulkcopy and trunc. log on chkpt. Option on but as soon as I turn on trunc. log on...
Hi AllI have a unique situationWe have a table wilt around 4 million+ records and growing 100k + per monthAnd we are planning to add around 26 new...
Hi All, Our current production SQL Server is SQL 2000 sp4 And soon we are planning to migrate to SQL 2005 sp2 We have a unique situation We r using...
Hi I have two tables History and Defination and Definafoin has Pk on DefID History has 25,000,000records and Defination has 50,000 I have a procedure...
We are planning to split our 2005 databsae into smaller databases. our biggest problem in this design i how to maintain cross database referential...
Hi all I tried forllowing XQuery and it's working fine DECLARE @Name nvarchar(100)SELECT @Name = 'Calvin'DECLARE @xmldoc xmlSET @xmldoc = '<Root>...
Hi All, I have a web user. Who can only execute procedures in web db.In SQL 2000 and before this normal user used to insert error message in...
Hi AllI have a excel file. It contains three columns 1st column contain table name 2nd column contains flag which tells me to transfer all, none...
Hi All I have a table without Cluster INDEX on it ti hase primary key noncluster Index which i wats to convert to Cluster INDEX what is the best way...
Hi EverybodyRecently I started to look at SQL 2005. And I am Impressed with some of the new features in it.I have one question about OUTPUT Clues.In...
Hi I wants to explore Pivot cluse SQL 2005 I have a table tbl1( col 1 decimal, col 2 decimal, periodending datetime ) O/P i wants in this format...
Hi all I have a table with almost 4 mil rows has a cluster index on a non unique column this table have havy Insert/Update abd Select operation I...
I have a table with 20 columns in it with 70 million records I want to add 2 new column's in between column 8 and 9 not in the endI can do it with...
Hi, I have following procedure CREATE PROCEDURE testprocEXECUTE AS LOGIN = 'testuser1'EXEC sp_addmessages '50001,16,'Test Message'REVERTI am trying...
Hi I created a procedure which accepts XML parameter. My front end application creates this XML and passes it to my Procedure For smaller XML...
I am new to XQuery I am running this query against the XML shown belowSELECT a .b.value('TradeId[1]','VARCHAR(500)') as TradeId,a...
HiI created procedure and grant execute permission for that proc to webuser webuser has only execute permission for this procedure.Inside procedure I...
Hi I am trying to create a new function in SQL Server 2005 Enterprise edision and passing two parameter Create Function f( @Type INT = 0,...
Separate names with a comma.
