Kenneth,

Thanks for correcting me. It was a slip of the mind . But Chris is correct, my main point is that usually TCP...

I'm not sure this answers your question, but if I understand you correctly....

at the bottom of the Active Topics page, there is something like this:

Showing page 1 of 12 -...

Check out the BOL, use the Index tab and enter DBCC SHRINKDATABASE. Select the Transact-SQL option and scroll down to Remarks. Find the paragraph that starts with "Because a log...

Is there a firewall involved? Some firewall teams turn off TCP Port 1433 as the SLAMMER worm uses that port (it's the default for SQL Server). You could still PING...

What makes the Transaction Log (TL) backups really 'cool' is that if you do:

FULL BU

TL BU

TL BU

FULL BU

TL BU

and your second FULL BU is corrupt, whatever all is not lost....

HAS_DBACCESS is in the SQL Server 2000 BOL.

-SQLBill

There's a lot of undocumented stored procedures and DBCC commands. But what I found interesting about the QOD is that NONE of the answers met the question:

-------------------

What T-SQL could you...

In the BOL, use the Index tab and enter BACKUP DATABASE. That will not only give information about backing up the database but also about backing up the log.

Basically, you...

How do I log off? I clicked on LOGOUT, got the main page, clicked on LOGOUT on the menu bar, clicked on LOGOUT on the menu bar, clicked on....

FINALLY, I...

On the QOD forum, there is the list of threads. To the left of the thread title there are two columns. One has an envelope the other is usually empty....

There were some duplicates in the list, especially around item 54. But it was still funny.

-SQLBill

Andy,

About the stuff running off the side. The login page is good. The list of forums is also good. But when I click on any forum and go to the...

What a riot!!!!!!!!! I'm sending this list to my SysAdmin. He'll get a big kick out of it.

-SQLBill

It wasn't a waste of time....sometimes the little things are just overlooked. I know I've had it happen to me.

-SQLBill

When is the obvious not obvious? When someone else has to...

What error are you getting?

In your example, is the @varUser_Name a typo?

You have BRAIN, shouldn't it be BRIAN?

-SQLBill