Ben,

That's exactly right. We've seen this happen with web servers, with a lot of success (and other issues). We recently did it here with the need for Sharepoint, but not...

tasnim.siddiqi (7/14/2010)

---

Robust in the sense that it will be more reliable, I mean with just ascending ordered numbers the app_IDs will have a biased numbering form. I mean it is...

Service has been good and bad, in all industries for me. I think it has been bad at times when utilities become complacent. Just like government workers, they feel they...

Seth has some good ideas about where to look. This is one reason you should not use sa in your packages or connections. The pwd should be changed periodically for...

It is, unless the files get copied to a new server. New creation date. That's why I use naming conventions.

Most scripts, and the maint plans, will do this for you.

I usually say "never do x.... until you have to"

In the v6/6.5 days, temp tables where an issue. So we told all developers to "never" use temp tables.

Until we...

Couple things. Make sure SQL Agent doesn't start. That will connect and use your one connection.

You will also not want to use the Object Explorer since that takes a connection....

You are welcome and looking forward to seeing it.

First, stop saying you are starting SSMS in single user mode. You start SSMS, the mode in which SQL Server is started is irrelevant.

The error you are getting is that...

Like most anything, I think it depends. I have it in a lot of scripts to be sure that I end up in the right database.

However for things like deployment...

You can use two CTEs in a single statement

http://www.sqlservercentral.com/articles/Common+Table+Expression+%28CTE%29/62291/

It's still not clear. How does Access even come into play? If you can see the Lotus database as a connection, you connect to it in SSIS. If you cannot...

Is this what you want for the counter?

WITH ResolutionCTE (order_no, cntr)

AS

(

SELECT order_no, MAX(COUNTER) 'cntr'

FROM abcd

GROUP BY order_no

)

SELECT emp, COUNT(*)

FROM abcd a

INNER JOIN ResolutionCTE r

...

I'm saying you need 3 queries, not 2, to join together. One for each requirement, then one to pull them together.

I don't understand what the 0 or 1 are in...

RESTORE HEADERONLY also grabs the LSN. Those are linked together.

If you use the GUI and do it on the same machine, the backups are stored. If you are doing this...