Hmmm, kind of stumped. What are the packages doing?

Steve Jones

steve@dkranch.net

Nicely said Brian

Steve Jones

steve@dkranch.net

Glad we could help. Keep posting!!!!!

Steve Jones

steve@dkranch.net

4 ski resorts open now, wearing jeans and a t-shirt, sunny, a dry 60F

Last year, we were wearing jeans and long sleeve shirts...

What happens if this is comprimised? Not hacked, but disgruntled employee, etc.

You are still better off with a role. Needs will change. You might disagree, and I'll grant in your...

85%

Have lots of computers in the house.

Steve Jones

steve@dkranch.net

Most humble blue belt DBA Steve agrees as well. I really wish the exams would be redone becuase there is a HUGE potential for really testing people, proving knowledge, AND...

I'd argue that it is. You never know when you will be asked to do something. There are lots of NT items I was tested on and never used, but...

See your other post. Pls don't cross post, we check all these forums.

Steve Jones

steve@dkranch.net

Can you post more information, samples? Not completely sure what you awnt.

You can use a computed comlumn to compute these on the fly. Or a trigger that performs the update.

Steve...

thanks for the followup

Steve Jones

steve@dkranch.net

xp_cmdshell should work well. I'd schedule the pacakge and take the encrypted values to use for a xp_cmdshell.

Steve Jones

steve@dkranch.net

Are you sure they ran? Dbl check the date and times. I had some issues with the schedules getting disabled.

Otherwise, I haven't noticed this specific issues like this. You might...

You need to match up the correct path on the restored server.

This is the path on the backup server.

What you do:

Pick the file to restore, then go to the 2nd...

Use the REPLACE function before the insert to replace all single quotes with double quotes. This "escapes" the single quote.

Steve Jones

steve@dkranch.net