Is there a thread connected using DAC somehow.?

also is related to one Database or the SQL Server itself.

Also check to see the database is not set to SINGLE_USER or RESTRICTED_USER...

Try this:

http://www.visualbasicscript.com/m_36187/tm.htm

Just a hint:

Do you pass parameters using SQL Agent to a SSIS PAckage or SSRS.

Do you want to track the users or validate the service account for SQL?

if it is the user, use can use the Server Side Trace File if it is...

I have heard of using diff TCP Port for SQL server instances.. but not using diff IP's. Maybe i should learn more. Let us know what you find out for...

check this out:

http://www.sqldbatips.com/showarticle.asp?ID=27

if you are using select then a T-sql will be sufficient.

select upper(column_name) from information_schema.columns

where table_name= "your tale name"

renaming the physical name with sp_rename check books online

EG:

sp_rename @objname='DBInfoMax_2.ServerName',@newname='SERVERNAME',@objType='COLUMN'

Where DBInfoMax_2 is...

You will have to re-design your packages in 2005 SSIS and that is the only way out.

We have been doing this dince past year and it is purely Re-WorK..

Again...

I think SQL agent is not inclued in Express Edition, so you cannot create maintenance plans and schedules.

you will have to use SQL Scripts to create backups and use windows...

I would recommend a Backup and Restore of the databases or Detach and Attach of the DB's.

And nothing much depriatiated from SQL 2005 so you should be good to go.

right click Database->tasks->shrink->files or

USE [WSS_Content]

GO

DBCC SHRINKFILE (N'WSS_Content_log' , 0, TRUNCATEONLY)

GO

DBCC SHRINKFILE (N'WSS_Content' , 0, TRUNCATEONLY)

GO

first try this and let us know if it works:(replace the files names with your...

your command should work but before starting the install:

some more info:

http://www.mssqltips.com/tip.asp?tip=1528

I personally think the answer is: controlling your transaction log files and in turn the trans backps..

What are the SQL Server Service accounts (local or domain accounts)

Are the DB compatibility modes same for both the databases.

What is the service pack levels and SQL server Editions:

What i...

you could have applied the trransaction log (with NORECOVERY) to the mirrored instance to catch up with the principal and it should have solved your issues.

http://technet.microsoft.com/en-us/library/cc917680.aspx