The application is vendor developed and I have no control over the data access.

I host the Db:sick:

I am looking the best way to achieve this. I can script myself.

Any better suggestions ?

Queries use tempdb for sorting/grouping etc. Please correct me if I am wrong here. I was in a similar situation. I bounced the engine(off hours) and set the tempdb to...

The db is set in simple mode: We do not want to hog resources by hourly updates. Most probably: snapshot nightly should do. As the apps is transaction intensive, cannot...

Thanks chris,

Was thinking on the same lines. Also did not see mirroring as an option for SQL2000. This is available in 2005. I could update the subscriber nightly. As I...

Bounced the engine that cleared the 55 GB LDF.

Upon re-start : shrink the MDF to 1 MB. This is set to autogrow.

😉

Thanks Steve for your quick reply. I did not do a large import/bulk import. This instance is transaction intensive. Will check the connections.

The AD group is still there and the user is added separately. The user re-booted his PC and it worked!. Not sure why this happened.

Thats most probably I'll do. I do not want to set a precedence of SQL service accounts having file system rights over the network. Will use the windows scheduler to...

I am looking for best alternatives now. The SQL job is run by a SQL service account. If I schedule via SQL Job, this account needs read permissions on the...

Rephrasing.

Need to install SSRS2005: report server only that will have to connect to an existing 2000 SSRS db.

My server has iis6, .NET 2.0

During installation I select named instance and give...

Was in a similar situation: uninstalled SQLSERVER2005 , services still showing up.

A simple re-boot resolved the issue.

HTH

You will either write a .bat file or a .vbs script file with all the logic of parsing the file. You can use notepad to create the scripts.

This...

I have the same problem. Connecting to a remote server that has multiple instances. When I pick the instance I want to connect, I get the same error.

Looks like. The...

Not sure why you would not consider a .bat( of dos commands) file or vb script file and use windows schedule tasks.