I think your problem is the patindex. The expression is not right... Always use SELECT first to make sure you are getting from your PATINDEX what you think you...

In mirroring, the data is not "restored." It is synchronously applied to both the primary and secondary server so that the data is always in sync. Failover happens when the...

Larry Page(EA) (4/11/2012)

---

when i want to execute the insert command with openquery i get this error :

command:

INSERT INTO MemberCard_Prediction_Structure (CustomerId, Gender, Age, Profession, Income, HouseOwner, MemberCard)

OPENQUERY([testmining],'Select Customer_id, Gender, Age, Profession,...

SQLCrazyCertified (4/11/2012)

---

No, Mirroring is a DR solution. I believe you cannot use Mirroring for load balancing. If something goes wrong with Principle Server, you have the Mirror DB...

We will gladly help you if you run into issues. However, it is important that you at least try to develop this on your own first. Then when...

Saggy (4/11/2012)

---

hi....guys...

we have to create a nightly maintenance plan for the database Adventureworks that does:

1) Full database and transaction log backup

2) Integrity check, rebuild index, recompute statistics.

Backups should go to...

seesachinjadhav,

note that it is not only bad etiquette in a forum to post your entire question in the subject line and nothing in the post itself, but extremely unprofessional in...

LMAO You will have to work with your network admins on this one.

I suppose you could use the PIVOT functionality. Are you familiar with this? http://msdn.microsoft.com/en-us/library/ms177410.aspx

If this is the full path "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" I believe that the error is telling you it does not exist. Make sure that it is all spelled...

sqlfriends (4/10/2012)

---

If you have a Typically what we do is get our new server up and running, restore backups of all databases, set up active subscriptions and inactive publications. Then,...

Perry Whittle (4/10/2012)

---

If you have a SQL server MYSERVER with named instance INST1 you may only change the server name. The instance name will remain as it was installed like...

Perry Whittle (4/10/2012)

---

rename windows server, then use sp_dropserver followed by sp_addserver.

Note you cannot rename the instance name...

What count do you mean? If your data was not in a BEGIN TRAN...COMMIT or ROLLBACK block, it is probably committed. Still not sure what you are trying to do.

Are you sure that path exists? Make sure that full path is there... That is what the error is telling you, that the folder does not exist. Also, in the...