Without data, it just sounds like you want to change the ordering the data shows up... look at this example:

DECLARE @T AS TABLE (Col1 int, Col2 varchar(255), Col3 int)

INSERT INTO...

Database Expiry date is not for deleting old backups; it indicates when the file can be overwritten. But since you are using the maintenance plans the file name will...

The user in question is mapped to dbo, if you don't want the user to have DBO. Change the database properties, change owner to sa. Then you should...

I am not understanding what you are asking? If you are thinking of mapping the SA account I wouldn't advice it; because that is a huge security risk. ...

sp_change_users_login is a stored procedure that remaps the SID (SQL LOgins only)

So Server A:

You have a Username JoeSmith with ID12 ...

when you move it to Server B..

ID12 is JohnAnderson but...

I have some other people trying this I am not sure how well it works ...

1) Create SQL Server logins on both servers with same name.

2) Create job on that...

francis (3/28/2009)

---

First, thanks to all. I am concentrating on the mirroring database. I have two databases (where there are more databases but only two are my targets) which I...

Heh, that was my attempt to do it without using CROSS APPLY; for databases running in 80 compatibility mode. Which failed horribly, only solution I found was to do...

Hi,

You can't see anything in your drive C? Or your structure looks different then what you expect when you go backup? Is...

Please don't double post, replies here.

francis (3/27/2009)

---

I have a question which may be dumb. Please be patient. I understand that the database mirroring is for user database only!? How could I ensure the...

Double post, replies here.

Agree here I have learned a lot reading posts here; another good part of this form is just not the answers the questions.

You'll run into questions that you haven't thought...

In SQL Server failover configuration in two nodes (Active-Passive) it is only one SQL Server even though you are using two computers. So when changing passwords on the SQL...

Thanks for sharing :).

Thanks.

Mohit.