Once you install SP2 - the Provisioning tool for Vista should launch - be sure to set up...

one of these days - I'm going to figure out how to colorize my code without turning it into a wreck........hehe

Absolutely. Essentially ignore the "this program has compatibility issues" messages,...

WRACK (4/8/2008)

---

Thanks Matt,

Only thing confused me was your reply

I assume you mean if I add them to...

Jacob Luebbers (4/8/2008)

---

I can verify your results: changing to the dynamic SQL version runs at 1.2 sec at @PageNum = 8000 on my test data/server.

Now to speculate on why...

I can't...

Model database is what is used as the model for creating NEW databases. So - whatever objects exist in Model at the time of creating the new database would...

Jeff Moden (4/8/2008)

---

Matt Miller (4/8/2008)

---

Jeff - which ones? sys.all_objects is context-sensitive, as is all_columns, all_views, syscomments, sysobjects. I haven't tested them all - but I have yet to...

Jeff - which ones? sys.all_objects is context-sensitive, as is all_columns, all_views, syscomments, sysobjects. I haven't tested them all - but I have yet to find one that shows...

Correct - I didn't specify that very well earlier. ...

It's the least I could do... You already did the heavy lifting...:)

As some of us discovered recently - you can also check the default trace, or use the "schema changes" report available on right-click in SSMS on the server name.

SQL doesn't have a "TRIM" function, only RTRIM and LTRIM.

So replace the last line with:

T1.File_Desc = Ltrim(RTrim(cbFileDesc.text) )

As part of the Reporting services config tool, you set up two virtual directories in IIS, one of which is the "report manager". That's where you have access to...

Short of recreating your environment on 2005, or attaching that database to a 2005 server and upgrading it to compatibility level 90 , no, not that I know of. ...

Assuming @SearchString itself doesn't have a leading wildcard, you should be able to get something of a performance boost out of a covering index.

something like

create nonclustered index ix_MyTable on MyTable(name)...