Viewing 15 posts - 736 through 750 (of 1,065 total)
In merge replication the best practice is creating PK which are unique to each replication partner
I agree in principal, but that will allow duplicates in the underlying business key (e.g....
July 31, 2008 at 5:13 am
Have a look at the system stored procedure sp_setnetname.
This should do what you want.
July 31, 2008 at 4:14 am
You've already posted this same question in another thread, please don't cross post!
http://www.sqlservercentral.com/Forums/Topic534176-359-1.aspx
You need to check for the existence of the schema, and then execute the create statement dynamically...
declare @query...
July 31, 2008 at 3:19 am
A couple of points:-
Your new trigger still doesn't allow for the case where an individual statement inserts/updates more than one row in a single statement.
A trigger fires once for each...
July 30, 2008 at 7:46 am
I had this same issue a few years ago, and eventually traced it to the fact that the 2 boxes had different amounts of memory, which for some reason caused...
July 30, 2008 at 3:29 am
As you got the copy from a backup, you won't need to do anything else... the tables, data, stored procedures, UDFs etc etc all get restored.
Are you sure the stored...
July 29, 2008 at 3:50 am
How did you take the copy of the database?
If you've done a backup/restore or copied the MDF/LDF files, then all the stored procedures will be in the copied database already....
July 29, 2008 at 3:26 am
There can only ever be one copy of MSDTC running on a cluster, regardless of the number of nodes in the cluster.
Not sure of the reason why, but under the...
July 29, 2008 at 2:04 am
Cannot create trigger on 'test2.dbo.names' as the target is not in the current database.
You need to be in the context of your test2 database when you execute the create trigger...
July 28, 2008 at 5:00 am
Depending on the error, the mail procedure may not be able to set it's return code, so I'd be inclined to check @@Error, as well as the return code:-
IF @return_value...
July 18, 2008 at 4:32 am
Without knowing more about your data, I'm guessing its because you are doing the update in 2 statements, and that if you update both at the same time, you won't...
July 17, 2008 at 8:42 am
The answer is... it depends.
You are absolutely correct in saying that what you're trying to do with a lower fill factor is avoid page splits.
The reason why the answer...
July 17, 2008 at 6:57 am
Do those performance hits affect you the same regardless of column order in the Insert statement?
The column order in the insert statement makes absolutely no difference to those performance hits....
July 17, 2008 at 5:38 am
It won't make any difference to how the data is actually stored in the database, so there will be no performance difference.
July 17, 2008 at 5:00 am
Viewing 15 posts - 736 through 750 (of 1,065 total)