Possibly. Its the sort of basic...

Meant the question

GilaMonster (3/16/2012)

---

Backups in SQL Server are at a database, filegroup or file level, not schema. A schema is a logical grouping of objects, doesn't necessarily match to a phyical grouping...

Do you? I dont know.

Should you? You should always keep a sources controlled copy of your database schema. Ideally down to the object level with developers working...

Simple enough to get the output

create table #person (OrderId int , PersonId int, Name varchar(20), Product varchar(20), [Date] date)

insert into #person (OrderId, PersonId, Name, Product, [Date])

values (1, 1, 'AA', 'AA',...

Because there are more C, C++ and Java developers than there ever were VB developers. C# is very easy to pick up when you've used C, C++ and Java.

In...

I'd be cautious combining this clustering solution with virtualisation. It could work, but you need to present a lot of volumes to the server to make it workable.

Since you have a SAN in both sites would it be more desireable to have a single 4 node geo cluster with SAN replication?

You can have the advantages of a...

If you are dynamically generating the sql why the need for a temporary table? or the exec statement?

The only way you can make a temporary table globally visible (not table...

anthony.green (3/12/2012)

---

I dont believe this is true anymore, as you can install LiteSpeed in restore only mode which doesnt ask for a licence key as your not using LiteSpeed to...

Assuming you fulfill licence requirements for source and destination, you can use litespeed for logshipping.

If you dont you can still logship but you will need to either perform a full...

Apart from the syntax, you can achieve the same with both so there's little between them since they both use the same .Net libraries.

vb does have a stigma associated with...

Here's two I know of. I'm sure theres a couple more that I've forgotten.

http://www.idera.com/Free-Tools/%5B/url%5D

http://www.ssmstoolspack.com/%5B/url%5D

You will hit an OS limit on the number distribution agents you'll be able to run. That depends partly on hardware. So if you're planning on having a...

I've added new articles in the past which reinitalise subscribers when it isnt required is one example.

Unpredictable and multiple schema locks when dropping subscriptions is another.

Managing something as potentially damaging...