You may want to consider using the code above with an update statement to fix the data in the table.

Try this:

use master;

go

select

db.[name] as 'Database Name'

,db.crdate

,(((CAST(af. as DECIMAL(18,4)) * 8192) /1024) /1024) as 'File Size (MB)'

from sys.sysdatabases db

inner join sys.sysaltfiles af

on db.dbid = af.dbid

where [fileid] in (1) and db.crdate <...

Since it is a QA box why don't you set the recovery model to simple and back it up nightly. We only backup the system databases on our QA...

I have found that the system tables do not allow you to right click and select Open Table. You have to issue a select command:

SELECT * FROM sysjobs

You may want to consider hiring a DBA to come in and fix your issues or at least advise you before you do anything. You can study up on...

Are users entering data into the destination database? If so are they using the same PK (eg. identity column)?

This is a concept but could you load the sting into a temp table using your function. Create the temp table with an identity column called sortid

create table #test1...

We use VMWare for Production, Dev and QA.

You need to find the application or user that is connecting and stop that application or service. You should be able to connect at that point.

You could get luck...

Try dropping the problem article and then readding it.

This may be caused by DTC not being configured for network access. This fixed the issue for me.

http://support.microsoft.com/kb/817064

We have many instances and I have found the following issues:

1. It does use more system resources than one instance: you have two sets of system databases including tempdb and...

You could cast the fields to int (not sure if there is a more efficient way):

from table1 a inner join table2 b on

cast(a.order_no as int) = cast(b.order_no as int)

I have found that Windows Firewall can cause this issue. Check to see if that server has the firewall configured correctly.

This may not be the answer you are looking for but one solution is to perform log backups more frequently.