Just going over my lecture notes on Citizenship in the Nation, which deals mainly with the US Constitution I somehow failed to find any reference to the federal govt.'s authority...

Nader,

I would suggest that you research a clustered index a little more. Your are in the circle but not dead on in the middle of the target. A table...

Angi,

Yes truncate the tables. Use with sp_msforeachtable to make a one liner something like

sp_msforeachtable 'truncate table ?'

This may need some tweaking, sorry I don't have a db to...

To add to Robert's reply. I usually have a windows account set up for my servers and use this user account as the owner of the sql and sql...

I agree with Ray. When faced with a job like this you can use a forfiles to process the file and in the last step for the file, move the...

I saw no mention of disk configuration in your original post. How many and what kind of drives do you have your database spread over? Also how does...

Sumanta,

It is possible to run both SQL Express and SQL Server side by side on the same machine. There is no "upgrade key" for SQL Express to SQL Server,...

Check this link. http://msdn.microsoft.com/en-us/library/aa197071%28SQL.80%29.aspx

Seems to cover the ground. I have only renamed the default instance with a reboot to make the change.

Good luck,

John.

Before you delete the login on any server, I would suggest that you change ownership on all of the objects that you can find and test to see that everything...

Hey George,

Thanks again.

I encapulated the code into a sp and have put this in my server documentation spreadsheet. I had the same info before, but not in code form.

Here...

Thanks,

This gets me where I need to be.

I thought that I remembered a version of the sp_help_rev_login with this scripted into it but can't locate it on the web. ...

Thanks for the quick response. This looks like the standard sp_help_rev_login to me. I am looking for one that scripts the users, default databases and roles also. ...

I agree on not droping objects. Once worked in a place where there were quarterly and yearly reports with their own sp's. The same place also had windows...