Gee, on my machine when I first open profiler the "Save As" is greyed out, then when I open and existing .trc file, the "Save As" becomes available.

...

We are also getting this on our machine. The problem seems to be because out @@IDLE value is quite large. Of course our machine has been up for...

Nice to know about the option that worked. Why didn't the "Save As" work?

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Open the trace file with "Profiler" then use the "Save As..." option to save it to a "Trace Table...".

This should do the trick.

Gregory Larsen, DBA

If you looking for SQL...

You should be able to use information_schema.routines

Note this is not available in SQL 7.0.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

The INFORMATION_SCHEMA.TABLES view is available in SQL 7.0. I'd say the normal answer is that INFORMATION_SCHEMA views should be used, since MS "might" support these to in future releases,...

I hate when I do that, sorry for the blank post.

When editing the package use the "Package" menu "Save As" option. On the "Save DTS Package" screen, enter your...

quote:

---

DTS packages and Jobs:

How do you copy these to another server?

Can they be copied from a 7.0 server to a 2000 server?...

Here is a KB article that might give you some ideas:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q139444

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

I have not actually tried to move master with the directions in the KB article. I have been able to successfully accomplish a move for MODEL and MSDB. ...

We are using the standard SQL commands to backup our database to disk, and then use Veritas to copy it to tape. Of course this means there is a...

Yes. Here is a good article that should give you the information you need about moving databases (user and system):

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224071

Gregory Larsen, DBA

If you looking for SQL Server Examples check out...

only non-active parts of the transaction log are truncated.

Basically the transaction log is cut up into a number of pieces call virtual log files, that are used in...

Here is a the same join with three columns included. Hope this helps......

create table test_data (

id int, id2 int, id3 int,

product char(10)

)

create table test_data2 (

id int, id2 int, id3...

Here is a simple example on how to identify the records in one table, that don't reside in another based on a key. This example only uses one column...