Viewing 15 posts - 38,746 through 38,760 (of 39,804 total)
When you execute the package, it runs under the context of your login and from your workstation. When it runs from the scheduler, it runs as the SQLAgent service account...
January 8, 2002 at 10:20 am
I tend to agree with Brian. I looked around, but couldn't find anything on this. Everyone mentions writing event messages, but no-one has info on changing the category. I suspect...
January 8, 2002 at 10:14 am
I believe in SQL 6.5, that you can script the procedures from Enterprise Manager. If I remember, it is in the Tools menu.
If not, you could get an eval of...
January 8, 2002 at 10:13 am
Write the select query first and see if it returns the info you desire. If not, post it and we'll take a look. Paul and Andy provide a great solution.
Steve...
January 8, 2002 at 10:11 am
Great suggestion. I'll take it up with the founders and see. you can get a short one here:
http://www.sqlservercentral.com/other/AboutUs.asp
Steve Jones
January 8, 2002 at 9:43 am
January 8, 2002 at 9:32 am
January 7, 2002 at 4:42 pm
You could let one package call another conditionally based on a global variable. The dynamic properties task can handle this and change the name of hte package to execute based...
January 7, 2002 at 4:16 pm
January 7, 2002 at 4:06 pm
January 7, 2002 at 2:50 pm
You're welcome. It should have been an SP2 thing and I should have mentioned it.
Steve Jones
January 7, 2002 at 2:49 pm
What are you working on? any chance of your company moving to .NET. Is there an investment in COM / VB6 technologies?
Personally I'd just go to .NET, but there isn't...
January 7, 2002 at 2:44 pm
It specifies the specific columns. follow the format listed exactly. On the verson line it is the first column.
Steve Jones
January 7, 2002 at 1:48 pm
January 7, 2002 at 1:42 pm
no script I know of. Should be able to build a serise of commands using system views.
select 'alter table ' + table_name + ' add column xxx'
from information_schema.tables
Steve Jones
January 7, 2002 at 1:40 pm
Viewing 15 posts - 38,746 through 38,760 (of 39,804 total)