They (who?) do not allow...

engrshafiq4 (12/14/2011)

---

i have written code and is working fine..now the issue is when i am using to upload to server not on local,then i am geting this error

The OLE...

You highlighted a good & valid point here.:cool:

Lexa (12/13/2011)

---

We have a cluster where 2 nodes are running different DBs. When failing over one node (with all its clustered resources) switches to the other physical server.

Lets say...

pallavi.unde (12/13/2011)

---

when i connect the database to s/w application and trying to insert a record

i getting this error :-

Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT...

trarunprasanna (12/13/2011)

---

Hi All

TCP Provider: The specified network name is no longer available. [SQLSTATE 08S01] (Error 64) Communication link failure [SQLSTATE 08S01] (Error 64). The step failed.

Frequently while taking backup through...

Glad to hear this :-). Well, you replied quite early though 😉

Dev has given you the answer 🙂

You should use SSIS for these tasks. It is a very efficient tools for these kind of tasks.

You can get more information here:

http://www.techrepublic.com/blog/datacenter/how-to-import-an-excel-file-into-sql-server-2005-using-integration-services/205

P.S. The example given in this article if...

itsamarnath (12/13/2011)

---

I am seeing a lot of these messages in sql server error logs

2011-12-11 03:27:34.15 Server All schedulers on Node 0 appear deadlocked due to...

Could you please elaborate your requirements ? What all the data you want to collect in your audit ? What are your plans & your thoughts ?

Please go through this link, may help you to find the exact procedure:

http://www.mssqltips.com/sqlservertip/1709/install-sql-server-2008-on-a-windows-server-2008-cluster-part-3/

JohnnyDBA (12/5/2011)

---

Any solution to this issue? I'm getting the same problem.

SQL Server 2008 R2

Windows Server 2008 R2 SP1

SAN disks

I get it whether the disks are in available storage or...

I have seen this behaviour of cluster quorum disk in Windows Server 2008. If you want to do this from GUI, I think (I haven't checked it)simulating quorum disk for...

akansha.akkii (12/12/2011)

---

I am using Microsoft SQL SERVER 2005 Professional edition.

I am trying to restore database in my d drive. It requires approximately 18 gb space,and i already have upto 18.6...