Please look at this article on how to post data to get the best help. The more effort you put into forming a question, the more people will be willing...

I am not sure but it looks like the behavior of the newer version is correct. In the 9.0.3310 by rounding up the value, it changes the data which...

Works great! Exactly what I was looking for. Thanks.

the table in question can only have three possible values in the type column. These values are status, date, and time. And I an trying to get the old value...

Hey JT, are you sure you are getting the correct results. In my testing it appears DATABASEPROPERTYEX([NAME], 'Status') only returns data from local server not the remote linked server.

Is there anything else that is running at the same time as this update?

Which special characters are you looking for? Please read following link and post sample tables and data.

http://www.sqlservercentral.com/articles/Best+Practices/61537/ [/url]

Look in sys.databases. create_date is in this system view.

I do believe you answered your own question. The error states that only sysadmin can specify parameter but the developer having the issue is not in sysadmin role.

I am currently doing something similar but getting more then just collation and I have achieved by:

- Choosing one server...

Thanks for suggestion, I have added lines (editted code in original post,changes in bold) that get database name out of the header and apply that to the database being restored....

I would see why you couldn't. As long as you are only reading from the database anything should work.

I assume the "Portal software" you refer to has a persistent connection to the read-only database which would make it in use all the time. Thus, If you don't disconnect...

You can user CTE(http://msdn.microsoft.com/en-us/library/ms190766(SQL.90).aspx) instead of temp tables.

with installed as(SELECT DISTINCT Computername

FROM dbo.tblSoftware

WHERE tblSoftware.softwareName = 'App1'),

updates as(SELECT DISTINCT Computername

FROM dbo.tblRegistry

WHERE Regkey = 'Regkey1'

OR Regkey = 'Regkey2')

SELECT DISTINCT Computername

FROM installed

WHERE NOT...

Ok, when you connect to the share on the primary server from the secondary, Do you have to supply a username/password of a user on the primary domain? If so,...