BackupExec is one such app but there are quirks about some oyu have to be carefull of. Personally I use SQLs BACKUP DATABASE process which works just fine to do...

I believe you can free the space in a 6.5 device but not actually shrink the device. The only way to change is export the data, dump the device and...

OPENQUERY also has the bennifit of the fact the code inside is executed on the remote server and you can do a lot of manipulation that way to return the...

The squigle in SQL 7 EM meant connected. Disconnected will not have it at all.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Ok here it is kind of ruff but you should be able to follow.

SQL 7

declare @P1 int

declare @P2 int

set @P1=32|64|512|1024|8192 --Column output selection list

/*

32 Microsoft Windows NT® username

64 Windows...

What version of SQL are they running, I have found a way that will work.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

In case you missed it or maybe I missunderstood your last statements, but the link Andy gave shows sp_ExecuteSql with the syntax doing the work. FOr you case something like...

I have never seen anything that SQL logins can be tracked with other than using Profiler.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...

To the best of my knowlegde and based on what I have read, this is the only way to change it. EM does the same sort of thing when you...

If you want to run

SET SHOWPLAN_TEXT ON

GO

YOURQUERY

GO

And post the results from each box. May be able see something specific in it that I can point out to you. Also may...

Unless you are in the master database you have to use the database reference.

master.dbo.xp_sendmail

or

master..xp_sendmail

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Are you getting a high number of packet losses on the NIC? If so are you running the NIC Full Duplex and have you tried Half-Duplex? I have not done...

The problem is the Virtual Log files in the Transaction log are not releasing. This has been an issue with SQL 7. However checkout http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26&CategoryNm=Maintenance and Management &CategoryID=1 for a...

Could be the data source is not stopping and sending back the query stopped notification. I see this occassionally with Oracle datasources. If the user canceled query doesn't come back...

No you will have to detach/attach to get it to work properly. You could shirnk the first file to 1MB and set as maximum then create a secound Log file...