your welcome,

maybe in this case your next step is to create a check constraint?

like

ALTER TABLE [dbo].[Table_1] WITH NOCHECK ADD CONSTRAINT [CK_Table_1_T1_2] CHECK NOT FOR REPLICATION (([T1] like...

timotech (4/14/2010)

---

Hi Luzi, thanks for your replies, i tried what u said, but i think the problem is comming from the table, because i checked the field for invalid data...

and dont forget to copy the users bevor you copy the database because of orphaned users in the userdatabase.

Hi,

try this:

drop the constraint first

ALTER TABLE [dbo].[Table_1] DROP CONSTRAINT [DF_Table_1_T1]

then convert and add teh constraint again

timotech (4/14/2010)

---

ALTER TABLE myPoorlyDesignedTable ADD CONSTRAINT

DF_Table_1_Upper DEFAULT N'19000101 00:00:00' FOR Upper

Hi Luci, i don't understand the DF_Table_1_Upper,

should i do this:

ALTER TABLE tbl_TVRates ADD CONSTRAINT

DF_tbl_TVRates_1_Upper_Time DEFAULT N'19000101 00:00:00' FOR Upper_Time

because my...

the data fits not in the column. so you have to increase the size of the filed to at least 17 characters

e.g nvarchar(17) bevor the update

and maybe set a default value and not null for the column 😉

ALTER TABLE myPoorlyDesignedTable ADD CONSTRAINT

DF_Table_1_Upper DEFAULT N'19000101 00:00:00' FOR Upper

If the Script above does not work, you have to check the Upper and Lower fields for invalid data.

e.g. empty (null) or not valid time data

what is exactly the problem?

the subselect?

hi,

it's also nice to have the datafiles on the same place when you have to do a restore 😉

you know what i mean if you setup your mirror database the...

Hi,

easiest way would be to define a client alias.

http://msdn.microsoft.com/en-us/library/ms190445.aspx

regards

your sql server browser is runing and your TCP potocoll enabled?

strange thing.

im out of ideas..

still not working? sad to hear 🙁

maybe you have to check for patches etc?

Just to have a closer picture:

your server are in the same domain?

you have the latest...

Hi,

I think you created the endpoints with the wizzard.

We had the same problem. The names resolution was not the same on the Server. While local it works without domain sufix,...

don't forget to set up a transactionlog backup job when switching to FULL Recovery

else you have a growing transactionlog