mhotek-836094 (5/8/2012)

---

Um...the big deal is....what? I connect remotely to every production SQL Server instance that I've worked with for over 2 decades. I rarely have to manage the...

IceDread (5/9/2012)

---

Steve, you don't get sponsored by companies for posting this or do you?

I do not mean to question your integrity but you seam so positive about it. However that...

Thanks, everyone. She struggled a bit to get going yesterday in the rain, but today she's having fun working in the barn.

Not sure. I thought the deallocations of the blob pages might be stored in the log, but I can't find a definitive reference. How large is the LDF. Could there...

I assume most of you saw it, but for those that didn't, my wife quit her job[/url].

I haven't tried it, but I don't see a restriction on versions. The docs mention any compatibility mode.

The issue with doing this continuously is that if you fail over, you...

Sorry, didn't realize this was SQL 2000. (Doh!)

Query Analyzer has a menu item for this. You select it before you run the query.

Don't be sure your schema and data are...

In sync, are you sure? Have you actually done a sync recently or a restore? It's easy to assume this and be wrong.

To get the execution plan, you can easily...

Let us know what you find, and if you have specific questions, post back.

One thing I'd caution is not to assume anything here, especially with security. Use SETUSER and actually...

Nadrek (5/7/2012)

---

I assume that's at most...

Nadrek (5/7/2012)

---

Seriously: how many people are going to ask for, much less get, a wipe absolutely as soon as they realize the phone's missing? Instead of turning around...

And the XP registered correctly? You ran sp_addextendedproc? The DLL has to exactly match the function you register.

Is the DLL x64 if the server is x64?

Are you looking to return an error when this occurs?

I assume you are merely looking for a count for each employee for a year, correct? I would write a proc...

That is not a SQL Server function. It's an extended stored procedure that you have to register on the SQL Server.

http://msdn.microsoft.com/en-us/library/ms164653%28v=sql.100%29.aspx

Definitely not x86 v x64. The way the database works and disk structures are the same.

There has to be something with security, or perhaps some other issue. If you post...