Viewing 15 posts - 1,276 through 1,290 (of 1,353 total)
While there is a way to use your own step names using Disconnected Edit, I have not used that, and so have always had to use the name given to...
May 11, 2004 at 2:34 pm
I too have found the Do not execute to not be the best way to do this, so why not try my suggestion and disable the subsequent step if there...
May 11, 2004 at 1:07 pm
I have sometimes found the don't execute task method to not be completely reliable. You could also try a variation of this. I use this to disable the subsequent step. ...
May 10, 2004 at 7:21 am
Similar to the above solution, you could create a temp table in a business object, populate it with the entries selected, and write the stored procedure to use the temp...
May 5, 2004 at 7:29 am
Not sure to which post you are referring because the time stamps are close, but if it's mine above, I am talking about a web application. The reports are on...
April 16, 2004 at 9:42 am
We create a business object on each server (dev, test, train, and production) that provides the connection information. That component is accessed by each object, so as each object is...
April 16, 2004 at 7:47 am
I prefer fewer larger ones, though I do separate out smaller ones that could be independently used for other things. For example, if I have an import that triggers a...
April 15, 2004 at 6:52 am
I agree that cursors should be avoided at almost all costs. If you find this is one of those rare events that would require a record iteration, however, since you...
April 9, 2004 at 6:57 am
Go to SQL Server Properties (Configure), under the Server Settings tab there is a SQL Mail Portion.
March 24, 2004 at 6:41 am
I don't know if this is the only way it can be done, but we do it this way and it works. The SQLServerAgent runs under its own user account...
March 24, 2004 at 6:30 am
We use this command in all our report SPS, or as a connection property, and it works as expected.
February 13, 2004 at 8:19 am
I did know that. What I'm looking for is some code, preferable VBScript, to FTP the file out. I've seen one sample, but it's not particularly clear, using...
December 26, 2003 at 5:17 am
tbl may not say much, if all your tables were to start with that, although it certainly distinguishes them from the system tables. But when you have tlkp, tbl,...
December 1, 2003 at 7:37 pm
I know this is an old topic, but I've been busy. My two cents: Numbers that are not calculatable are strings. Char(10) for phone numbers. The...
December 1, 2003 at 7:08 pm
Viewing 15 posts - 1,276 through 1,290 (of 1,353 total)