CREATE LOGIN [MyAlternateSA] WITH PASSWORD=N'Super$ecr@PwD' , DEFAULT_DATABASE=[master], CHECK_EXPIRATION=ON, CHECK_POLICY=ON;

EXEC master..sp_addsrvrolemember @loginame = N'MyAlternateSA', @rolename = N'sysadmin';

Great addition Lowel :w00t:

Now all OP has to do is copy/paste and hit F5.

One last remark, if these tables contain many rows and you cannot perfrom "truncte table ..."...

abhishek.c1984 (7/23/2009)

---

ok thanks for the reply....

Actually iam using hibernate, it will take care of such activities...

w.r.t your opinion i have create a sample JDBC connection as shown below, but iam...

use at your own risk 😉

You could use this to start with

Select 'Delete from [' + TABLE_CATALOG + '].[' + TABLE_SCHEMA + '].[' + TABLE_NAME + '] where...

BP is always to specify the database name you want to connect to (don't rely on the logins default database ! A sql instance can host multiple databases !)

Check out...

abhishek.c1984 (7/23/2009)

---

thanks for the reply,

I have just executed the query in SQL Server 2005, it worked fine...but the database connection was broken

-------

Nonqualified transactions are being rolled back. Estimated rollback completion:...

abhishek.c1984 (7/22/2009)

---

... "some active connections.........."

So before going ahead, i need to close the active connections and then proceed further.......So, in such cases is it possible to make forced backup and...

with Sp_lock it will provide you the spid that has the lock.

To get to see the last statement that spid is executing,

select est.text

FROM sys.dm_exec_sessions ES

left join sys.dm_exec_requests ER

on...

Which driver are you using ?

Are you (or the driver by default) using implicit transactions ?

A backup/restore operation cannot be incapsulated with a transaction.

If a restore fails, the db...

be sure to implement FK-indexes for the columns KeyWorkerId and CoWorkerId.

maybe you can even skip the isAgency column.

Implement a constraint to check on the combination coworkerid and agencyname

if coworkerid not is null, agencyname must be null

and the other way...

Things like dbmirroring, dbMail, or Service broker may cause msdb to grow.

e.g.

SELECT @@servername as Q_001_MSDB, COUNT(*) as nRows from msdb.sys.transmission_queue ;

I have only done some tests with DBmirroring.

I don't have actual experience with many mirrored databases of the same insatnce.

I just wanted to let you know MS customer advisory team...

I was just checking my mail and had a couple of minutes spare for SSC :hehe:.

Most of the times mail and SSC come together.

Have a nice (remaining)weekend.

Indeed, but the uncleanly "detached" files will only be a part of the problems.

Everything performed a instance level , logins, jobs, end points, instance level triggers, ... will have to...