ek-822869 (9/7/2012)

---

sorry for not being clear. I want to update all the rows which may take quite some time but many users are accessing the table. I was asking is...

Do you mean Altering the table structure?

There's nothing "built in" for this but there's no reason why you couldn't put an update trigger on msdb.dbo.sysjobs and msdb.dbo.sysschedules to send an email if the enabled flag is...

Not straight away and probably not for some time. Provided the logreader is running...

Sorry. That is incorrect. It will not.

Not in the way you describe.

You can publish tables using a foreign key constraint type link using Merge replication but not to a single table. i.e. you can publish...

Replication uses magazine/newspaper terminology.

Publisher = Source Server

Subscriber = Destination Server

Article = Table/Stored procedure/view

Publication = Group of articles

You would want to limit access to the subscriber as there is very little...

erics44 (9/5/2012)

---

What are the issues with using replication to move data between a live database and one used for reporting?

is this the best way to get real time data into...

emile.milne (9/5/2012)

---

Just read this on MS website.

•The following scenarios are not supported in SQL Server 2012:

You cannot migrate from a stand-alone instance of SQL Server to a SQL Server 2012...

sql-lover (8/18/2012)

---

Ok,

Idea #1

Splitting the table in two. Keeping table #1 on the actual production database server but with data for current year. Then, based on the PK or date time...

My point is, encrypted stored procedures (or other objects) will not be scripted.

Are they encrypted?

Append to the existing value. Same as

SET @myvariable = @myvariable + 'test'

Antony Symonds (8/15/2012)

---

Would seem I had an empty guid that i never used.. and I can get round that no problem... but I have hit another snag 🙁

When I try...

Yes. As you would run the script via a query session the inserts would be picked up and cause a conflict. It shouldnt be an issue to resolve...