Viewing 15 posts - 571 through 585 (of 1,335 total)
If there is 772MB free then you can shrink the master DB but as Jeff suggested take a backup of the database before that.
July 16, 2007 at 12:27 am
Did you try typing something in the window might be it would have got connected. Check that and let know.
July 16, 2007 at 12:20 am
Can't that be done with SSIS?
July 15, 2007 at 11:57 pm
Edition upgrade can be done in SQL 2000 following the steps given in books online. YOu will have to run the setup and follow the steps given there.
July 14, 2007 at 11:22 pm
Yes as Carl suggested its better to scripts jobs, schedules, etc and then run against the server you want rather than restoring the msdb database. You will need to take...
July 14, 2007 at 11:21 pm
But why do you want to shrink the system databases. If you find any wanted tables then check and remove them. There will be no huge space occupied by your...
July 14, 2007 at 11:20 pm
Any firewall in the production box. Check that and let know.
July 14, 2007 at 11:16 pm
Use the tool given in link below they are useful to scriupt and move your linked servers.
http://www.codeproject.com/cs/database/ScriptLinkedServers.asp
July 14, 2007 at 11:14 pm
Check if this helps you
http://blog.sqlauthority.com/2007/05/20/sql-server-scriptfunction-to-find-last-day-of-month/
July 13, 2007 at 7:36 am
Sure there should be a way to check this but MS has kept it internal and does not reveal to the user. But in 2005 you can get these details...
July 13, 2007 at 7:33 am
Try to use the money data types. Exclusive help available in BOL for money data type.
July 13, 2007 at 6:12 am
Positively you should get this resolved by editing some registry keys. Check the folder Microsoft SQL Server to find the right key and get things solved.
July 13, 2007 at 6:00 am
What about logshipping or db mirroring?
July 13, 2007 at 5:58 am
The service account on both servers should be domain account else a local account with username and password same in both the servers and called as .\accountname in the service...
July 13, 2007 at 5:39 am
Why not import export. Why not backup the database and restore the database and change the compatibility level to 90 to have sql 2005 features.
July 13, 2007 at 5:26 am
Viewing 15 posts - 571 through 585 (of 1,335 total)