Check this article from Microsoft:

http://support.microsoft.com/kb/224071

Just add GROUP BY to Sandy's query:

SELECT t.id, t.date,

MAX((CASE id_plan WHEN 'A' THEN 'Y' ELSE 'N' END)) AS A ,

MAX((CASE id_plan WHEN 'B' THEN 'Y' ELSE 'N' END)) AS...

Similar to Mike's:

select count(*) from (

select WorkOrder from #TestTable group by WorkOrder having count(distinct JobNumber)=1

) as [single_ep]

union all...

For performance, it again depends on business requirements. For example, if there is a request to find all of your customers who live at the same household then design 1 will...

I'd check the business rules/requirements to find out if Address is an entity by itself. For example, if you want to do mass mail to your customers and you have several...

So, to sum up troubleshooting you've done so far:

- Login with your domain account using Windows Authentication fails.

- Login with another domain account using Windows Authentication works.

- The default database...

Can you post the entire error message? Also, is it a SQL login or Windows login?

One correction to bledu's suggestion:

select txns.*, last_name as last_Name_from,

last_name as last_Name_to,

first_name as

I think you can just change default database to master for your login and be able to log in.

Works fine for me. I'd suggest to first install SQL 2000 tools and apply SP4 and then go ahead with SQL 2005.

I guess you are trying to do this:

update metadata.dbo.tabledetail set endtime = getdate()

where

metadata.dbo.tabledetail.PutYourFieldNameHere = 'pdsadmin.person'

That's ok. Things happen even to the best of us!

Gina,

If you're using SAN then make sure that your HBA drivers are up to date.

First of all check if you can connect to the virtual server using SQL tools. If you have SQL client tools installed on the IIS box launch Query Analyzer and...

In addition to hoo-t...

If .mdf and .ldf files named consistently you can try to write a script to execute xp_cmdshell with 'dir /B yourpath\*.*' and insert results into a temporary table...