I have to be careful not to harm any of the legitimate work, like creating invoices so the firm gets money and I get paid, with whatever I do.  Some of...

I don't have sp_lock2. 

So, I should monitor the space used in tempdb and if it reaches a certain percent start saving the results of sp_lock in a table and...

Temp tables are stored in tempDB.  Is your table called "@@New table" or "##New Table"?  If it is @@New Table it is a table variable stored in memory.

What I would do in this case is use the Debugger tool that is part of Query Analyzer in your development

environment.  Maybe you have a subtle logic error that you...

This happened to me on two servers after I modified the start up accounts.  Here is a link that has some good information.

http://www.extremeexperts.com/sql/FAQ/EnablingPerCounters.aspx

In my case, I had to start at...

It is possible that the SQL service is stopped or that even the server itself has crashed.  What I would do in your situation is try to log on to the...

I guess it depends on what you are collecting data about whether the dates are craptastic or not.  If I was setting up a database about some historical information or...

See if this helps:

USE [2test]

GO

DBCC SHRINKFILE ([2test_log], 1)

I've done the copy master.mdf several times and recommend that.  Any time the network admin guys are doing any hardware work on the SQL Servers, I shut down SQL and copy all of the system db's...

You probably have some data in your Access tables that SQL doesn't like.  For example, Access will accept a date of '1/1/1000' , but the same data is invalid in...

I thought this was one of those times that a cursor was a perfect fit, but as I was falling asleep I realized the correct answer.

declare @count int

set @count =...

Here is some code that should work for you, I don't your table name so I just called it Pages:

declare @id int, @Document varchar(15), @lastDocument varchar(15), @page varchar(1000), @lastID int

declare...

I applied SP1 for Reporting Services.  I it wasn't difficult nor did any bad things happen.  I think there is an SP2 coming out if it is not out already.  It...

In Access you have to use the keyword 'As' when aliasing a column.

max(x1.Subaddeffdate) As Subaddeffdate

Check out this MS article:

http://support.microsoft.com/?scid=http://support.microsoft.com%2Fservicedesks%2Fbin%2Fkbsearch.asp%3Farticle%3D322746

It says that SQL Agent may not be able to find DTSRun.exe.