Is the number a column name or in a row in the table? If it's in a row, is it always in the same column name?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

the client has to send this. Check the client app settings for ODBC or whatever conneciton method you have.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

You could probably build htis programattically using DTS, aCtive X task and some outlook controls. Or even a custom control.

We use voting buttons here. I'll try to look at this...

You could probably build htis programattically using DTS, aCtive X task and some outlook controls. Or even a custom control.

We use voting buttons here. I'll try to look at this...

Thanks both of you. And I agree. I should rename the controls, even if this is the simplest form, I may reuse it. And may want to...

There are some beginner articles on DTS. I'd start there. Create a text file conneciton, select your file and use the "properties" to verify this works.

Then add a SLQ connection...

2nd vote for Brian's explanation.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

sometimes logs don't shrink well. There's a script in our library to help do that.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

You can also script your own sp_password that would run after 35 or so days to lock out users.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

This is the reason you DO NOT go into the system tables. They change from version to version.

Better to use the sp_helpsort and parse the string. It will work...

I think this varies so widely that it's tough to have a good checklist that you're not skipping items. A good idea, just not sure it's something that works well.

Things...

Not sure this makes sense. You get a restore error while the backup is running? If the backup is running, you will not be able to restore the system. Or...

Agree with Antares. Query should have done something, but what happened.

Are you sure the query was correct? There was data to return. Perhaps you check the "check query" button and...

Can't use a text datatype as an output parameter. Return it as a result set.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

There are threads. Two differnt philosphies.

1. Build dynamic sql statement and execute it.

2. Prebuild stored procs for each combination. Call these from one central proc based on parameters passed in.

Steve...