Viewing 15 posts - 38,446 through 38,460 (of 39,456 total)
I too have small dbs, so I don't bother, but I worked with a company that had a heavy OLTP load. As a result, they wanted log backups often,...
January 4, 2002 at 10:38 am
I'd use the dyanmic properties task to generate a file name from a SQL statemetn and assign that to the text connection.
Steve Jones
January 4, 2002 at 10:30 am
I'd split this, or perhaps change the transaction size. You likely have some data issue somewhere that is not getting handled well.
Steve Jones
January 4, 2002 at 10:27 am
Never seen this, but we tend to make these mods when everyone is locked out. We also script do that the changes occur in a minimal amount of time.
Steve Jones
January 4, 2002 at 10:20 am
Never seen this, but we tend to make these mods when everyone is locked out. We also script do that the changes occur in a minimal amount of time.
Steve Jones
January 4, 2002 at 10:20 am
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
Viewing 15 posts - 38,446 through 38,460 (of 39,456 total)