I'd probably set max memory to 28GB and see how it does. The file io CLR functions are the only things that concern me. If they pull large...

I don't think you can change the name, but I do think you can change the IP addr. the disks are a bit more tricky, you have to add...

Triggers can be added to tables and can handle inserts, updates, and deletes. Triggers cannot be created on sprocs. You might also consider using CAPTCHA to make sure...

Keep in mind flashy new features that you don't need or are unlikely to use don't sell it. the fact that SQL 2000 is end-of-life and that you can't...

Yikes, that is good to know.. Thanks for the heads up..

CEWII

Nope.. Sorry..

CEWII

Hm.. Never tried that.. I bet it wouldn't be difficult to test..

CEWII

I am wondering why them seeing the database is such a deal breaker, they can't access it..

You might look at:

http://msdn.microsoft.com/en-us/library/ms189077.aspx

If you run this command:

REVOKE VIEW ANY DATABASE FROM public

all they...

PiMané (11/12/2009)

If I may, if you have room on the database server to complete your backup locally, I'd do that and THEN move the backup file to the other server....

1. SQL and SSIS on one box, plenty of memory and processors.

2. SSAS seperate

3. SSRS seperate but with ReportServer and ReportServerTempdb on the SQL box. No local SQL.

4. SAN.

Now,...

I was just looking at this, it looks like the copy objects will copy defaults..

Anything else you noticed it was missing?

I was thinking also that the only way to make...

a2zwd (10/23/2009)

Thanks for the replies.

No, I can't do using simple flat file source coz it is a csv file and delimited("). The column value also contains commas and...

Couple thoughts..

1. You can share a folder and control who has access to it, so you can access it and the server can access it but others can't..

2. You don't...

At what point is the package failing, is it failing at the source or further down? If it is at the source then you will have to modify your...

You could limit the amount of memory it uses by setting up memory restrictions on the lookup.

CEWII