Gail,

Thank you for the information. fn_trace_gettable looks like what I need to get the trace information into a table. I will try it out.

Steve

I was looking at a server side trace to replace an interactive trace that I run from Profiler. I don't see an option to Save to a Table for...

andrew,

Maintenance Plans are fine but they will not do what these scripts do. These scripts allow you to keep a specific number sets of backups (a set being a...

You're welcome.

Glad it worked for you.

Steve

Ashish,

You did not look very closely to the scripts. The script finds the oldest backup file you want to keep (depending upon how many sets you wish to keep)...

Here are two stored proceedures. One that performs backups for a specific type (Full, Differential, Transaction Logs) with a specific naming convention to the sub-directory for the database and the...

I think it would have been delicious to have one of the options for the answer to be "I Don't Know" and it be the correct response.

Steve

There is Certification (Exam 70-448) available for "SSL Server 2008, Business Intelligence Development and Maintenance". I haven't looked at it yet but plan to work through the Self-Paced training...

There were no Windows updates for Sql Server. I did re-install SS 2000 Standard Client Tools, just Enterprise Manager, and that seems to have take care of the problem.

Steve

I had looked at that article and I didn't see how it applied. I am not trying to edit it in 2005 (or 2008). I have gone back...

My original SS 2000 Client tools installed on my desk top are Standard Edition for a SS 2000 installation that I have full control of. I installed SS...

Besides using the 3 part name of a table as previous poster indicated (db.owner.table) you could create a view of a table in the current database that selects from the...

Just a thought. This could be a catch-22.

If you answered just "The submitter of the question" and then came to the discussion when you saw that you...

I'm not sure about SS 2005, but in SS 2000 any valid Logins would be able to see any of the databases with the permissions of the 'guest' user. ...

As already stated, Exam 70-448 (Sql Server 2008, Business Intelligence Development and Maintenance) is more directly applicable to BI. If I was only doing one Cert and was interested...