Viewing 15 posts - 196 through 210 (of 1,335 total)
you can use this simple script written by me to script your user and object permissions. the script is available in the link given below.
http://www.sql-articles.com/index.php?page=Scripts/scrip_user_05.php
February 8, 2008 at 4:19 pm
There is a option in profiler to specify when to stop tracing data. Can't you use that to stop your profiler activities.
February 8, 2008 at 4:16 pm
use sp_attach_single_file_db to attach only the mdf file to the database server so that a new ldf file is created once the mdf is attached.
February 8, 2008 at 4:14 pm
You can use the import/export wizard to do this for u. that would be the easiest way that i look ahead.
February 8, 2008 at 4:12 pm
Regarding your tempdb sizing you can use the alter database command to size it and then you need to restart sql services.
February 8, 2008 at 4:10 pm
Yo have memory related DMVs now in 2005.
February 7, 2008 at 5:29 pm
Reinstall MDAC with the latest SP.
February 7, 2008 at 5:27 pm
If you have a msdn user account use the virtual labs there is a wonderful session that describes how to use SSMS.
February 7, 2008 at 5:26 pm
in 2005 you have the xml datatype see how you can use that to help for you.
February 7, 2008 at 5:24 pm
what is the exact error tha you get when the backup command is fired. it might be something to do with permissions.
February 7, 2008 at 5:22 pm
Is your tape backup running and have you configured this file in the tape backup if so then you might get this error.
February 7, 2008 at 5:20 pm
Are both the servers running under localsystem account then u wil not be able use the linked server. yo can do the way given below.
1. create a windows user account...
February 7, 2008 at 5:16 pm
Check if remote connections are enabled. Also check if you have necessary rights to delete the plan.
February 7, 2008 at 5:14 pm
You can't do that way. its better u code that as a SP.
February 7, 2008 at 5:11 pm
Viewing 15 posts - 196 through 210 (of 1,335 total)