Thanks for the info. Is there something you'd like to see? Hopefully we'll get around to adding some sort options here over time.

Doh!

Actually you are correct, but we have other constraints, bandwidth, money, and you guys hammer the bejeezus out of this place. We're averaging (5...

We've talked about this before. I think points only accumulate for the first day (before the next newsletter) and then it's just a learning thing. However with the site cutover...

This is a good idea. I'll get it on the list.

select @@version

good luck

Thanks for the feedback Chris!

No books I know of and I'm sure MSDN should have something on redistributing and wrapping in an installer.

MSDE functions the same as a SQL Server, so once it's installed...

run the scirpt from isql/oswl in the command line. /? will give the options, which to a file is one.

If you need to schedule this, SQLAgnet can run this as...

What are the info schema views lacking?

We'll add it to the list.

If you have trouble shrinking, try this. http://www.sqlservercentral.com/scripts/contributions/26.asp

 I use a script in a DTS job to do this. No way I know of in SQL to easily do it.

Try this: http://www.sqlservercentral.com/scripts/contributions/26.asp

Check the actual values in sysusers for your uid and sysobjects for the object id, then check syspermissions. See if you already ahve permissions

It could be because you are dbo.

'' isn't null.

insert mytable select null

will do it.