leokarp (12/21/2007)

---

If an application has embedded SQL statements and they are referencing system tables directly that may be the case of application being compatible only with a particular SQL Server...

If your vendor says his app is only 2000 compatible, I wouldn't mess with putting it on 2005, even if that DB is in 2000 compatablity mode. Even if...

You mean they can't connect to the server at all, or they can connect, but just can't get xp_cmdshell to work?

It's finally solved.

Our network guy who(m) is much more clever than me added an entry in the PATH variable and it magically started working. Apparently the pdfcombine...

That's the strange thing. It works...

I don't...

Windows Authentication. The user is both a sysadmin, and a local admin...

This one was a fresh install. (Actually, I've never tried an upgrade from 2000 to 2005, I've always been lucky enough to have new boxes to work with)

I think I've finally got this one nailed down.

There is an 'allow updates' option you can set with sp_configure. This was an option you could set in sql 2000,...

The schema_id is the correct id for whatever schema I create it in. (The problem applies to all schema). I just did a test and the principal_ID is...

Tried a service restart. No difference.

Isn't that the same question as this one?

http://www.sqlservercentral.com/Forums/Topic420184-146-1.aspx

Rama (11/8/2007)

---

Hi,

Could someone help me with a code that would simply zip a folder in the location 'C:/Temp/RG2'

as RG2.zip and...

I'm going to try to bounce the SQL Server service tonight and see if it makes a difference. Probably won't, but shouldn't make thinks any worse. (famous last...

Right...but whatever user the sqlserveragent service is running as will need appropriate permissions to the source/destination paths, and permissions to execute the zip execuatable.

Your syntax looks OK off the top of my head. A couple of things to try:

1) You probably will need to put the full path to the zip executable...