You could also use SQL Profiler for this. Just set up the profile trace to save to a table. Also, you will need to filter out everything but...

I totally agree with Herve Roggero comments above about .Net. I've picked up a Beginning VB .net book and have started to work with it. All SQL Server...

My story, for what it's worth...

Got laid off in March. Went on active duty with the Air National Guard 3 weeks later, so that took me out of the...

I've read through the book noted above, Step by Step Microsoft SQL Server 2000 Analysis Services, and it is a great book to begin with. It's worth the money!!

Diane

...

Here is some info from Microsoft's web site on MSDE:

http://www.microsoft.com/sql/techinfo/development/2000/MSDE2000.asp

Thank you for your help.

Diane

Here is one more way:

declare TablesToDelete cursor

read_only

for

Select name from sysobjects where xtype = 'u' and name like '%mds%'

declare @name varchar(40)

declare @sql varchar(100)-- for drop command

open TablesToDelete

fetch...

Have you checked to see if the population is done? You can do this by running the following code:

SELECT fulltextcatalogproperty(catalog_name, 'ItemCount')

replace catalog_name with the name of your catalog....

Here is one more resource for interview questions:

http://vyaskn.tripod.com/iq.htm

Diane

kensai,

1) Yes, you can have too many indexes on a table. If you have a lot of insert, update and delete activity in your database, everytime you update...

Look up the article "Running a DTS Package Saved as a Visual Basic File" in BOL

Diane

The best thing to do would be to deatach the files, move them to their new location, then attach them. Look the the stored procedures sp_attach_db and sp_detach_db in...

Anyone with the SQL Server client tools can develop and save DTS packages locally. They can only access DB's that they have been given access to. To save...

Only committed, i.e. completed transactions are dropped from the log. Uncommitted transactions cannot be dropped. Check to see if your SQL code is leaving open transactions.

Diane

The number of transactions per minute that SQL Server 7 can process varies. There is no one published number for this. How many transactions per minute you can...