Can you add server with IP instead of name? Is DNS giving any error in eventvwr?

1 - When Restoring a SQL 2000 .BAK file to SQL 2008, is there a best practise regarding such things? Should the database be updated in anyway? or just put...

Check to make sure that your endpoints are visible; use telnet to see if open.

Agreed. Plan on lots of testing besides reading up on the subject. I worked for a client in Dallas that was moving to a virtual environment; I set up all...

There are a bunch of whitepapers out on this subject (Hyper-v performance, virtualization, consolidation, etc.) on the Microsoft SQL Server site, so I suggest that you check them out. I...

Try it in some other environments and see what it does (dev, stage, etc.). He's right - Hyperthreading is a no-no for SQL Server, although I'm not sure that simply...

So, tell the guy first off that you can move the data out of the table, bcp, SELECT INTO, or otherwise, create the new table, and then move it back...

I wouldn't think that deleting 3-4k records among 28 tables would put indexes too far out of whack either, unless you're deleting only a few records from most of the...

The old sp_tables works too 😀

florian.reischl (3/7/2009)

---

Mohit (3/7/2009)

---

Yaa probably "c.id *= o.customer_id" causes me alot of heach though when upgrading old SQL 6.5 applications to newer version. I always always trying to talk to...

What service pack are you using on these servers?

Interesting point. I agree that SQL Server 2005 Std. had a ton of features that used to be in Enterprise, but i'm not sure that they shifted this back to...

Go look up INFORMATION.SCHEMA in BOL, both INFORMATION_SCHEMA.COLUMNS and TABLES and see if that might work for you.

You need some sort of delimiter or you will find it difficult to tell what you have. I was going to suggest searching on spaces and delimiting yourself on them...

Sometimes for debugging variables I just throw in a script task and do:

MsgBox(Dts.Variables ("yourvariablenamegoeshere").Value.ToString)