Do you have a backup of your database? If so, start by backing up your transaction log now and then restore the database to a different location and apply...

Yes, we can help. But we'd rather you attempted it yourself. We can't do all your debugging for you. You need to understand what the code does,...

Please don't post the same question twice. It wastes your time and ours. Answered here:

http://www.sqlservercentral.com/Forums/Topic446786-146-1.aspx#bm446789

John

I'm sorry, but this doesn't make any sense to me. Please will you post your table structure in the form of a CREATE TABLE statement, and some sample data...

Can you show us what you've tried, and then maybe we can point out where you're going wrong? Otherwise it's too much like we're doing all the work for...

Be warned that if you change the collation of the database so that it is different from the rest of the server, and your application uses temp tables, you could...

OK, I'll take your word for that, since I never tried it in SQL Server 2005, and the option isn't available in SQL Server 2000. You still have to...

Steve

I back up my database to disk, then I restore to a different location using WITH MOVE. That would work, wouldn't it, and with no manual copying of files?

John

Backup and restore may not be the fastest option (although if you have very large database files with very little data in then there won't be much in it) but...

(1) This gives the total size of the database files, including free space within those files

(2) This gives the sizes of the individual database files, including free space

(3) The size...

Try COALESCE or ISNULL.

John

I think dynamic SQL is your only option to get round this somewhat dubious database design. Something like this:

DECLARE @sql varchar(1000)

SELECT @sql = 'SELECT * FROM ' + TableName

FROM...

Try SELECT @StartTime = GETDATE(). You should declare @StartTime and @StopTime as datetime rather than varchar.

John

Ram

Absolutely. I'm not preaching the supremacy of any language. But if you don't express yourself clearly in the language in which you have chosen, for whatever reason, to...

But if you don't express yourself clearly, then how can you be...