May be you need to supply the provider name as well in the connection string and see if that works. is the sql server residing on the local machine?

Please open sql...

pls read my previous post.

marwenG (5/8/2010)

---

Hi,

Thanks for the clarification.I change my strind connection to that:

I turn off my Firewall.

When running,this error appears:

What is the...

marwenG (5/8/2010)

---

Hi guys,

I need to find the IP address of an INSATNCE of sql server 2005. When I open sql server management studio,it writes ADMIN-PC (SQL Server 9.0.1399 - sa).Is...

It seems you are taking backup on a network path instead of local disk and the network path is no longer available.

suggest u to take backup locally then copy/move to...

Actual templog.ldf size on disk is 20 MB.

your question is bit unclear. can u clarify pls?

I had faced this problem earlier. I managed this in my front end. i created dynamic sql and then ran that sql.

Roseane (4/29/2010)

---

I need to take a staff id 4 digit and return the value of 09XXXX. (XXXX being the staff Id's)

I tried to get the Staff id...

Your script is too neat and simple. and yeah, the performance improvement is massive. I'm little bad in writing complex queries. I'm waiting for my manager's comment on that. all...

Many thanks for the script Wayne. This took 5 ms on a database where as the earlier one took 1 min 17 secs.

Copy the files and paste it in a different drive/disk/folder/tape.

take file system backup.

Eyjafjallajokull