table with the customers which has a uniqueidentifer column which has a default of newid so each customer has a GUID

then have a foreign key constraint to table 1 which...

I'd agree with Usman, SQL wasnt designed to manage AD.

MS provide the MSC console applications to modify AD objects and they work and do the jobs you need.

Powershell can be...

declare @text nvarchar(100)

set @text = '1,2,3,4'

select @text = replace(@text,',',''',''')

select @text

gives output as -- 1','2','3','4

select * into PRODUCTIONDB.SCHEMA.TABLENAME from RESTOREDDB.SCHEMA.TABLENAME

make sure you have backed up the PROD db and either renamed or dropped the table which you wrongly updated

There is no difference in connecting to the Nodes IP and the Virtual IP. Infact I would almost certainly say always use the Virtual IP address. I say...

duplicate post, please redirect replies to this topic http://www.sqlservercentral.com/Forums/Topic1212917-391-1.aspx

you probably wont find the code as that would break the licence terms of the product.

the stored proc is an extended stored procedure which calls a DLL if I remember...

not to worry, happy to help, is always the simple things that wind you up the most.

You need to run the script, by pressing F5 or the execute button on the toolbar with the red ! mark

when you changed the path to the log files, did you copy the existing log folder to the new location after the config change, or did you delete the old...

check your standby server is copying and restoring the logs?

is the SQL Server and/or Agent online after the reboot?

are the services set to automatic startup? if not set to...

SQLDBA-536161 (10/17/2011)

---

Hi Gurus,

I'm having trouble understanding SQL Server active/active cluster model. I was asked by our management about the difference between active/passive active/active to run SharePoint 2010.

I know what...

simon-811452 (11/28/2011)

---

Just to add a comment - I have exactly the same issue. Looking at why a query has suddenly stopped returning I found the same thing - a string...

jewel.sacred (11/28/2011)

---

Dev (11/28/2011)

---

jewel.sacred (11/28/2011)

---

I think it is not OK (not always atleast). Imagine the...

Have the tcp/ip and named pipes providers been enabled under SQL Server Configuration Manager on the server by the person who installed SQL?