perfect - cheers

right click on your publication.. go to Filter rows and add a filter for that specific code

Thanks - just going through the set up of the catalog. It looks like this method uses CLR. Whats your view on that? Is this safe to use \ seen...

I am not sure why it would make a difference? I would install newest to oldest, installing the newest instance and all of the tools, then just the instances for...

I tried to install SQL server 2008 on NAS before and SQL Server did not recognise the NAS as a viable storage option so could not even get past the...

PROD Server 1 – Fixed storage, primary for High availability group, Automatic failover

PROD Server 2 – Fixed storage, secondary for High availability group, read only copy

DR Server 1 – Fixed...

Thanks for that, i will read up on the differences between EXcept and not in

Perry Whittle (10/22/2014)

---

SQLAssAS (10/22/2014)

---

This question is just a sanity check

This details an FCI in the prod and an FCI in the DR with an Availability group between them, correct?

If this...

Also consider just doing a full back up \ copy and then differential backups depending on the rate of data change on a daily basis

just realised after pasting the error

Msg 102, Level 15, State 1, Procedure Trig_NewServer, Line 7

Incorrect syntax near 'inserted'.

I was missing END after inserted.. what a fool! (me of course)

Thanks! I knew i was missing something - now to complicate things further 😀

I have just tried passing it sample from the table with a fully qualified connect string

Provider=SQLNCLI11;Server=Server\Intstance;Database=DBA;

Trusted_Connection=yes;

I know its going to be a simple issue but I can't find it! I...

Could this be because my connection string I am passing in are just Server\instance ?? and not full qualified connections strings such as..

Data Source=<Server>;Initial Catalog=<Database>;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False

or should Server\instance work...

error attached. I am assuming the string I am trying to pass just isn't getting to the variable.

If there are any particular screen which may help diagnose the issue let...

Thanks guys, I think i have set the variables up right and data flow task etc..

The expression - Do I have to have it like

“Data Source=”+ @[User::DemoSQLServer] +”;User ID=”+...