Jeff Moden (3/31/2008)Proxy account to run reviewed stored procedures is going to be a lot easier on the DBA than trying to review some other source code written in a...

I would suggest that you:

- Read the sp2-install readme file carefully. Incomplete though it may be, it is still a must.

- Install in the default installation location

- Prior to the...

I've run into all sorts of issues when deviating from the default installation location of SQL Server and now splitting the data and log files of a system db into...

No problem! 🙂

MS really should add this info to their README file for the SP2 install. Having data and log files in the same location is against their best...

I think we have found the problem. The data and log files of the resource db are not in the same location:

You cannot install SQL Server 2005 Service Pack 2...

Buxton69 (3/31/2008)

---

Could you point me toward a good resource for examples of code without using cursors, I have some examples where you load a select statement into a temp table...

It's tough.

I have been trying to enforce this new initiative of leaving xp_cmdshell turned off on all our SQL Server 2005 instances and using SQL CLR instead. But there is...

All great ideas Todd. I need to read up more on these issues, esp. how to code access security into my SQL CLR code. Lots to learn and you've opened...

Thanks all for your input.

Yes, it's true that by trying to replace xp_cmdshell with SQL CLR code that is just as generic opens the door to even more security-related issues.

I...

From http://support.microsoft.com/kb/263889:

If an owner-qualified procedure is executed with a different case than what the owner-qualified procedure was created as, the owner-qualified procedure can get a CacheMiss or request a COMPILE...

I should add that DBAs - myself included 🙂 - probably tend to overuse cursors in our every day work.

As Jason mentioned, as long as it does not impact server...

cjudge (3/28/2008)

---

In a previous post (http://www.sqlservercentral.com/Forums/Topic475089-338-1.aspx), I asked about preferred syntax for coding a cursor-traversing loop. Most of the replies strongly disparaged the use of cursors.

So, for the edification...

Also, is your parameter an int or string type. If the latter, you will have to take quotes into account, like this:

="SELECT * FROM Employees; EXEC dbo.insert_into_table_Sprocs @parameter='" & Parameters!XXX.Value...

lalonacademy (3/28/2008)

---

I should have this in a command type text or as an expression?? You have a "=". By the way the I have named list in the...

We followed the recommendations on that link and tried re-applying the SP, but no luck.