Piotr.Rodak (10/5/2009)

---

It looks your database is subject to replication, isn't it? I found article of Paul Ibison[/url] that discusses similar (I think) issue. It looks like you will have to...

Hi,

Thanks for the reply. Unfortunately i tried that also with no success. I only use one schema, everyone uses dbo.

One question i have regarding those that use a purely windows environment, is how do you keep your users from using tools like access/excel etc to look at your data?

I...

I work with a similar file structure with Banking systems. the way i do it is via SSIS. i import the file into a staging table which stores...

was he talking about partitioning? if so then yes that can greatly improve the performance of your database

Do you still actually want the job to continue if one of the steps fail? if not then just change the failure action to "quit the job reporting failure"....

what authentication are you using in your data source?? And does the report fail for you when you try to run the report or just other users?

Also check that...

Jpotucek (9/2/2009)

---

We have A SQL Server 2000 Server with Several Instances and a seperate SQL Server 2005 Server built out with the same instances and I have been migrated databases...

Thanks Grant. assuming i do raise an error, i assume this still cannot be read by the sql job as to whether ot not to run the second step....

it does sound a bit conincidental, and like you say the database move appears to be successful.

A couple of things i would try.

1) is there an application log - or...

why not just put an extra column in your destination table and give it a default of getdate(). that way you wont need to change your current SSIS job...

you only need to use the expression part once. create a variable - call it something like outputfile - which you can evaluate as an expression. then use...

This script is...

look at sys.sysprocesses

select * from sys.sysprocesses where blocked > 0

This will return the SPID of the offending transaction (the number in the blocked column is the SPID number that is...

ive not got any links to documents etc but by default SQL 2005 is fairly secure as a fresh installation as all the remote routes into it are closed anyway,...