Viewing 15 posts - 616 through 630 (of 1,222 total)
I am wondering why are you using a staging table in the first place. The logic you are using looks pretty simple to implement in SSIS with a combination...
April 14, 2010 at 10:35 pm
First things first - take a copy of the files before you do anything.
Next...since SQL Server crashed, there may be transactions that are partially committed i.e. transaction recovery will need...
April 13, 2010 at 9:51 pm
The table on the subscriber can have any indexing strategy that is required for the intended use of the table on the subscriber. If you want a different clustering...
March 25, 2010 at 9:38 pm
If the user is not a SQL Server sysadmin, you must define a SQL Server proxy account if the user needs to run a SSIS package from SQL Agent. ...
March 25, 2010 at 9:34 pm
Why not change the distribution agent to run continuously and reduce/eliminate the need to update both databases ?
As far as doing UPDATEs on the subscriber, this shouldn't be...
March 23, 2010 at 8:59 pm
For SQL 2000, Reporting Services is a separate download / installation. Once you have installed Reporting Service, you will see the reporting services project type in Visual Studio
March 21, 2010 at 9:59 pm
The error is happening because
1. the name of various SSIS related sprocs changed in SQL 2008 ("DTS" finally becomes "SSIS")
2. by default, SSIS 2005 looks at the default SQL instance...
March 21, 2010 at 9:41 pm
Not sure why you are getting that error. Check service packs - do both servers have the same service packs in installed ?
If the new server is...
March 21, 2010 at 1:18 am
Save as a structured storage file instead. This creates a file with .DTS extension. You can copy this file to the other server and open it using Enterprise...
March 18, 2010 at 9:32 pm
If the BAS file is the only copy of the package that you have, the only way to open it in Enterprise Manager is to update the BAS file so...
March 17, 2010 at 9:54 pm
Have a look at the properties of the OLEDB Destination. I suspect that the "Data access mode" may be set to "Table or view". If it is, change...
March 17, 2010 at 9:33 pm
When a trigger fires, it is already in a transaction. So you don't need to BEGIN TRANSACTION or the COMMIT.
The INSERTED view contains a record for every record that...
March 9, 2010 at 8:34 pm
Connect to SQL as SA (to any database) and kill the connection to your database. You should be able to connect - you would be the "single" user using...
March 3, 2010 at 9:05 pm
I would be checking for blocking. Replication is attempting to deliver changes to about 10% of the records - to me that sounds like you probably end up with...
March 3, 2010 at 9:04 pm
Viewing 15 posts - 616 through 630 (of 1,222 total)