If you're simply manipulating data, no, system tables aren't affected... well, OK, changing data can change statistics, so where the statistics are maintained can be changed, and if you have...

Mike Levan (12/2/2008)

---

I am tryingto automate re indexing based on the fragmentation.

some thing like this.

IF @frag < 30.0

...

"You don't know the power of the database"

Oh boy, we can have fun with this one...

"Don't fail me a again, programmer"

Whether or not to use varchar or nvarchar really depends on the type of data you're storing. If you are not now or ever going to store different character sets...

Clarification: "Column aliases in ORDER BY clause cannot be prefixed by table alias"

Sorry. What I said earlier was misleading. Also, on rereading, I'm not shocked that this doesn't work. I'm...

Darth Vader is better than Leather-face, which was what I came close to.

"I find your lack of indexes disturbing..."

Yep. I'm just starting the process of evaluating all our 2000 servers using the 2008 Upgrade Advisor. That's one syntax error that's popping up all over the place. I'm a...

The old parser would also let you refer to columns by the table alias and the new one does not.

Have you taken a look at the execution plans? Are different tasks being performed by the system?

Second vote for making sure you did maintenance after the upgrade, especially updating statistics...

Use SQL Agent to schedule the time for the daily run. You can run a tsql statement from within the Agent job.

Well now, our methods worked, but they were predicated off of joins and a single row out of each set, not multiple rows out of each set. I still think...

Chris Morris (12/1/2008)

---

Thanks for the tip, Grant, Ill try and get hold of that article. Do you mean this...

SELECT o.*

FROM #TOPTEN AS o

WHERE BATCH = 10

AND [ID] IN

(SELECT...

No, no, no apoloogies. If there's any misunderstanding, it's on my side. I think your solution is likely the only one. I've never needed to capture an output from sqlcmd...

Output to what? I mean what am I outputing to? Sqlcmd can just output to a file pretty easily if that's what you need.

You would want to use it with any of the ORM tools that try to walk the structure of the data returned. By masking the table structure off behind the...