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
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
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.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
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.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
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.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
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.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 8, 2008 at 4:10 pm
Yo have memory related DMVs now in 2005.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 7, 2008 at 5:29 pm
Is this error occuring in the client side?
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 7, 2008 at 5:29 pm
Reinstall MDAC with the latest SP.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
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.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 7, 2008 at 5:26 pm
in 2005 you have the xml datatype see how you can use that to help for you.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
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.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
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.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
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...
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 7, 2008 at 5:16 pm
Check if remote connections are enabled. Also check if you have necessary rights to delete the plan.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 7, 2008 at 5:14 pm
You can't do that way. its better u code that as a SP.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 7, 2008 at 5:11 pm
Viewing 15 posts - 196 through 210 (of 1,335 total)