Hi,

What is being returned to @weeknumber before you try the SET @WeekNum = 'SELECT * FROM w' + @weeknumend?

Regards

Stephen

Hi,

The previous link is very useful, or you can

http://social.technet.microsoft.com/Search/en-US/?query=Error%20messages%20sql%202005&ac=8

This is the same just searching for error massages for SQL 2005.

Regards

Stephen

If you have dropped the master key for that database, and recreated it. Meaning created the same one again, you should take you database online and offline to enable the...

Hi,

As Hakan stated before,

Check all running jobs through that time period. To me it also sounds like BACKUPS or INDEX REBUILDS.

If you can find anything running during that...

Hi There,

Why don't you use VARCHAR(MAX) this can take way more then the 4000 you are trying to use now.

stay away from ntext can cause other issues down the line.

Hope...

Good Day,

Using the name master for a database name is not the best idea, as this is the same as the system databases.

If you created the tables inside the MASTER...

Hi,

You can use option 2 where you create a SSIS package and populate a table.

Create the table with the information you request then add a new column on with...

Hi,

In MS SQL Server Management Studio, right click on the server and click on Properties.

This will bring up a new window and you will see "Name"

Regards

Stephen

Hi

What is the error code it gives you with the last error??

Hi,

Ok This means that your original job to shrink is still running in the background.

Do a sp_who2 and a sp_lock to see which process is holding that database. then once...

Hi,

Try to shrink file instead of database, this would make the file shrink.

If this does not help, then you must see what the initial size of database(datafile) is set to.

Good Day,

You can use the "BEGIN TRAN" and "COMMIT TRAN" OR if you need to rollback then just use "ROLLBACK"

BEGIN TRANSACTION @TranName;

GO

USE AdventureWorks;

GO

DELETE FROM AdventureWorks.HumanResources.JobCandidate

WHERE JobCandidateID...

Good Day,

Try and put square brackets "[]" around Second Database, it could be the space between the two names that is causing the issues.

You can also try and remove the...

I would agree, straight conversion from Query to Stored Proc would not stop dead lock.

Rather get the queries working right then convert them to a stored procedure.

GilaMonster (7/15/2008)

If...