Is there anything we can do wiht what he got?

Check SQL Client Network utility and change default network library. That should do it.

Very good post.

Try using Application role

We need to refine our search a little better. Lot of times, when i search for an item, i do not get what i am looking for but i know...

Try using DTS wizard. It is pretty straight forward. Make sure you give the parameters in each screen right.

Make sure it is not dropped or in the restore process.

Set the max memory so SQLServer does not take more than it is allowed.

Also try using DBCC DropCleanBuffers

This would free up the cache. In turn it should free...

I just want to know the set based workings of sql. Although I can relate a few joins with sets, I would like to think and write my query based...

Know your business. Keep in mind that business is more important than technical. Don't do anything just because you saw it in some forum or magazine. Think how it will...

I have developed a VB application using SQLDMO to transfer tables, logins, users, permissions etc.. If you need any help, contact me. I might be able to help you. (My...

It is perfectly alright to group by a field which is not in the select list but all the fields in the select list should either be in an aggregate...

Use SQLDMO and generate scripts.

sub GenerateScript(TableName as string)

dim objServer As New SQLDMO.SQLServer

objServer.Connect Trim(gstrServerName), Trim(gstrUserName), Trim(gstrPassword)

'this would generate a file called <tablename>.sql

objServer.Databases(gstrDatabase).Views(TableName).Script SQLDMOScript_Default + SQLDMOScript_Drops, Trim(gstrScriptFolder) + "\" +...

Can't you try using xp_cmdshell?