Yep, coffee did the trick :w00t:

Oh I'm sorry. :blush:

I've forgotten to remove the quoted section.

I started with a quoted reply, but just wanted to add to your arguments.

AndyD (6/20/2008)

---

When the link between Pune and Mumbai goes down, do users update both databases (Pune users update their local DB, and Mumbai users update their local DB)?

If yes, then...

For mirroring you need to test network speed, if you want it the synchronous way.

Even assync your transaction load will need to meet the timeoutcriteria to couver the 100mi within...

technet.microsoft.com/en-us/sysinternals/bb896655.aspx

you can download it free.

You can find operation / parameter information at the webpage.

read Jeff Modens article on "tally table"

Script the whole DDL using SSMS.

Keep in mind to adjust all the scripting parameters you need !

Rightclick on a dabase name in the object browser, choose tasks and go from...

get sysinternals handle to find out what other thing is holding your file.

I think you have an operator percedence problem: Your ORs stand on their own, neglecting the other predicates.

WHERE (c.CustomerID = '3942')

AND (ol.DetailTableID ...

- Nice intro to SMO for this purpose.

- Keep in mind, you have to inspect the .bak files content. They may contain more than one backup.

- You can even perform...

Books online states:

Converting a Partitioned Table to a Nonpartitioned Table

Changing a partitioned table to a nonpartitioned table simply involves modifying the partition function of a partitioned table so that the...

colin Leversuch-Roberts (6/16/2008)

---

ok - forget task manager and get process explorer - never understand why so many dba's look to task manager for memory usage - it doesn't get it...

this is a long shot...

but are u member of the (local) windows group of DB2 users ?

Maybe launch a non-sql topic, to get a more accurate inventore of which SSC members are attending.

I am going to attend SQLPASS2008, but I had to use another code.

I hope...

Well... there is this little caveot with linked servers. They have their own credential mapping.

Have a look at the linked server security tab.