You have not really explained what is wrong.

SQL Server does not return ambiguous results unless you mean that

SELECT * from MyTable

doesn't return the same results in the same order. It...

Have someone outside the DBA group, maybe in finance or accounting, look through the logs. Show them how to query, how to search, let them examine traces.

Have the traces written...

Not to be a conspiracy theorist, but I think the NBA refs are good, but in a horrible spot. I'm amazed how often on replays I see what they called,...

Please check the SQL Server error log for some explanation of why it's suspect.

Thanks, it was published accidentally when it should have been scheduled. The date is correct.

Cost isn't necessarily an issue. If you install Standard edition (or workgroup) twice on a server, you need two licenses. You don't get unlimited licenses in 2005. You do in...

I watch football - http://eteamz.active.com/Bruins/sounds/TVTheme-ABC,NFL-AreYouReadyForSomeFootball.wav

Use your hands, use your body, hit somebody!

Have you checked to ensure remote connections are allowed?

There must be a setting to not use named pipes and use TCP/IP

Have you tried building an SSIS package using the SS2K8...

Steve Eckhart (5/22/2009)

---

Steve,

I find it very sad that your description of Memorial Day, "something that celebrates the start of warm weather and time off," is all that Memorial Day means...

Tom Brown (5/22/2009)

---

Over the Spring Bank Holiday (Whatever happned to calling it Whitsun) I'll be out on my bike, getting muddy - probably over at Cannock Chase - but possiby...

Sure, Lynn watches his ten year old pros every Saturday 😛

truncate will remove all data AND reset the identity to it's starting value, whatever that was. It doesn't have to be 1.

DBCC RESEED will reset it to the value you...

Let me know, it will be worth the $10 to see how Grant meets his end!

You still will likely need to edit the startup parameters for the service. You can do that in the services applet. Configuration Manager also allows this on the advanced tab...

A salute from me as well.

Sadly, I tried to join the Navy, 4H (bad ear) and too young (and prideful) to accept being turned down by the submariners.