HP EliteBook 8540w

Win 7 x64

8 GB RAM

120 GB SSD

My only gripe is that it is a bit heavy.

edit: blah I can't read, sorry about that...

I have been here a couple years now so I almost take it for granted but:

Free drinks (coffee, tea, cokes,oj, apple juice)

Free lunch (1 day a week hot lunch and...

Maybe regular expressions?

here is a link to a codeplex project which may help get you started.

http://www.codeproject.com/KB/database/SqlRegularExpressions.aspx

It may be more work though....

nice question, thanks!

Answering these is becoming a daily habit for me now.

If you are using SQL 2005 or above this should work.

NOTE: depending on how wide your rows are it might be necessary to tweak the amount deleted per iteration.

WHILE 1=1

...

If you put in the time SQL Nexus can provide alot of information.

http://sqlnexus.codeplex.com/

http://blog.sqlauthority.com/2007/04/21/sql-server-interview-questions-and-answers-complete-list-download/

Are ad hoc queries enabled?

I have been tricked!

But, oh well....

you may want to look at: http://www.brentozar.com/

Under SQL Server articles he has some on virtualization. Also, if you search his blog I believe there are additional posts/videos on the topic.

Is the error happening when you connect with a SQL login, windows authentication, or both?

If the SQL login works and the windows authentication doesn't you can try enabling named pipes...

if I understand what you are asking, I don't think openquery can use variables. In the past I have had to build out the statements dynamically.

DECLARE @QryString as nVarchar(MAX)

SET...