select db_name()

Steve Jones

sjones@sqlservercentral.com

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

Either that or detach/attach. Raul Sharma has an article on usnig that on this site.

Steve Jones

sjones@sqlservercentral.com

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

The speed of SS2K is plenty, just depends how things are implemented. There are lots of tricks you can do, use triggers to keep a summary of data current in...

Depends on load. For smaller apps, I've dropped everything on the same RAID 5 and no big deal. Nice to separate out, so if you move the hardware later, the...

Thanks for the updates. I neglected to test this and didn't see an errata on this.

Steve Jones

sjones@sqlservercentral.com

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

Thanks for the update.

Steve Jones

sjones@sqlservercentral.com

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

That should work fine.

Steve Jones

sjones@sqlservercentral.com

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

A text file?

xp_cmdshell 'type filename.txt'

Steve Jones

sjones@sqlservercentral.com

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

On the SQLAgent proerties box, there is the place for a proxy account, which will be the account under which xp_cmdshell runs.

don't forget xp_cmdshell is in master, not another db,...

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