You can do backup and restore and then run delete statements according to your criteria. Another option is go generate the scripts, run the scripts and then import the...

Beside connection pooling it could also be a situation that a user has few connections. He closed one of them, but still has other open connections and those are...

pratyush.singh.chandra (11/19/2008)

---

how to run this query in window authentication mode can any one give the suggestion

EXEC master..xp_cmdshell 'bcp "SELECT * FROM persondb..[company]" queryout d:\mushi.txt"" -U sa -P -c...

This is one of the cases that you can do a very quick test to find out how it works instead of taking the word of me or anyone else:-)....

One more option is to use OSQL (from command line or from SQL Server with xp_cmdshell).

Adi

The code bellow will update the records that you wanted to with you example, but I’m not sure that it is what you want. In your explanation, you wrote...

Chris Morton (11/19/2008)

---

Hi Guys/Girls

i have this sp:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:????????

-- Create date:

-- Description:????

-- =============================================

CREATE PROCEDURE LrandomiseData --'cALLDISPOSITION', 'CALLDISPOSITIONID', NULL, null

...

Thank you for notifying me. Just fixed it.

Adi

You showed us only part of the code. You need to show us all the relent code. Since you mentioned in your message that you worked with stored...

You can use case statement to check the amount of days that passed and then use the same case statement in the group by clause. Here is an example:

--creating...

AFAIK there is no such limit to a...

Not with SQL Server 2005. You can create an indexed view on the table that will have a unique constraint and will not include NULL value, but I have...

The automatic failover is very important different. Beside that there are other differences. Log shipping is always asynchrony. Mirroring can be synchrony or asynchrony. You can...

SQL Server locks and unlocks the records for you, so you don’t really have to do it in your code. The subject of locking is to long and complicated...

Mani (11/16/2008)

---

Hi,

Iam running the above stored procedure as job from sqlagent. The job history shows the job was success and has no errors, eventhough the msdb database not backedup!

why its...