If you have a look in the SQL server logs it should show the failed login with the error numbers to indicate why it failed (password, wrong user ...

I am not an expert on this, but from what I understand once you import the SSIS package into SQL server it is in a compiled form and the only...

You can use SSIS to do this.

though if your databsae is large then you are going to run into trouble exporting to excel 2003 as excel 2003 and earlier versions...

Is app1 a valid login/user for your database?

what are the error numbers your are getting with failed login?

use a datetime or smalldatetime column with GetDate() as the default value

shakti (10/1/2008)

---

What is the best way here? Triggers or transactional replication?

I know how to create the triggers? but is it a suggested procedure? i feel that if the records...

If you need to have the data kept up to date from the four servers then you should be able to do this with transactional replication.

You can set up one...

There a lot of opurtunites for SQL developers/dbas in the UK and also a lot of BI positions are opening up, but like a lot of jobs they are...

I havent had any experience with this setup , but make sure that whatever they implement gets fully tested before going anywhere near your production system.

For our backups we use...

you can do this using the row_number() function;

SELECT Location, ProductID, Qty,

ROW_NUMBER() OVER (PARTITION BY Location ORDER BY Location, ProductID) AS NewOrder

FROM YOURTABLE

This is quite a big topic and will depened on who you talk too, but i think this video explains it all

http://www.youtube.com/watch?v=nwXHUts9uPA

torstentiedt (9/30/2008)

---

Thanks for your reply.

To guarentee read-only-access to tables via security rights could be a solution. But isn't there any solution implemented with the replication itself, which would be easier...

Primary key will should probably be UserId, FileId,...

You can use SQL security to create a login/role that has only read access to the tables in your subscriber, and only give the account that you are running...

FNS (9/29/2008)

---

Yes I do need data as well as structure. Since the db is 20Gb I was rather hoping to avoid the backup to file, copy file (to another...