Ctrl+A

Backspace

Or

Ctrl+F4

Ctrl+N

🙂

Actually I'd be curious to hear if there is such a key ... never heard of such a thing.

You could use the index DMV's (sys.dm_db_index_usage_stats) to get an idea of how frequently your tables are hit (assuming they're indexed properly), but other than that I'm not sure what...

Depending on what you're looking to do, if it's as simple as look for the last date of a backup ... this should work. There is much more you can...

Adam Bean (3/5/2008)

---

EdVassie (3/5/2008)

---

Hopefully you will haveseen this already, but in 64-bit you MUST set the upper memory limit for SQL Server. Otherwise it treats the pagefile space as...

That was awesome ...

jchamiak (3/6/2008)

---

Is there a way to transfer security logins between mirrored SQL Server 2005 Servers that do not belong to an active directory domain? I've tried the Microsoft kb article...

Good deal, if ya need any help, let me know.

Good luck!

Paul Randal (3/6/2008)

---

🙂 I tend to get a little riled when people post links that aren't terribly useful or pertinent. Many people (I'm not saying it's the case this time)...

miltonmharper (3/6/2008)

---

I have the attached link for doing SP2. Did you see any issues loading it in a failover clustered environment? I gather you have to install it...

Tim Peters (3/6/2008)

---

Adam,

I'm not sure what application is using this account. The applications appear to be working correctly so I don't know where these attempts to login are coming from....

Click here -> Microsoft SQL Server 2000 DTS Designer Components

After you install it, in SSMS, goto Management -> Legacy -> Data Transformation Services

What exactly did you upgrade?

Have you looked at...

Tim, did you see my comment above?

The application utilizing this account, is it a service? Did the password recently change and did the service not get updated?

The fact that you...

Oh yeah ... you need SP2 ... I googled a bit of your error and found random MSDN posts with users...

doug@scalabilityexperts (3/6/2008)

---

Adam, when I encountered this problem it was not oprhaned users. We had been on SQL 2005 for 6 months when the problem arose. I wound up contacting MIcrosoft...