Awesome. Glad it worked.

I've been running firefox 3 on multiple computers under multiple OS's and have not had this issue anywhere. You should make sure that it is NOT set to clear...

That was extremely useful, thank you.

I really like the script, but it does not maintain the unique portion of indexes which makes it hard to use in some cases.

zahid.m.shafi (8/13/2008)

---

hence I think stored procs are not the way forward because much *bespoke* coding [function of client AND server side] is what it eventually results in...

[ In fact may...

Steve Jones - Editor (8/12/2008)

---

I'd agree with Andy. The issue I have with datareader is that it automatically gives rights to all tables. So if I add a table to...

That sounds like good advice, Steve. I know he's too young now, but I'll keep looking out as he gets a little bit older. Thanks.

Until this week, I did absolutely nothing. Then I got talked into preparing for a Marathon, so I started jogging each morning.

Several people have mentioned martial arts, which is...

This was a very informative article. I would join the call to expand it into a series going into more detail on the differences and when it is appropriate...

What gives you permissions to create jobs? Are you a member of the sysadmin server role or a member of the fixed database roles in msdb?

Which version are you using? And in particular if you are using SQL Server 2005 have you installed SP2 on both SSMS and on the SQL Engine itself?

In 2005 you can use SSIS instead of DTS. It is more powerful and more standards compliant. The fact it is more standards compliant can make it less...

You could look at using open Opendatasource with a schema.ini file, which is described in http://www.sqlservercentral.com/articles/OpenDataSource/61552/ .

If this is 2000, DTS should also be able to do it very efficiently...

Awesome article. It is good to know and makes me very glad that memory was much less constrained than that by the time I started programming.

Nice article. Its worth pointing out that (at least so far as I can tell) the very nice missing index feature in the graphical execution plan only works when...