I tried the alternate method, but the excess violence just caused me to replace the keyboard

still trying to figure out; this sql...

the documents table exists, i guess i just didn't include in in the example for brevity;

that may give me the kick in the pants i needed; i didn't think about...

Thanks for the ideas Remi and Hans;

based on your input, i enhanced the uglysearch a bit more; now i check to make sure columns are at least as long as...

we all agree that a monster scan like this is bad, but bad or not, sometimes you need to do it.

Here's a slightly updated version, this simply uses if exists,...

I made an ugly server intensive cursor for a similar question a while back;noone came up with a better example so far.

see the thread here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=181099

it whips through every varchar...

dinesh that delete script  using sp_msforewachtable does not take into consideration foreign key hierarcies....so it will by default try to delete the4 tables in the order they were created...most likely a...

Query Analizer...heh

...too much pr0n on the brain.

ok and on your linksys router, you've mapped some port forwarding so it looks something like this?

if you don't have port forwarding to the sql server, of course your developer...

the proc should probablyo have SET NOCOUNT ON as the first statement; could that be the cause of the issue? i'd rename the proc to have underscores instead of spaces...

you should also be able to connect to the instance by connecting to IPaddress,port;

ie 65.34.234.179,1207

you use that format whether it is in QA, a connection string in ASP or...

an url and it's arguments may not contain spaces or other reserved characters; the argument must be urlencoded:

SELECT+%2A+FROM+Employees+FOR+XML+AUTO&root=root

in .net you can use system.web.httputility.urlencode i think, in asp it's server.urlencode,

if you...

could it be the proc exists in the MASTER database, but does not start with "sp_"

if a proc exists in master, but doesn't have the proper naming convention, then you...

here's my 2 cents.

"Transaction must be initiated by the client and not in database components such as stored procedures. "

I've found that the AUTOCLOSE property can cause EM to open very slowly; this is especially true on instances that are on the personal Edition, where any database that is...

in sql 2000, the for xml clause cannot be captured into any variable, table or other server object. Generally, FOR XML cannot be used for any selections that do not...