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...

Can you use the built in C2 Audit Functionality from SQL Server 2K?

that audits literally everything that happens, every end user activity(ie every sql command), as well as a lot...

THE VARIABLE GOES OUT OF SCOPE WITH THE BATCH OPERATOR:

DECLARE @@MYVAR VARCHAR (50)

SET @@MYVAR='KEWL'

PRINT @@MYVAR

GO

PRINT @@MYVAR

gives the following results:

KEWL

Server: Msg 137, Level 15, State 2, Line 1

Must declare the variable...

Paul i was assuming he would use a loop to go thru all databases...and assumed that some of the databases were not related to his app.

rather than letting the cursor...

you want to delete items where all the items are null, so use that logic instead of NOT IN and OR statements:

create procedure pr_cleanup

as

begin

  if exists(select name from sysobjects where...

i think you would have to set up a profile to track logins; it's not stored anywhere, it is just an event that happens, unless you profile to a table.

I...

why not install /upgrade to SQL 2000 and set the database compatibility to 7 instead of the default of 8?

then all statements are executed against the sql 7 rules such as...

the standard and enterprise versions can only be installed on the server OS platforms...win2k Server/ advanced server or win2003.

on 2000/xp editions, it automatically installs personal edition instead.

personal edition, in order...

I would do it as a separate operation using the UPDATETEXT function;

here's an example that might give you some insight, but go for the BOL to get otehr examples.

Create Table...

Enterprise Manager will exhibit this behavior(seemingly stalled or not responsive)  if the db's on the server are closed, and there are a lot of databases; EM must open each database,...