Viewing 15 posts - 1 through 15 (of 58 total)
You can use the below link to get a basic understanding about partitioning in SQL 2008:
http://msdn.microsoft.com/en-us/library/ms191133.aspx
It has sample scipts from Microsoft as well
September 9, 2010 at 1:24 am
Hi, If you really want to shrink your db, you can do it in the following ways:
1) DBCC SHRINKDATABASE (DBNAME, 10) ---> Here you dont have the option of...
August 31, 2010 at 8:28 pm
or even CONVERT(VARCHAR(??),a.BAN) = s.BAN 🙂
August 30, 2010 at 3:34 am
Hi, the first thing we would need to investigate is why are the dbs being stated as offline. Are you able to connect through SSMS as mentioned above? Is there...
August 30, 2010 at 3:01 am
you would want to write a cursor or any row operator that will loop through sysxlogins, generating a syntax using sp_droplogin, and then executing them either separately or in the...
March 29, 2010 at 11:55 am
How many rows are affected in this delete? Would it be possible to convert this delete query to delete in batches, in case the number of affected rows is extremely...
March 29, 2010 at 11:25 am
Hi Brandie, since he knows the max size the log can reach, is it not ok to keep the initial size and max size the same with auto shrink disabled?...
March 29, 2010 at 11:13 am
I am not sure if you get the database roles, aliases for dbo if u script users that way.. please confirm it
October 28, 2009 at 1:23 pm
If it is logins that u r referring to, there are 3 aspects which you need to consider:
1) the login names and passwords ( this is available in...
October 28, 2009 at 1:00 pm
Hi Pradeep, thanks a lot for your response..
Me doing gr8.. how r u doing .. 🙂
My intend is to lock a login on a DR server, if it is locked...
March 16, 2009 at 1:24 pm
revlogin script moves logins, passwords and server roles but there are other server level permissions like grant alter to login etc which is not done in the revlogin script but...
February 7, 2009 at 9:15 am
Adding a post to bring this one on top so that someone would take a look at the script and provide suggestions.. 🙂
February 7, 2009 at 4:05 am
The reason is that you have given grant statements to certain logins to specific obects ( in the securables tab when you double click a login.) It would be great...
February 6, 2009 at 12:48 pm
Hi, I am still in the process of doing the same task. Now that the logins, passwords and server roles have been moved, I need to move the server level...
February 6, 2009 at 9:54 am
Thank you so much.. I will follow this approach as well in the scripts I will be creating as well.
January 31, 2009 at 10:31 am
Viewing 15 posts - 1 through 15 (of 58 total)