How do I get the administrator account back on the server? Seems like I transferred the administrator account . I dont see it to login.

I using win xp professional.

Thanks in...

How do I convert this data to unicode?

I am using column separator as $.

Salary income $ 656.00

Total Cash income $ 656.00

Taxable income for the pay period $ 656.00

Pensionable earnings for...

What is normally lost in a hard disk failure ?

thanks

I asked similar question some time ago about an instance and server . I got an answer saying they are different. An instance can be understood as a blue...

When I tried to run select * from [WINSER2003-I].secls.dbo.employee

I get this error

Invalid object name 'secls.dbo.employee'.

An instance and a sql server are not the same though.

I was looking options in sql server 2008 such as sys.dm_os_memory_objects ( primarily used to analyze memory use and to identify possible memory leaks)

How do I do auditing with the...

Can you explain ';with cte as '

is cte an array here?

Thanks

the quotename select stmt does not work

thank you. that makes sense.

How does four quotes make one quote while execution in this sql stmt after name?

select +'sp_help '''+ name +'''' from sys.tables

Yes I wanted to do sp_help 'tablename'.

Thanks for the replies.

Thanks that fixed the problem.

Thanks for all your responses.