I hate to say this Sim but...

You are on your own now. I don't know ASP at all. If I was to build it I would probably research...

.mdf = the physical file that your database uses to store data

.ldf = transaction log(s)

AJ Ahrens

SQL DBA

Revenue Assurance Management - AT&T

as a side-note another GREAT reason to perform backups as you have all stated is:

By allowing SQL to do the backups to specified location the 3rd party software will never...

Another variant to what Andy has discussed is you could look and see how many witnesses have been entered and then create a loop inside your application. This way...

There probably is more than this but, this is what I had to do.

1. Goto properties of the SQL Server Agent > Job System tab

2. Uncheck the Only...

Sorry about that. Thought you could search via id

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=10543&FORUM_ID=65&CAT_ID=1&Forum_Title=Performance+Tuning&Topic_Title=Shrink+command

AJ Ahrens

SQL DBA

Custom Billing AT&T Labs

This is how I have set-up SQL Mail and it works fine. (Not same machine as Exchange Server however)

1. Login to server as account that will start SQL...

AER,

Currently there is another topic open regarding similar issue TOPIC 10543. Think it might be useful

AJ Ahrens

SQL DBA

Custom Billing AT&T Labs

I am having a similar problem except cannot shrink the log or database for our SQL 7.0 box.

I did find some reading through the 7.0 BOL and from this forum...

Sarita,

From QA go to Tools > Options > Results tab. More than likely you still have it set as DEFAULT 254 length. You can change that to be...

I agree with mimorr.

The best you can do in that environ is spoof 1 login if rights aren't defined.

OR, you could create SQL login(s) on both servers or Local NT...

I have a similar issue that Neil has.

I run FTP through stored-procedures at our month-end. Until the FTP is finished our whole month-end is basically on-hold.

Once in...

I would try and identify which program just caused the crash and tear that apart where it sends email. Possible syntax error and/or permissions

good luck

AJ Ahrens

SQL DBA

Custom Billing AT&T...

Tmp,

try running the xp_sendmail from QA and see if this still happens. I don't like the communication link failure you are receiving.

Are the sqlagent_proxy settings defined? I...

I tend to agree with everyone that has posted here regarding this issue.

I personally have worked closely with MS at a prior job. They were brought in to assist...