Have a look at last weeks article regards defining a Server Side trace in profiler. This will create the required TSQL which you can then embed in a server...

To date there have been no service packs for 2008 R2.

There have been 4 cumulative updates.

http://support.microsoft.com/kb/2345451

As far as I know, you can only script out publications using the .Net replication management objects.

The easiest method is powershell, however you've stated you dont want to use this.

Dead...

That would be a classic.....

Apex have a tool called SQL Enforce which you can completely customise using a .net language.

I've used it in the past but couldnt get the backing of the development manager...

In terms of size and space usage you'd be better off with a single character column.

How big are these values going to be? Are they going to used in...

Rhetorical question! ...

Surely for this to deadlock there needs to be another process for it to deadlock with?

Each of these statements would execute sequentially without locking. You may well get PAGE_IO_LATCH...

The only real reason can think of to have more and two nodes in a cluster is to save on hardware costs and by installing more than one active node....

Sharon Kumar (11/22/2010)

---

Thanks alot for your suggestions.!

Is there any way to find out using scripts, how many transactions are delivered from Publisher to Distributor and Distributor to Subscriber.

Can You suggest...

Hi,

The clue is in the error message as the name follows a simple view naming convention.

Vivek Shukla (10/16/2009)

---

"

Cannot DROP TABLE 'dbo.dtblGlobalHistoryTemplate' because it is being referenced by object 'vwTypeHistoryTypeIsUserHistory'. (Source:...

Not strictly T-SQL but its a useful feature.

Old habits, die hard.

Can I remind you of [INFORMATION_SCHEMA].[COLUMNS]? 😀

Thats true, it depends on how likely concurrent editing is in the system. As the data is virtually real time this is usually sufficient.

steve.pritchard 25079 (11/16/2010)

---

The inbound data volumes are high interms of transactions - 100,000 files per day/nightWe need to take this proof of concept and scale it to support 1200 users...