I can't really speak on any performance issues that may cause, but one thing to consider is what other affects this may have.

You'll need to make sure that...

Try this...(I just modified your code). You can rearrange the MM/DD/YYYY order as needed. I just typed that on the fly, so might check that all my parens...

you mean you want it to create c:\yakka_11_08_2007, then the next time create c:\yakka_11_09_2007, etc.?

That will vary based on your zip program, but something like this ought to get you started.

I think this will work for PKZIP, but I didn't look up the exact...

You've got me on that one.

Unless it's putting Books Online and the client tools and other junk on the C: drive

I don't remember it asking where you want...

Couldn't you just:

1) Backup your master and msdb databases (and either backup or detatch and retain your user databases)

2) Uninstall SQL, Reinstall in new place

3) Restore / Attach all the...

I've played with the permissions quite a bit...my user is in the sysadmin role, but I've also tried creating a user that has no rights other than what is necessary...

Thanks. I've tried to replicate the issue on other servers (we've got about 15 or so SQL 2K5 boxes) and haven't been able to. There has to be...

Sure. It's really easy.

I just fill up a variable, say @CMD with the same command text I would use if I were executing from the command prompt,...

Correct. But all that SSMS does when you right-click and say new is open a new query window with a CREATE PROCEDURE stubbed out for you. Would that...

Do you have any encrypted columns?

As long as you don't mind using xp_cmdshell, that can easily be done.

You are correct. Niether of those queries below will return system stored procedures.

I am verifying mine three ways:

1) SELECT * FROM sys.objects where is_ms_shipped = 1

2) SELECT...

Thanks.

It's funny. It appears that Microsoft really doesn't want you to create stored procedures as system stored procedures. That proc. you mention isn't in BOL. But...

OK, I've decided to approach this backwards.

Now I'm looking for a way to create a stored procedure (In SQL 2005, NOT 2000) and mark it as a system...