Its for audit purposes, and yes and no, it should be even, but not exactly, just as long as there are records from each group by no more then 10%...

thanks that worked, but I have a question about it. On the report for Schema Change, its showing me that all of the system stored procedures were dropped then created...

thanks for the replies guys and after some thinking about it, I'm going to put this kind of function in the business logic of the application. The table can get...

I found the issue, but its going to cause an issue in the future.

What's happening is, if a column is NULL on the first row, then that column is NULL...

Amit Singh (8/25/2009)

---

notsure ... might be very basic .... but do these double \\ sound right ... shouldn't it...

Steve Jones - Editor (8/25/2009)

---

Log in with the current service account, and then try to access the share. If that works, you're one thing down.

Can you run the backup...

It was running under a domain service account that has access to the share, then I switched it to a local service account, and that ID has read/write access to...

Yes

Yes

Yes

and Yes

I even mapped to the drive...

Been there done that already. That was my first thought, and no success.

Steve Jones - Editor (6/26/2009)

---

I'm confused,if you have the service account connecting to SQL Server, how do you get the individual accounts to come through? Typically we set up for...

thanks that worked

It has to be the same and happen in one "swoop"

select the random rows, then mark 'selected' in the table right afterwards.

So do you have one Id for every databases that your web apps use or do you have 1 ID per database for that web app to use?

example;

database1 = 1...

I have done that when I have groups hitting a db, but for applications such as web apps, I want to have 1 id and 1 password associated to that...

the db is set to unrestricted growth and has been, so that's not it.