I belive there's also 'continue' and 'querystate'.

An alternative might be xp_cmdshell combined with the (documented) sql "scm" command prompt utility.

...although the undocumented stuff is always more interesting.

Cheers,

-...

Rather than using the drop down list, can you try typing in the same parameters and credentials that the server is registered under in Enterprise Manager?

Cheers,

- Mark

Sorry, it was an incorrect assumption on my part. I thought you were trying to import to a SQL 7 server from some other (possibly non SQL 7) server.

So,...

One way, from command prompt....

net start | find "MSSQL"

Cheers,

- Mark

What version is the source database?

Cheers,

- Mark

I don't think there's any difference. SUSER_SNAME() can be used instead. However, SYSTEM_USER is the more accepted, and might even be something that will work across other database...

Do you have a clustered index? I may be wrong (and often am), but "index ID: 0" suggests a heap, in which case Extent Scan Fragmentation is not relevant.

If...

Obviously too late now.... but I often put some sort of logging in really long transactions or stored procs. Logging can be either to the sql error log (raiserror...

quote:

---

cholliet:

The answers where just a bunch of numbers

---

And English is Brian's 2nd language?

Cheers,

- Mark

The backup will do nothing, otherwise transactional integrity will be compromised. You've got to either kill the transaction or increase the log maximum and wait it out.

Cheers,

- Mark

Maybe we should sack the clown who put 16gb in the box?

Cheers,

- Mark

Oooooh.

Is there any way of NOT using the sa password for the application? Or, is this one of those 3rd party apps where you're given...

Stop. Desist. No! please, please don't.

I've seen too many similar designs (including those by me) that have been created with the same good intentions. ...

Martin,

There's no array type structure in SQL. It sort of violates relational concepts.

If I were you I'd resign myself to to the slightly more difficult task of creating child...

One would expect a more reponsible approach to QOD from you Frank.

As an experienced DBA you must try to follow standard procedure in your morning activities:

1. coffee

2. another coffee

3. QOD