Greg Edwards (12/11/2008)

---

Grant Fritchey (12/11/2008)

---

If it makes you feel better I've been hit, while stopped, not stopping, I've been sitting still, waiting, four times over the last 10 years. ...

To even attempt to get it working, you would have to set trustworthy on, grant unsafe assembly to the database owner, and then try manually registering the DLL's as assemblies...

Follow what Nicholas recommended. There is no reason to incur downtime on the database when a backup/restore process will accomplish the same thing, in a similar amount of time.

Moderis,

In an environment of that size, automation is going to be your key. You can go out and spend thousands of dollars licensing tools to do the job for...

SSIS works exactly the same way. When you call it from your machine in Enterprise Manager, the local DTExec is called and it runs the package from the server...

You can find an example trigger in the Books Online:

http://msdn.microsoft.com/en-us/library/938d9dz2(VS.80).aspx

ritesh.saluja (12/10/2008)

---

I have SQL CLR project with following method.

Microsoft.SqlServer.Server.SqlTrigger(Name:="AuditCommon", Event:="FOR UPDATE, INSERT, DELETE")

Public Shared Sub AuditCommon()

I am getting error as mentioned below.

ErrorThe method "AuditCommon" in class "AuditCommon.Triggers" marked as...

I HAVE to do my annual Modern Army Combatives refresher once a year, and that is enough rough housing to last until the next time I have to do it....

First as Madhu posted, get your deadlock graph and post that here. To do so, on SQL 2000 enable trace flag 1204:

DBCC TRACEON(1204,-1)

on SQL 2005 use 1222 instead:

DBCC TRACEON(1222,-1)

This...

Make sure you turn off Autoshrink if it is on while you are in the options.

I haven't seen that, but it sure would be funny.

Timothy Ford (12/9/2008)

---

I think it speaks towards how we are as a community that we don't shoo "newbies" away with some of the various rude comments you do see on...

There is no information in this post as of yet that actually attributes a problem to CLR other than the statement by Dean that CLR was causing the problem. ...

Dean Jones (11/11/2008)

---

I ran

SELECT

SUM( multi_pages_kb +

...

smunson (12/5/2008)

---

If you're seeking file details, such as filename, file size, etc., why not use xp_cmdshell and run a VBScript that can get that information? It might have...