I love the ability to telecommute. Like others I have about an hour commute depending on traffic. Living in the Northeast we have many days of bad weather...

SQL 2005 provides the following output:

What you see...

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

print 1

-- Comment one

print 2

-- Comment two

print 3

-- Comment three

print 4

is not what you get!

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

1

2

3

4

Need to correct your answer.

Very poor question... when it is proper to try an trick someone to test their knowledge? If you are going to test, then make the correct answer part of...

Blocking is a natural process in databases. As more and more request for information (queries) and more DML activities are generated you will see more blocking locks. Most...

One thing you might try is using Network Monitor to capture the logon process. Since most of the time these are not encrypted, you could capture the network traffic...

I recently started doing some Lapidary Arts work. I was on vacation a couple of years ago in South and North Carolina and one of our camping neighbors was...

Yes it is the same account with Domain Admin and SQL Admin rights.

Also, it is now working as it should be. Don't know what changed but...

Ping will not accomplish what I need as the web page must process the request that will be part of the website url.

What I want to do is:

declare @startime datetime

declare...

There is no client app in this case, well there is but I don't have control over it, hence the desire to do this from SQL. It will be...

Looking at SQL Logs I found this:

2010-04-07 23:45:12.29 spid29s Database mirroring connection error 4 'An error occurred while receiving data: '64(The specified network name is...

Start with restore with NO RECOVERY. If you are going to mirror the mirror database must be in no recovery mode.

You can query the sys.dm_os_performance_counters for object name = SQLServer:Memory Manager.

It will give you Total Server Memory that SQL is using and Target Server Memory.

If I remember correctly, I had the same issue upgrading from 2000 to 2005. I updated the stats and rebuild my indexes.

I could have sworn I restarted the Agent several times. But I must have missed that step.

Thanks all is well in SQL Land.

Log will truncate after each backup. Granted the space will not be returned unless you shrink it, but given that there does not appear to be a lot of...