The osql utility has a -o switch which can be used to write any output generated by the command to a file. You could add this to the command...

You can generate the windows command for running your package by executing "dtexecui".

This utility give you options for all of the settings required for the package and then shows you...

triggers run as part of the same transaction as the insert statement. If the trigger fails, the transaction is rolled back.

Identities are not generated/locked by the transaction. If...

Is the issue that when you create a stored procedure one of more of the objects it depend on does not exist yet ?

As far as I know, this is...

Further to what Paul said, in a production environment, you should be setting the database file sizes to what they need to be so that they do not need to...

First, change the location As2005 is using for its data directory. Connect to the server using Management Studio, goto the server properties (right click on the server name). ...

I guess my real issue is that the question assumes knowledge that I don't have (about golf) - it would not surprise me to find a lot of people do...

So what is it that golf does ?

It ain't easy to answer a question when you have no idea what the answer is supposed to look like (yeah, you...

Some posts there have raised concerns about collations. Whilst it is highly desirable to have everything nicely aligned (including collations), this isn't always the case. It is pretty...

Deleting the server registration has absolutely no affect on the server. It is only removing it from the list of server that Enterprise Manager shows you.

For replication, you need...

In SQL 2005, an alternative is to define a synonym. They are very easy to create and provided you have a linked server in place, you the underlying table...

Ideally, you would use the project/solution that was originally used to develop the cube.

Assuming that this is not an option, you can do what you want using BI Development Studio....

There is no need to write any code for this.  Excel pivot tables have an option to auto refresh when the spreadsheet opens.  All you need is to check the...

I would be careful using mapped drives.  You get issues with trying to use the same drive letter for users logged in on the console and for services.  These arise...

I assume that in your foreach task, you have a data flow task that has, as its source, an OLE DB source with a  SELECT statement on the MS-Access table...