Viewing 15 posts - 361 through 375 (of 387 total)
is the server registration in enterprise manager local, if so change to server name. Also it is best to terminal into the server where the sql instance is that you...
May 24, 2005 at 2:35 pm
search this site for usp_killusers sp, this will do what you need
May 24, 2005 at 9:05 am
Have a look at this http://msdn.microsoft.com/SQL/default.aspx?pull=/library/en-us/dnsqlpro04/html/sp04j1.asp should give you some ideas
May 18, 2005 at 11:08 am
Run profiler against the server and see what dbcc is being issued by em, maybe the sql is different than what you are using. If so use the sql em...
May 16, 2005 at 9:20 am
The union you are doing is effectively doing a group by, getting rid of dupes. If there are not any dupes try and use union all.
May 13, 2005 at 10:10 am
use this sql (pulled from this site)
SET NOCOUNT ON
SELECT DISTINCT USER_NAME(o.uid) + '.' + OBJECT_NAME(c.id) AS 'Object name',
CASE
WHEN OBJECTPROPERTY(c.id, 'IsReplProc') = 1
THEN 'Replication stored procedure'
WHEN OBJECTPROPERTY(c.id, 'IsExtendedProc') = 1...
May 12, 2005 at 9:00 am
What you may want to do is bcp/dts all the data out of the tables/articles on the publisher and when setting up the replication click the option that the subscriber...
May 10, 2005 at 9:36 am
I would assume that the distribution agent has passed an update/delete statement to subscriber and the row is not there. Maybe it has been deleted outside of replication.
May 6, 2005 at 10:26 am
search this site for usp_killusers stored procedure and install it in master, run this in QA before the restore statement and all should go fine.
April 26, 2005 at 12:36 pm
the type of index that you are seeing is a seodo index created by the indextuning wizard, andthese should be deleted as part of the index tuning wizard process. I...
April 22, 2005 at 3:27 pm
One of the reasons em takes so long on any large table alteration is that it inserts all records into temp table and inserts back after the change (pretty much recreates...
April 21, 2005 at 12:48 pm
I would try and attach the files on another server, I believe it should work and no data should be corrupted., do a dbcc checkdb after the attach. Make a backup...
April 17, 2005 at 9:48 am
try this:
INSERT INTO MyProductionTable
SELECT Value_Feilds FROM StagingTable
WHERE StagingTable.id not in (select id from MyProductionTable)
March 29, 2005 at 11:09 am
Viewing 15 posts - 361 through 375 (of 387 total)