Are you sure you have space on the drive for all backups?

Are there any messages in the job history?

You aren't doing any type of logging. Can you try wrapping...

The Dixie Flatline (9/23/2010)

---

Part of the problem is just knowing the terminology. Newbies have to phrase their objective without buzzwords or technical terms of art.

building a comma...

da-Zero,

Definitely a better idea which makes the process set-based, while my suggestion would work, but would process per row, meaning a delete statement for each row in the spreadsheet.

avi-631555 (9/22/2010)

---

i can do that when i am on my SSMS but i have to send out a script to the client, is there any way i can turn the...

Not that I am aware of.

Does the Report Server Service account have permissions to connect to the FTP location? What are you getting for an error?

Great. I'm glad I could be of assistance.

Nope. A foreign key does NOT create an index of any kind.

In that case you could use sp_who2 to log to a table in a job.

Or you could do a server side trace as Gail suggested.

There aren't logon triggers in Sql Server 2000 so you won't be able to move this to a 2000 server.

The reason you are getting this error is because LOGON is...

Daniel Bowlin (9/22/2010)

---

CirquedeSQLeil (9/22/2010)

---

Yes - and it is working

It's like quicksand, the...

Foreign Keys are not indexes and are used to enforce Referential Integrity not performance. In reality a foreign key hurts performance (minimally) on inserts/updates/deletes. Set Statistics IO ON...

The first thing I notice is that the only indexes on the tables are the Primary Key's. For the queries you have shown us I'd think you'd want at...

If you aren't getting any errors then there haven't been any databases dropped in the time frame covered by the Default Trace. The default trace only has up to...

jcrawf02 (9/22/2010)

---

It is the only way I get any points, after all. Damn Hugo and his questions!

😉

[rant?]

By the way, just read Tom LaRock's post, am I the only new guy...