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

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...

or even CONVERT(VARCHAR(??),a.BAN) = s.BAN 🙂

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...

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...

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...

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?...

I am not sure if you get the database roles, aliases for dbo if u script users that way.. please confirm it

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...

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...

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...

Adding a post to bring this one on top so that someone would take a look at the script and provide suggestions.. 🙂

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...

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...

Thank you so much.. I will follow this approach as well in the scripts I will be creating as well.