Thanks all. I wasn't about to stop the SQL Server. I knew that it would recover on the way up and then ALL the databases on this machine...

I didn't understand what you meant at first with the GUIDs. I started a second instance of BIDS and was able to copy/paste the objects, including Connection Managers, to...

FYI - Guess I'll never know why my restored DBs had the Service Broker turned off. All I had to do was alter database MSDB set enable_broker. My...

I use DB Mail with @query in a stored procedure (below). The query is put in the variable @cmd. The variable @db is passed as a parameter. ...

I’m thankful for the GUI simplifying tasks. I need the time since creating ANYTHING in SSIS takes about 100 times longer than it did in DTS.

Its a local Admin by group membership. Our DBA group is local admin for installing software, SQL Server, etc.. Only me and the service account are members of...

I uninstalled & reinstalled sql server. Then instead of getting the named pipes provider error when trying Surface Area Config I was getting message "You must connect from the...

I guess I'm not so much worried about the DB as I am users logging errors and some kind of outage. I can get a backup beforehand and am...

Yes, its their app and only their app in the db. But we here in IS are the ones that look bad if the users start logging errors. ...

Is this just a probelm from using mapped drive letters instead of fully qualified UNC designations?

Are you looking to make a Configuration File where you can edit the server connections? Try this article: http://www.sqlis.com/26.aspx

Success! Thank you very much!

I guess I don't understand statistics completely. This is a vendor app and they want auto-update stats off and to run a weekly update statistics job. I guess...

I think this is MS Office security related. I think you're getting an MS Office pop up window saying something to the effect of "Someone is trying to run...

In 2005 you can add a DDL Trigger to prevent table alters and drops:

create trigger [NoDrop]

on database

for drop_table, alter_table

as

print 'See the DBA before dropping and changing tables'

rollback

At least this will...