It's a horrible design but it sounds like you want something like the following:

USE master

--Create temp table for use as array

Declare @tbl table (RowId int identity(1,1), DBName varchar(30))

CREATE TABLE #fileexist...

There's at least one scenario in which I'll avoid placing a primary key on a table.  It has already been stated that when you are loading data from external sources...

I don't have any sites for you either but I do have to weigh in with the people who've already posted.

• The vast majority of people who write front end and...

sp_executesql will reuse compile query plans but it doesn't benefit from pre-compiled query plans like stored procedures do.  If you only have two parameters beind passed to your procedure then...

Based on your description of what you are doing, I'd lean towards not creating a clustered index.  Remember the clustered index determines the order in which the data pages are...

Go flying.

Or if you have a girl friend who wants to get away for the weekend, go to the beach.

I ran into a problem which reported a similar error in the past.  In my situation I was transfering databases between servers (production and development), when I would attempt to...

Sure...

Is the database set to "Auto Shrink", if so is there a process which deletes records in the evenings?

It's even possible there's no process which deletes records but rather a...

You'll need to provide additional information to get an informed answer.  What type of backups are you doing?  Full backups, differential, log?

If you are doing full backups then the only...

You didn't say what the error was you were getting so it's going to be very difficult to assist you.  You can, however, look at this thread for some information...

Remember this phrase, "Security Context".

SQL Server is a service just so it requires you to create an account on your OS so that it can login to the OS and...

What's so complicated about sp_executesql?

DECLARE @DatePart VARCHAR(4), @DynamicSQL NVARCHAR(4000), @ReturnDate DATETIME

SET @DatePart = 'yyyy'

SET @DynamicSQL = 'SET @ReturnDate = DATEADD(' + @DatePart + ', 2, GETDATE())'

EXECUTE sp_executesql @DynamicSQL, N'@ReturnDate DATETIME...

One of our servers has over 400 databases on it, we do nightly backups using a full/differential methodology so you can imagine the amount of space consumed by the backups....

The moral of the story is:

NULL + (anything) = NULL

Ever hear of a bigint data type?

You mean the 8 byte integer?  The one that is only 8 bytes smaller than the uniqueidentifer instead of 12 bytes smaller?  Sure I've...