i believe bigint will take much lesser space than varchar and when you have huge number of records in the table, there would be a significant performance improvement especially since...

sp_help 'table_name' would give you table structure details- column names, data types, length etc.

No Clues... Cant find anything on net as well!!:hehe:

all of these messages relate to .NET only.. No reference to SQL Server.. May be a bug in the system!!

what version are...

I really cant segregate locks as 'good' or 'bad'. There are various types of locks used for different purpose by the sql server.

Can u elaborate more on what u're...

This looks more like a .NET error??

Can u check job's history? are you getting same error there too?

This is the default behaviour of identity column. You can force a specific value in identity column by setting identity_insert property to ON.

Other way to achieve this is by dbcc...

You can take cues from Divya Agrawal's article:

http://www.sqlservercentral.com/articles/SQL+Job/66421/

Great!! you got the trick 🙂

Steve - I'm using RTM Developer edition.

I tried saving also but it didn't resolve things. only when i re-selected databases drop down, it resolved.

I just tried that, it didnt include the new...

DECLARE @command VARCHAR(5000);

SELECT @command = 'Use ['+ '?'+ ']

Select @@servername AS ServerName,

CAST(sysfiles.size /128.0 AS int) AS FileSizeMB,

sysfiles.name AS LogicalFileName,

sysfiles.filename AS PhysicalFileName,

CONVERT (sysname, DATABASEPROPERTYEX( ''[?]'' , ''status'' )) AS Status,

CONVERT...

Above post is not correct.. Apologies..

still working on it..

DECLARE @command VARCHAR(5000);

SELECT @command = 'Use [' + '?' + ']'

Select @@servername AS ServerName,

CAST(sysfiles.size /128.0 AS int) AS FileSizeMB,

sysfiles.name AS LogicalFileName,

sysfiles.filename AS PhysicalFileName,

CONVERT (sysname, DATABASEPROPERTYEX( '?' , 'status' ))...

You're welcome:-)

Glad I could be of some help 🙂