Unfortunately you can not create a synonym for a database, a schema yes, but not the database itself.

It had to be unsafe because of the System.Windows.Forms and we can't do the conversion outside of SQL Server.

Yesterday I spent the day writing our own RTFtoText utility in...

We are migrating data from an Informix database and in it there is RTF text. We are using SSIS to move the data to SQL Server staging database. Then we...

I have a sql script which does the following. That's all you need. Let me know if this helps

USE [DMZ]

GO

--set the database trustworthy

ALTER DATABASE DMZ SET TRUSTWORTHY ON

GO

--if the clr...

I had a similar problem because I was using a RichTextBox within my code. In order to resolve my problem I did the following;

USE [DBNAME]

GO

--set the database trustworthy

ALTER DATABASE DBNAME...

Problem was solved by installing SQL Server SP1 on the one system. The was the difference between the working systems.

I'm logged into the system as an administrator. The account I'm logged into SSMS as is a sysadmin account. And I went to the server where the files exist and...

Correct. These 3 run in parallel. And all of these tasks have maximumerrorcount set to 0. When I run it from VS IDE everything run's fine. I get green for...

Thanks for all the suggestions. I found the problem. I though it was this code I put in but it was code already in the SPL up higher in the...

I changed the cache from FULL to partial and that resolved it.

Can anyone explain this?

I figured out how to do this. But now all my data is going to the error output.

I'm only doing 10 rows as a test and I looked at my...

The only thing in common between this person and patient table is the PersonUid

The externalID and medicalRecordnumber are in the patient table

The name, ssn, addressGuid, Genderguid, MaritialStausGuid are all in...