To re-map orphaned users to logins you have to run sp_change_users_login from each database or you can run this script http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=12615  in master database and run it once from there.

select

tbl=t.name,

col=c.name

from sys.tables t join sys.columns c

on t.object_id = c.object_id

join sys.types p on c.System_type_id = p.System_type_id

where p.name ='xml'

You are probably talking about database mirroring ? First , they cannot mirror each other. Only one server can be principal, while another is a mirror.

Answering to your question,...

SMO - SQL Server Management Objects

The easiest way is to run upggrade in place - just upgrade your instance to 2005 and it will automatically upgrade your databases.

But more reliable way is to run upgrade...

And the list can go on...

1. Now all the processes will compete between each other for server resorces.

2. Backup will much longer.

3. If you need to restore it, all the...

Yes, this sounds like workaround, but designers of this site should provide  an ability for users to navigate through the site without doing any additional manipulations of this sort.

This is on THIS site http://www.sqlservercentral.com

I recommend to use varchar(8) or char(5) to hold just time, because storing it along with some dummy date would be really misleading.

Sounds really strange. With what method did you collect fragmentation data : sys.dm_db_index_physical_stats or DBCC ShowContig ? What I can suggest is if you used one of these methods then...

Thanks Sreejith, now I have some clue about this, but not a solution yet. I compared sysservers tables on my servers and found that those servers which return @@servername have...

I tried it but got a message:

Msg 15028, Level 16, State 1, Procedure sp_MSaddserver_internal, Line 89

The server 'server_name_here' already exists.

But @@servername still returns Null

Do you mean autoincrement ? If so, here it is:

create table my_table

(

field_with_autonumber int identity(1,1)

other_fields int

)

I recommend Pro SQL Server 2005, author Thomas Rizzo, Apress. It's for DBAs and developers who already have experience with SQL Server 2000. It does not teach you SQL or...

Hi Yelena,

I can also create diagrams under a login with just db_datareader role membership, but what I want is to be able to view the diagrams that have been created...