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...

Apparently not...when I tried it in 2K5 it said it doesn't exist. For what it's worth, I also went thru the microsoft support / chat we have access to...

Does this apply to SQL 2K5 also?