mark.tait (4/27/2012)

---

Thank you - I really appreciate it.

I will try to use SPs as much as possible, and I'll also look at setting up a role, to just be able...

PS how does this affect your specific situation? We don't know if it was a root cause, but it could have been. When SQL Server starts getting greedy, and Wndows...

Grant Fritchey (4/27/2012)

---

I'm not so sure I'd use a trigger. Those things are notorious performance and maintenance headaches.

What about using the OUTPUT clause. You can output the IDs generated from...

Thanks. From those numbers it looks like you need to set max memory for the buffer pool. You have it at 2097152GB, which in peak usage times will allow SQL...

Gopal Singh (4/26/2012)

---

Hello,

I have one parent & child table and i have make relation ship using a foreign key. Primary key in parent table is forein key in child table.

So...

It's kind of tough to visualize with no DDL, sample data and desired results to infer your requirement and test code against...can you provide that?

Some guesses though...initial thought was two...

Security is a big topic in SQL Server...but for a simple approach abide by the notion that "a database user should only be able to do what is needed to...

My first thought was to check the Login facet @sid property to see if it was NULL, but that turned out to be harder than it should have been. Then...

Allow user defined functions to be called in the same manner as Builtin functions

Just looking out in case you were now supporting a database that originated on 2000 and had some impure data. I inherited a bunch of 2000 DBs a while back...

It's a good idea to make sure Data Purity was run cleanly since the upgrade. The info is on the same page Gail pointed you to 😉

CHECKDB From Every Angle:...

Note that just restoring the database will not make it fully operational on the 2008R2 instance. You also need to make sure you transfer the Server Logins used within that...

Test_plan-1.sqlplan

It looks like you could benefit from an index on Users.ID that INCLUDEs email but I need to see the DDL to be sure. Can you please provide the DDL...

What does the proc do? It, or something else in the stack, may be changing your security context using EXECUTE AS or sp_unsetapprole. Can you post the procedure code?

DBCS is not natively supported in SQL Server, only ANSI (CHAR & VARCHAR) as well as Unicode (NCHAR & NVARCHAR). If you want to store DBCS in SQL Server it...