Viewing 15 posts - 35,536 through 35,550 (of 39,769 total)
You need a MAPI client. Or xpsmtp, which is an extended stored proc itself.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 9:44 am
Interesting thought. No way that I know of, but I'll keep looking. This might be a handy option.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 9:42 am
Are you sending the password through? Pwds are not stored in the DSN.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 9:37 am
I'd rename the file after it was created with a simple xp_cmdshell 'ren oldfile.zip newfile_date.zip'
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 9:35 am
for the first one, you need a table alias, so
select a.* from (select....) a
where a.cnt > 1
For the 2nd, look up CAST in BOL.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server...
December 29, 2003 at 9:30 am
Is Auto Update statistics turned on?
It's an interesting question and I thought that reindexing would fix the statistics as well with a new sampling, but perhaps not.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of...
December 29, 2003 at 9:27 am
I'm guessing that the osql isn't evaluating the variable properly. Does it invoke other items? Like osql -smyserver -u%username%?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 9:24 am
I wouldn't put it on NAS. We've had issues with backups to network drives for the reason that SQL Server is not very tolerant of network delays. I wouldn't want...
December 29, 2003 at 9:21 am
I like the title change idea. We'll take a look at that.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 9:19 am
You can by placing an xp_cmdshell in the trigger, but be careful. The trigger will not complete and the transaction will not complete until the program finishes, which means locks...
December 26, 2003 at 11:34 am
Agree and thanks for the note.
Thanks to all for their contributions and thanks that my family, friends, and partners are healthy!
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 26, 2003 at 11:32 am
Don't grant to users, use roles.
That being said, the permissions matrix is by user/role by object, so you'd probably want to query for a specific object to see the permissions....
December 26, 2003 at 11:30 am
you can do it with DMO (I think Andy has an article on this) and then run the script from a job.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 -...
December 22, 2003 at 3:42 pm
@##^%$$#%$#%#
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 22, 2003 at 11:28 am
Viewing 15 posts - 35,536 through 35,550 (of 39,769 total)