Please can we see full table DDL? If you don't have a column by which the rows can be ordered, this can't be done.

John

If you use the GUI in Management Studio to delete the login, you can go to the User Mapping tab and untick each database that is ticked. This will...

This could be the answer to your problem, as well. Depending on how your replication is configured, and depending on what testing you need to do, you could either...

Joe

Does your transaction log need to be that big? In other words, does it ever approach 100% full? If it doesn't, it's probably safe for you to shrink...

No, the code in the job step does not run as a single transaction (unless it consists of a single statement, of course). You would need a BEGIN TRANSACTION...END...

You can use the SET TRANSACTION ISOLATION LEVEL statement in the code for each job step. Please will you be more specific about what you're trying to achieve -...

That's a good start. Now you need to join that result set to itself on callref = callref and rn = rn + 1, counting the number of times...

Well, this would do it:

SELECT 15 AS id

but I suspect that's not what you're looking for, so please explain exactly how you get the second value from the first.

John

Tony Rogerson also covers this in detail in his blog.

John

dazzim72 (6/26/2013)

---

I use the function because I have a large amount of .sql files and I prefer to store specific logic in only one point. They help me to have...

Jason

Did you use SQL Server Configuration Manager to set the service account? Please will you post the content of SQLAGENT.OUT.

John

Edit - just realised that this thread is over a...

Lowell (6/25/2013)

---

I think one of the join criterias are using scalar functions though...i think that is the performance killer here:

isn't this three different scalar functions being used to create the...

Lowell (6/25/2013)

---

also, i see a scalar function in the selection, so that will substantially slow things down...it looks like it's just formatting the data as 6 chars, maybe 201306?

lose the...

Marco

If you only have 1120 rows, it may be that the query optimzer decides that it's better to do a clustered index scan than to use the index. I...

Yes, I think LiteSpeed from Quest has object level restore as well.

Another alternative is to purchase some software that allows you to mount a database backup as a database without...