Why don't you setup all your instances as registered servers within SSMS, double clicking on a registered server opens it in object explorer and connects.

Any version of Visual Studio 2005 should satisfy your basic development source control needs. Have a look under database projects within new projects, please note these aren't compatible with...

Bob,

Probably the easiest method is to run SQL Profiler against your server for a short period of time filtering on the 'NT AUTHORITY\SYSTEM' i.e. the local system account of your SQL Server,...

just found this which backs up your statement http://www.red-gate.com/products/SQL_Prompt/faq.htm

hey Grant,

i wasn't aware that DBPro doesn't support the RedGate tools, the other Team Editions seem to, in actual fact i've seen Team Edition for Software Testers with RedGate SQL...

Denise,

Good old google is your best friend in these situations http://forums.microsoft.com/msdn/rss.aspx?postid=1404000&forumid=88&siteid=1 not a simple fix from the looks of it.

ll

Trigger,

You could use database mail to send an email to users instead, maybe not as in intrusive as a netsend but you could send it in advance, you must be...

I use robocopy (part of the Windows NT and 2000 resource kits) when copying large files, it supports restarts, network interruptions and you can pipe progress to a text file. ...

Cheers Markus,

However that doesn't change the output of the script if i right click on a sproc for example and select 'Script Stored Procedure as > CREATE To > New...

I had to do similar for a table I had that holds captured database sizes, I used the following:

ds_capturedDateTime = DateTime column

ds_server = Server name

ds_createdBy = Username

SELECT DATEPART(year, ds_capturedDateTime), DATEPART(month,...

Mark,

Does your table already split the date components into separate columns or did you mean to write it as?

datetime (yyyy:mm:dd:hh:mm.ss), server, session, app user

ll

Sorry I forgot to mention it would be easy to get the daily local job on each server to publish to a central location as well, you could even use...

I kind of follow Colin's approach.  I tend to have a user database on all servers I manage called dbasys and I drop any tables/sprocs/functions I need for day-to-day maintenance/data...

This should do the trick http://www.databasejournal.com/features/mssql/article.php/10894_3345091_2

This article states "Microsoft does not support using SQL Mail to communicate with mail servers such as Lotus Notes, Lotus cc:Mail, or Novell GroupWise unless they are treated as POP3...