I think the datetime can't read this statement as date

"2008-02-25T12:36:36.1804709-06:00".

If you want the date only you can use SUBSTRING to get just the first ten (10) values in the...

Answers:

1. You must declare the varchar inside the osql -Q (query)

example osql -E -Q "declare @body varchar(20) set @body = 'hello world!!' select @body'

2. As long as you have enough...

Just be aware that your...

YEs this script is intended to be executed in Query Analyzer

Yeah that can also work 🙂

If the Server in the enterprise manager in the users computer is registered using the user "sa" then he can access all the databases even restricting him since the server...

Yep it is not recommended to shrink the data but you can truncate then shrink the log files

"OK! I performed a restore and that error is not appearing now! Just...

Andras Belokosztolszki (1/22/2008)

---

A simple question: does this folder actually exist on the server on which SQL Server is running? The xp_cmdshell is executed in the security context of the SQL...

Be warned when restoring since after migration users accessed the database. Examine if they insert, update...

You're Welcome 🙂

Is that a backup before you migrated the databases to the new server or backups after you successfully attached the databases to the new server?

Please see this link

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67564

its almost the same as your problem i think there is a corrupt issue with it. Do you have a backup of the databases??

For data i used dbcc showfilestats

use tempdb dbcc showfilestats

-- For DB Size : (totalextents*64)/1024

-- FOr DB Used : (usedextents*64)/1024

-- For DB Free Space :

--((totalextents*64)/1024)-((usedextents*64)/1024)

FOr log i used...

In my situation when we are migrating production databases to another server what we do is..

1. Change the IP address of the production server so that no transaction will enter...

You can backup all the databases (55 database) then restore in the new server just be reminded of the user log-ins when transferring databases from 1 server to another there...