Kris,

Is your Local Machine a Windows Vista and you have SP2 for SQL Server?

During SP2 installation on the servers it asked me to run some tool for Windows Vista to give Windows...

I go to my email to get the question text. Or you can create a second login that does not answer questions. 🙂

I guess I have to try !! and :r...

I have:

1 MCDBA Polo, 1 SQLservercentral.com polo, a couple of Visual Studio /SQL Server launch event t-shirts and a number of our Boston Heart Walk t-shirts.

Considering that I like Polo...

Don't understand. The question is: "What SQLCMD command should you use to call the file" and the file was a script file. Scripts are run from SQLCMD utility...

First, find out if the applications that work with these databases will work with named instances. Contact application vendors for approval

Second, think how do you plan to maintain security.

Third, named...

Hah,

The logic in the article could be applied to any kind of people. There was a good Russia joke about Yes interpretation:

If a virgin says No it means Maybe, If...

Hi Greg,

I will add this kind of the answer the next time I submit the question.

Yelena

What a good question!!!!

A couple of things:

1. Varchar will sort as dictionary order, not as date or integer. I have one varchar field in one third party app for the year of birth and...

You probably should not touch these tables. These are local tables (with one #) and can be accesses only by the creating connection. These tables have nothing to do with the...

Do all Windows accounts that you are using have individual logins in SQL Server? I did have problems when Windows accounts were SQL Server logins through the group / role membership....

Not sure about indexes.

I would worry about cross-database ownership chaining. First, you have to enable it for the databases or on the server level and then you have to design...

That is exactly what I am doing with other CRMs. Either these DBs are too complex either the support company would not recommend to customize the databases. I created additional databases...

I would vote for Method 2 - rebuild index first and then shrink

I answered as expected, but agree with other posters. I would check the errorlog first to ensure I don't have a problem after the restart and after that would do...