That sounds like a plan..

CEWII

hein-1120388 (4/21/2010)

---

So I can still schedule stored procedures with SQL Express 2005 & 8? I can't find the option in Management Studio....

hein-1120388 (4/21/2010)

---

Thanks again for your advice. I'm going to do the following:

1. Move SQL to a non-standard port.

2. Create a very long password for sa.

I just dont see why I...

no the way you are using it..

But you could create a SQL login that is NOT in the sysadmin role AND has been granted EXEC rights to xp_cmdshell. That...

I tend to do the deletes first, then the updates, then the inserts.

What are you using for the updates and deletes? OLEDB Command Transform?

Also what is the average mix...

You would write the windows service in Visual Studio, it IS possible to do it in VS Express but the templates don't exist in that version but it can be...

For mostly insert situations it works pretty good, if you have substantial updates it is not as fast also working with smaller windows of data always helps. In my...

You are using the Server proxy. That (if I remember correctly) is only used by non-sysadmin users when they call xp_cmdshell. So even though you have it setup...

SQL Dev-938873 (4/20/2010)

---

I want make data saving in encrypted format. then even though backup also having encrypted data. So both will come under this.

SO i want to encrypt my...

hein,

Not to put too fine a point on it, but the fact is that SQL doesn't do this, hole or not. A VPN solution would be the best, but...

Instead of a checksum why don't you implement a LastChgDt column and keep track of the fact that the row has changed and then only feed those rows into the...

1. Best reason is largely dependent on your environment. But licensing costs is often a good reason. OR loss of strong Crystal resource inhouse can also push away...

I quick review of the Books Online indicates NO. It is an instance level permission. And the CONTROL SERVER permission is implied by granting it. I could...

As a practice I try to NEVER put anything in master that MS didn't deliver. If I have a case where I have server global objects I generally create...

There isn't really a continue, you have to restart the job. You could create an auto-start sql-agent job that looks at recent job statuses and restarts all backup jobs...