As long as it is working, and the users are not overpermissioned - no reason that I can think of would make a "bad" approach.

When using the localsystem account for the database services, you will need to establish a certificate for the mirror in...

exorcism

doh - knew the right answer and clicked the wrong radial - pfpfpfpf

I haven't used TSM for SQL 2005, so my recommendations would be as follows:

1. Install TSM on a server with SQL 2005

or

2. Install SQL 2005 management tools on...

Technet Article:

http://msdn.microsoft.com/en-us/library/ms143799.aspx

Something that works for some environments is to have a table where they have write permission. This table would hold job data. In this table they can submit...

Yesterday while the tivoli backups were running on my SQL Databases, i noticed that out of 30 GB memory that is allocated through AWE, one of the clustered indexes on...

The suggestion that Curtis gave about the CurrentID and Top N rows is essentially the same sort of configuration we have done. It works surprisingly fast for what it...

SQLbee (12/1/2009)

---

HI Everyone,

I am looking to do some administration on a 2 node cluster based on Windows server 2003 Enterprise and SQL 2K5.

I have a few services that are...

And I will give my vote to RedGate SQL Compare for schema and objects, and RedGate Data Compare for comparing the data in tables.

Here is a bare bones skeleton script. If you modify it, you should be able to accomplish your goals.

WITH dedupeCTE (COl1,Col2, DuplicateCount)

AS

(

SELECT COl1,Col2,

ROW_NUMBER() OVER(PARTITION BY COl1,Col2 ORDER BY Col1)...

Kabaari,

Lynn has put it very well and Lowell has helped tremendously with little to go on. There are many people in this forum ready to help, if they can...

GilaMonster (12/2/2009)

---

You missed what happened over Thanksgiving weekend. On the friday that guy had posted to over 20 threads with exactly the same message, even...

CALs do not control the number of concurrent queries. The CAL "controls" the number of Concurrent Clients. A CAL is associated with a server or desktop.

If you are...