Error 112 can indicate insufficient disk space - do you have enough disk space when the plan is run?

Piotr

It doesn't, but it's convenient. If you declare too short string your query will be truncated at execution time.

declare @sql nvarchar(max)

set @sql = 'select * from...

Hm.. don't have too much time now, but this seems to work - you have to prefix your search string with N. Here's sample code:

--default collation is SQL_Latin1_General_CP1_CI_AS

create table testtable

(

col...

This is how you end up when you don't use canonical date format (120) 🙂

Check this out:

DECLARE @StartDate DateTime

Declare @EndDate Datetime

Set @StartDate ='11/01/2007' --11th of Jan or 1st of Nov?

Set...

In short, you can't keep related tables in partitions as you will not be able to switch them in or out of the partition because of violation of FK constraints....

Does this server have to be created each time you execute the procedure? Perhaps you could create it once, and then the password is not dicplayed.

Piotr

Probably,

In the end it does the same thing 🙂

Piotr

Wouldn't it be easier to modify the triggers? They seem to smell from what you are saying.

Piotr

Interesting. I get the same result on my SQL 2008CTP. Database compatibility level doesn't make change. You can create such column as long as it is not persisted. I suspect...

Since they are calculated only when a column (your varbinary) changes, there should be no performance hit when you read them. There's an article by Andy Warren about them:

Well in this case instead of trigger is better. If performance is not that important, you can create a view instead of persisting this column and make that external application...

May I ask, why do you update a column in a table in the insert trigger? Maybe another approach could be possible?

Piotr

Are you saying that update trigger is fired when you insert a row to database? Do you call update on this table within insert trigger?

Piotr

You have to change collation on database AND on existing columns.

So alter database and set of alter table alter column statements is the way to go.

Regards,

Piotr

Try to restore database so its files are not located in Program Files folder. I usually create folder databases in root of my C:\ drive so I don't have to...