It's CREATE_PROCEDURE

http://msdn.microsoft.com/en-us/library/ms189871.aspx

There's a difference between pitching in and regularly wasting time. I've made coffee before, refilled printer paper, and changed light bulbs. It helps to have everyone willing to help. But...

blandry,

I didn't reveal all the information, but there is a bit more. My friend manages the customer relationship, there are 3 or 4 sales people involved and engineers, and there...

It's definitely a security issue based on Windows, not SQL Server. This is the type of error you'd get with either of the security issues mentioned by Perry. check with...

What Perry and Gail are looking for is the actual command that might be failing. What you want to do is get the command working, and then work backwards, looking...

I'm with Grant here, look at hardware.

also, is this a new restore or restart? Could it be caching somewhere? If you run that query twice, is it the same speed...

First, please post in the appropriate forum and give your version. Moving this to 2005 admin.

Second, you need to check the SQL server logs and look for the reason that...

5 days is plenty. Sorry, missed the OP date.

I'm interested to see the benchmarks. I know doing this in C would be complicated, but not tremendously more than a search...

Give him or her time, might be on the other side of the world.

If you compare REVERSE with SUBSTRING or other string functions, how much slower is it? Any benchmarks?

Well we have 4 horses, and while they go up the hill easily, it's the picking up behind them that's not much fun 😛

But be sure that you know if you need a low fill factor. This is the percentage of space on the pages that are filled. If you are really growing...

Phil,

A fantastic last sentence and a great editorial. I too am not sure that we can build a great code checker for SQL, but there are definitely some basics that...

or just R (read)

OK, my head hurts.

I've awarded back points since there is obviously some issue here. I missed the correct answer with 1/30, so I've fixed that.

As far as the other items,...

Look also at RESTORE FILELISTONLY