Sure, about the only time is when migrating...

Krishna1 (4/9/2013)

---

DECLARE @filename NVARCHAR(1000);

DECLARE @bc INT;

DECLARE @ec INT;

DECLARE @bfn VARCHAR(1000);

DECLARE @efn VARCHAR(10);

-- Get the name of the current default trace

SELECT @filename = CAST(value AS NVARCHAR(1000))

FROM ::fn_trace_getinfo(DEFAULT)

WHERE traceid = 1 AND...

Follow this knowledge base article from MS

First thing to do is to decide on which you will use sounds like you have thought about it...

Unless its an FCI then you are required to use shared storage not local

Right click the table and select "Script table as" > "Create to" > "New query editor window".

Do you see the default constraint script there?

Please post results of the following query

SELECTdc.nameAS...

are you referring to database mirroring?

You cannot mirror system databases. If you have installed a failover clustered instance of sql server, the system databases will be on shared drives that...

when you mention filetables are you referring to filestream objects?

EdVassie (12/30/2013)

---

The main benefit of doing an unattended installation is you can guarantee repeatability.

It is too easy with a manual install to forget to select a given option...

SELECT DATEADD(day, -1, b.MYDATE), DeliveryDate from MYTABLE b

are downloading any...

smtzac (12/23/2013)

---

In my sql instance I have configured log shipping on Prod database and same time there is a Maintenance plan which is taking the same database Full and Diff...

You can move all...

Directly, no. Indirectly for the reason listed below

It will...

ron.grout (12/18/2013)

---

I have log shipping set up to update two secondary databases, one on our backup server here in the UK and one on a server in our US office.

I...