Are you using SQL or Windows authentication to connect database from other client? Is this in production.

I don't think you will have any problems with logins, Just be on safe side script our the logins and users. All AD accounts will be changed at windows level...

Not recommended at all, However depends on requirements.

asir83 (3/10/2010)

---

Thanks for the prompt reply.

If that is the case, then what about the information of the user DB of 2000 that will be moved to 2005? Master DB...

asir83 (3/10/2010)

---

Hi,

I need to move my master DB which is currently residing on SQL 2000 instance, I am performing a side by side upgrade, I know that the user DBases...

As Adam said don't create too many AD groups like Data Reader\ writer etc in AD, keep it simple

SQL Service account Group for SQL Services

SQL server Agent Group for...

subbarayudu.net 37258 (3/10/2010)

---

Hi Every Body,

I take copy-only backup in one of the my Data base. Sparse file is increasing very fast. I don't know what is the resion please help...

May be due to XPs and distributed queries, as you are on SQL 2008 64 bit, G switch settings will not help, I would say call Microsoft support rather than...

Create index, Use DTA to check which index will improve performance.

Check if any other process are running.

http://www.sqlservercentral.com/Forums/Topic157874-24-1.aspx

Because even if you don't use complete space for particular data types it will allocate and reserve the maximum size, you will be wasting resources.

Jason,

Are you sure DBCC shrinkfile will shrink below initial size of the mdf or ldf file size?

Then create new database with small initial size, and restore the database, then shrink the new database it should work. I don't remember on top of my head what we...

Is this in production?

It won't ask password if you are logging in as windows authentication it will inherit the windows account password from OS, change to Sql Server authentication mode to login as...