Not sure about SQL 7 , but in 2000 the sysprocesses.loginame column will hold the sql / windows login name used to connect.

In the cases where a SQL...

If the aim is for the central office to be able to view / report on the branch data, you might want to have a look at SQL Server's Transactional...

If you are looking for the backup directory registry setting it is located under:

HKEY_LOCAL_MACHINE
 \SOFTWARE
   \Microsoft
     \MSSQLServer
       \MSSQLServer...

Hey sorin

You could check in master..sysprocesses for the current list of connections, and use the kill command to drop other connections. This is generally a bad idea though.

Why do you...

DTS packages are stored in the MSDB database. if you backup and restore the msdb database  you should find your dts packages.

How about gettinf DBCC SHOWCONTIG into a table so it can be tracked over time.

(This is something I've yet to do)

I think I was asleep.

DBCC SHOWCONTIG  will  show the fragmentation level

DBCC INDEXDEFRAG will change and compact the physical order of the leaf level of an index

DBCC DBREINDEX will rebuild indexes

I'm still too asleep,...

mmm... RESTORE DATABASE MyDatabase FROM DISK = 'null:'

Jorge, sounds to me that your system is going to start of at a decent size, so you should probably read up about...

Indeed. Form the what MS is saying at this point, it's too early still to be benchmarking they're still going through optimisations, but at least the functionality is there to...

Even tho the MSDE service isn't returning an error to the service control, it may be dropping an error into the windows event log, or into the {msde install path}\logs...

Hi MK

I don't have any full-text search catalogs at the moment, so I can't help you further with this sorry.

Read up about in BOL and test it out on...

1. Maybe taskpad / em is out of sync. Close EM and check again. The last backup date is the last successful backup, so if the backups are failing, then...

Have you tried checking the database with DBCC CHECKDB ?

Sounds like the common problem of a text/ntext/image pointer going wacked. If you have a backup already, keep it handy.

dts packages are stored in binary format inside of sql server.

You can use the SQL-DMO to walk the server, packages and connections to find the  connections you are looking for.

You'll need...

I wouldn't recommend ever getting SQL Server to backup directly to tape, mainly because we like to have our systems up as much as possible. (Have you...