Viewing 15 posts - 38,461 through 38,475 (of 39,466 total)
You can, but you will shell out to a folder based on the sql account.
run xp_cmdshell 'dir' to find out where you are. You can then change folder or add...
January 4, 2002 at 10:19 am
Has the name of the server changed? Or perhaps the changes have caused connectivity issues.
Steve Jones
January 4, 2002 at 10:18 am
You run xp_sendmail from master (as in execmaster..xp_sendmail). I'd build the email message using a while loop and then run through each row sending an email. Or you could group...
January 4, 2002 at 10:16 am
January 3, 2002 at 3:15 pm
January 3, 2002 at 2:38 pm
January 3, 2002 at 1:05 pm
The beauty( theoretically) is that you can write in whatever language you like and it can easily interact with modules (functions, stored procedures, etc) written in other languages.
Steve Jones
January 3, 2002 at 11:37 am
aliased tables is a great idea. Never use that one. I'll give it a try. Thanks!!
Steve Jones
January 3, 2002 at 11:34 am
I try to avoid dyanmic sql whre possible. I choose case statements to call stored procedures for various queries.
It avoids the problems with owernship chains.
Steve Jones
January 3, 2002 at 11:31 am
The for xml is built to return a stream, not really a result set.
You could probably built something, but can the middle tier not handle a stream? They can also...
January 3, 2002 at 11:18 am
Wes, thanks for the info.
I've used DELL Compaq, Adaptec, Mylar. No issues with any but some are easier than others to setup and work with. I have had SCSI backplace...
January 3, 2002 at 11:07 am
I extensively use the CTRL-SHIFT-C and CTRL-SHIFT-R extensively in QA to comment and uncomment a series of lines when making queries (as well as begin tran).
Why?
Too often I've typed the...
January 3, 2002 at 11:04 am
Try this:
declare @d datetime
select @d = '01/03/02'
-- first day of month
-- select cast( convert( char(6), @d, 112) + '01' as datetime)
-- last day of month
-- select dateadd( day, -1, dateadd(...
January 3, 2002 at 10:47 am
January 3, 2002 at 10:33 am
You will have problems because the limit for a parameter is varchar( 8000) and an XML doc can easily exceed this.
Form BOL, Generally, FOR XML cannot be used for any...
January 3, 2002 at 10:32 am
Viewing 15 posts - 38,461 through 38,475 (of 39,466 total)