Assuming the DBCC inputbuffer shows nothing or little the short answer is no.

Kill the proc, rerun the offending code while you have a trace running.

We've implemented some mild server...

In Oracle it's something like: select something from dual;

To see what the code is doing, you could print the string or "select" the string in SQL like this:

declare @mayrto varchar(5)

set...

Have a look at the remote proc trans setting, is it on?

x3 for not using the backup/restore method...

Generally speaking changes are migrated to production databases by duplicating the steps in prod that were made in dev. The changes should be documented...

Richard, What is "some process" trying to do? I've seen thousands of connections to a server without slowing it down to any noticable degree.

In some cases the front end (...

Not sure about the "UNK" but this may help

http://msdn.microsoft.com/en-us/library/aa275699(SQL.80).aspx

RTblVersions stores version information about repository objects.

http://msdn.microsoft.com/en-us/library/aa275694(SQL.80).aspx

RTblIfaceDefs contains one row for each interface that is defined in a...

As with any plan you need to decisively come up with what you are trying to do.

If you are looking to split the load for performance reasons, there are easier...

How are the data loads being done? Java front end app with a JDBC connector?

We had issues with a datastore that is also used for reporting that had some horrible...

I'm a little confused. Backup the directory to where? Zip?

It looks like you want to zip the contents of a dir. You would need to create a stored procedure that...

Ken,

Try here:

http://www.databasejournal.com/features/mssql/article.php/1478701

Even has a script to download to copy permissions from a group.

Now, That being said, question the task, it will make you all the wiser. If...

Sounds like the AD admins need to take a lesson from you on house cleaning. Definately something to bring up at the next IT meeting.

In the mean time try this:

Ah, so your system dbs are located on the D: drive?

I haven't had to do that in a while but this should get you going.

The system dbs are moved like...

Tom, Standard practice in a lot of places is to disable for 30 days and delete after 60 or 90 days. It sounds like you have the SQL end covered...

Paul, Are you a dba or infra person or both?

We have multiple SQL servers on VMware and have moved them on multiple occasions.

If the machine will have the same name...

Stephen, If you schedule a job from the local packages folder by right clicking, it will give the guid to the step, but if you create a new job from...