...or the same functionality INTERBASE introduced a decade ago?

Sorry for being slightly off topic, but however much I like SQL Server, Reporting Services & Integrations services, I think it's really...

Well, now I've tried my quick and dirty syntax at home, on a SQL Server 2000.

As it turns out, my suggestion unfortunately only works on 2005, not 2000. http://www.norbtechnologies.com/support/articles/article01.asp

I found another...

Two single quotes on each side of both dbname and question mark worked fine here. It was a veeery quick and dirty solution, I haven't tested any other syntax variations.

Is...

If you don't care about the finer details with regard to fill factors and stuff, why not try something like this:

USE MyDBNameHere

exec sp_MSforeachtable

OK, my bad.

I have always used the syntax colname AS newcolname, believing it was required, but as it turns out, it is optional.

Eh - blush... How could I ignore that? They deliberately made it useless and replaced it with other, unsupported command(s).

Bastards.

Anyway, hope it can be of use to desperate SQL...

A system admin in a company I know of did exactly the  same, "to reclaim disk space". His backup routine didn't include transaction log backups. To make matters worse, a...

Heh, looks very familiar. I once had to convert data from an application which stored dates as the number of seconds since January 1, 1970.

Leif

Hilarious/Scary! But what a boost for my self confidence!

As a Norwegian, I was thrown a bit off by the references to lotion, Kleenex and Spotlight, though.   🙂

Heh, so I'm not the only one with the same problem!

For two days now, I have been trying everything - defragmenting, rebuilding indexes, recompiling SPs - but performance has not...

<We do daily backups of the databse to disk, but not sure if this affects the transaction log.>

But does your maintenance routine include a transaction log backup? Backing up the...

<Then, I ran the program and I got a new error "Run-time error '424'       Object required".  I do not know where to put that statement in my program to meet the "timing" you...

Can you post your error message?

Which version of SQL Server/OS are we talking about?

A couple of links:

http://www.nsa.gov/snac/db/mssql_2k.pdf  (Page 15)

I don't know if all of these are REQUIRED, though...

From this...

You mention an Access database? The example is written to access a SQL Server database.

Which changes have you made to the strconn variable?

Leif

Privet! (?)

If your production server has sufficient space, why not make sure that SQL Server creates a large tempdatabase when the service starts, making the various autogrowth less relevant?

At...