Viewing 15 posts - 46 through 60 (of 2,611 total)
Enabling xp_cmdshell is done through surfact area configuration. Executing the package is basically done calling the DTExec.exe executable.
I think you have selected the worst way to deal with your...
February 10, 2009 at 9:55 pm
Ok, you can run an SSIS package from a stored procedure. You can either enable xp_Cmdshell and execute SSIS using the command line syntax. Another option would be...
February 10, 2009 at 11:44 am
A trigger is event-driven on actions against your table. A stored procedure needs to be called by something.
They typically do not serve the same purposes. Perhaps you could...
February 10, 2009 at 11:36 am
I find the data sources in the projects rather useless. They just muck up the connection information you get from local configuration files when you open a project in...
February 6, 2009 at 9:49 am
You can script things in Enterprise Manager.
Edit the table, then rather than saving it, click the generate script button.
February 6, 2009 at 7:30 am
We have a rather large data warehouse implementation here.
For the SSIS portion of the implementation, we have a few solutions - I will describe one of them (changing some names...
February 6, 2009 at 6:10 am
Your question is not specific enough. There are lots of ways.
Read this:
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]
Then update your post.
February 6, 2009 at 6:00 am
Open the Cube in BIDS (not the dimension) and click the cube structure tab. Make sure the attributes and hierarchies you want to see are enabled and visible (look...
February 6, 2009 at 5:55 am
This seems like a pretty old programming argument with a bit of a different technology. The terms "relational" and "RDBMS" can be loosly or tightly defined. So, it...
February 5, 2009 at 8:14 am
Search on Google. There are a couple of 3rd party utilities that make pseudo FK's that cross databases.
Beware, you can do this with check constraints and/or triggers, but they...
February 4, 2009 at 12:01 pm
peace2007 (2/4/2009)
Jack Corbett (2/4/2009)
February 4, 2009 at 6:58 am
I'll add to this...
To me, "INSTEAD OF" triggers always feel like "INSTEAD OF DOING IT CORRECTLY" triggers. They are great for a stop-gap when you need to make a...
February 4, 2009 at 6:53 am
Posting the DDL and the execution plans will be helpful and get you better responses. Here are some tips on how to post:
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]
February 4, 2009 at 6:44 am
Set the data type of your parameter to a date and you will get a date picker control (assuming you are using report manager).
February 4, 2009 at 6:37 am
Viewing 15 posts - 46 through 60 (of 2,611 total)