So you have a problem with premature congratulations?

Glad we could help!

Andy

I avoid the dynamic sql approach as much as possible. We run an app that partitions client data into separate db's - each which requires 'basically' the same procs, views,...

You shouldnt have to change any memory settings. The COM+ thing doesnt need to (and you probably dont want) run on the SQL box itself. Doesnt mean you wont still...

I was thinking of one that would not just get free space, but would look at the size of the most recent backup on disk and show the compression ration...

Both are valid, just depends on where is the best place. If you ALWAYS want the value to just be the time portion, I'd say do in a procedure. If...

COM+ in theory isnt that big a deal, its just a standard COM component (which is really just some VB or whatever code in a class or classes, nothing bug)....

Would depend on the amount of free space in the db, it doesnt get backed up. I think there is definitely a relationship, though I dont expect it will exact.

Anyone...

If you're not in a coma when you're done! Backup and restore is a critical task. After that I'd say access & security, so work through logins, users, roles, grant,...

Is port 1433 open/set?

Andy

DSN's are nothing complicated - just a way to edit a connection string really. I'd suggest looking at server performance when you get the time outs, also network traffic. Have...

I dont see (though that doesnt mean there isn't) a way to determine the connected users via DMO directly. You can however submit a query using the server or db...

No magic too it. First figure out how to do it plain SQL from Query Analyzer. Basically something like this:

update b set b.col1=a.col1, bcol2, a.col2 from table1 b inner join...

Agree that the book wasnt a lot of help. I thought it was the worst of the exams I've taken, not because I didnt know the material but because it...

Throw it in the script library Bill!

Andy

Thanks for posting! Have to my homework on this one, will get you an answer later today...unless one of our readers beats me to it:-)

Andy