Had this problem during the Beta. You have a service which is running on the server leaving a connection to SQL Server open. Once you stop that service / close...

I actually think that is an overestimate. I haven't done an upgrade in a while (tomorrow I will be) but when I have, it doesn't seem to have taken that...

Check out MS TechNet Article 298801 or go to http://support.microsoft.com/default.aspx?scid=kb;en-us;298801

Hope this helps.

David

My experiences have been similar to yours, all good. I have not had to call but a couple of times and the support they provided was excellent. In one of...

A solution might look something like what is given below. Not knowing your data makes it pretty hard to be sure if this is correct but from some test data...

Check out MS Article 304261 or use the link below.

http://support.microsoft.com/default.aspx?scid=kb;en-us;304261

Hope this helps.

David

My suggestion - Pick two areas that are going to be the focus for giveaways each month. From those two areas pick the BEST post and award the prize to...

Sorry, didn't read fully. You will first need to know the difference between your time and Greenwich Mean Time. EST is -5. Once you have that you can compare using...

It appears that all the date functions are referencing what the server setting is for Time Zone.

Hope this helps.

David

Andy - Good article on a topic most people don't think is important.

I have to agree with steven_white40 "If the users have access to multiple databases on the same...

raino -- I would be interested in hearing about the performance issues on the SAN solution. We are in the process of migrating to an EMC SAN and I would...

I hate tooting my own horn but I have a script posted here that does just what is being described that works great for me. Hope it helps here as...

Something like this should work....

select

count(distinct(a.SSN))

from SSCWork4 a

where

StatusID = 50

and ID > (

select max(b.ID)

from SSCWork4 b

where

StatusID = 40

and b.SSN = a.SSN)

Hope this helps.

David

We use the Dynamic Properties Task within DTS to point the "Text File Source" connection to the filename we are looking for. Our situation allows for this as we have...

1) Download software that would probably save me a ton of time but I never have time to test or justify to managment.

2) Surf - www (specifically http://www.sqlservercentral.com)

3)...