Thanks I'll give it a try.  Its SAP,  so it is case sensitive.  Thanks, that could be easy. (not to mention, dumb of me)

For certain... Yes, I actually tried it and you cannot rename a named instance of SQL and have it work. (sometimes you just have to do things yourself, or you...

Alvin Ramard (5/27/2015)

Pointing a well designed app to a new data source should be so easy. You should be able to just edit the config data and update the source...

Huh, I tried running the upgrade(Express to Full) from the install disk like he said in the article, and I got the message that "there is no upgrade path from...

Old post, but new day...

We have an existing named instance of SQL Express. We want to replace it with a full named SQL instance in such a way that...

Thanks for hanging in there with me. The closing statement on the DBCC are as follows:

CHECKDB found 0 allocation errors and 11 consistency errors in database 'MB_DW_USA'.

repair_allow_data_loss is the minimum...

And the final outcome for this was?

I have a really weird situation. I have a database with one table with torn pages, but the database is not suspect. The table is not in use...

We are occasionally experiencing the same message - perhaps once a day, is there any advantage to flushing the PROCCACHE more often? As far as I know, we don't...

What do they specifically mean by "snooping?" I assumed we are all talking about the same thing and obviously we are not.

"Snooping" in my book, is...

Put like that, its a fair question. ...

The above post, I believe points out the obvious that not everyone should have access to sensitive data. If they were applying at my company, they wouldnt get a...

Perhaps what we need, for those who administer data systems is more integrity. I'm shocked at the number of IT specialists who you claim "admit to data snooping"...

Hi - Thanks for the reply - Its a passive active 2 node cluster. The reason its set up this way is because most of the instances are replacing...

I Guess I hadnt thought about from a speed perspective, but more so from an availability standpoint. Defrags dont prevent other processes from running like a reindex on a...