Steve, didnt they have the internet connector license with SQL7?

Andy

Depends on what you mean. Officially, the only thing you can do is backup or restore, SQL provides no built in means to edit or view the logs. A good...

IO isnt necessarily bad. If it was going to be hit a LOT, maybe would be worth building as a static page. Have to weigh the cost of building your...

Take a look at the GETUTCDATE() function - this would let you convert both times to a common standard before doing the datediff or whatever.

Andy

There is no easy way. One option is to use the file scripting object and the sp_oa~~~ procs. Another is to use the output option of xp_cmdshell to redirect stuff...

For #1, it's the distribution database used by replication.

For #2, exactly - transactions are logged, but you can only do a full backup, not a log backup. It's never very...

I keep at least two days on disk. In my case I know that the tape backup will always run after the SQL job. Keeping two days on disk allows...

Glad we could help!

Andy

I've had problems in the past when the folder name(s) were changed for some reason. Usually you have to drop all the full text stuff, remove the folder, rebuild it.

Andy

Take a look at these two articles:

http://www.sqlservercentral.com/columnists/bknight/sp_msforeachtable.asp

http://www.sqlservercentral.com/columnists/bknight/sp_msforeachdb.asp

Andy

Im not aware of a method of doing this. Maybe the closest you could come would be to use the sp_oa~~ procs to use ADO or file scripting object, or...

Dave,

It fails because they are not the job owner. Quote from BOL on sp_start_job:

"A user who is not a member of the sysadmin role can use sp_start_job to start only...

DB set to autoclose maybe? If EM was keeping it open, you'd see a lag when a new connection was established.

Andy

Steve, I must have missed your response about Foxpro...too funny! I honestly haven't used FP, so I throw rocks at it mainly to annoy Leon. Still, I'm pragmatic about such...

Couldnt ask for a nicer comment!

Andy