You should be able to use an Execute SQL Task to check the fragmentation amounts and then have a conditional precedent to lead up to the reorganization task. But I...

You have to use a data conversion task to change the data from WSTR to STR or vice versa. It's like the difference between unicode and non-unicode characters. In fact,...

What kind of login / permissions are your connection managers using?

What you need to do is define a variable with a Global scope (or within the scope of the container that both tasks are in). Then in the Execute SQL...

PeterG-377490 (7/8/2010)

---

Trying to be proactive.

Sales transaction database. 100's millions of rows. I built an access front end for users to view reporting.

Sounds like if i let the sales columns...

Ah, my probationary period for one job started right in the middle of a major project. There'd been over a hundred scope changes the the project was due the end...

What do you mean summary? And why would someone need to send you their resume?

Good point about the TRUNCATEONLY issue being only data files. Maybe that's what I was working on, I don't remember.

Alen, are you getting a specific error message when you try...

PeterG-377490 (7/7/2010)

---

While i have your attention Brandie - I mentioned the typical query. That query will also return the sales information. Should i use those columns as an included column...

iqtedar (7/7/2010)

---

thanks. One of the issues what i can forsee by using sql agent is that ,lets say i have 200 jobs then i will need to manually add agent...

Did you try running the DBCC Shrinkfile with TruncateOnly after or before the EmptyFile?

ISTR going through this and I had to run both of them (don't remember the order) before...

Don't worry. We all started that way.. @=)

PeterG-377490 (7/7/2010)

---

A typical query would be to search for a transaction...

As the others have said, this is all built into SQL Server already. And if there's an alert you can't find, but want, you can make your own.

And on jobs,...

Eugene Elutin (7/6/2010)

---

Post #945638 explains how you can generate random number using NEWID() function without using FranchiseID column to randomize.

It doesn't uses FranchiseID in the TaxID...

I just realized I'm going about this all wrong. I don't need *random* numbers specifically. I just need numbers that are NOT the TaxID. Which means I can use a...