Viewing 15 posts - 916 through 930 (of 1,097 total)
Maybe the coude inside the Job fails. You should check that first. Or list an example of the code here.
February 17, 2003 at 6:09 am
No, can you create an alert?. Maybe you should restore all the system tables to return to the other service pack
February 14, 2003 at 1:10 pm
There is no other way unless you write to a temp, drop and re create the table with the desire columns order and then re insert from the temp.
But, if...
February 13, 2003 at 12:39 pm
Pad index is related with the fill factor. Basically, the fill factor option leaves the percentage you specified free in the leaf pages of an index. The bigger the fill...
February 13, 2003 at 11:25 am
you could try first DBCC INDEXDEFRAG to avoid locking.
February 13, 2003 at 9:21 am
February 12, 2003 at 11:11 am
By default sp_help_revlogin is not created. Check http://support.microsoft.com/default.aspx?scid=kb;en-us;246133 for the sp.
February 12, 2003 at 10:54 am
From your local server, create a linked server to the remote and try to execute a query like
select * from remoteserver.master.dbo.sysdatabases,
and tell if you could do it or not.
...
February 12, 2003 at 9:30 am
If you can run the dts manually from EM and it works fine and from an schedule Job you can't, then It must be a problem with the SQL server...
February 12, 2003 at 9:02 am
I run a trace will modifying a procedure, but I coudn't find a modified date. I don't think it exists. Only the creation date appears in sysobjects
February 12, 2003 at 8:46 am
To enable SQL autentication in your replication, you should especified in the distribution agent job this parameters:
-DistributorSecurityMode 0
-DistributorLogin sa
-DistributorPassword pass
-SubscriberSecurityMode 0
-SubscriberLogin sa
-SubscriberPassword pass
Check to see in all servers the same...
February 12, 2003 at 6:41 am
Are you using replication stored procedures, those like sp_MSupd_TableName? We have also transactional replication and we have trigger on both the publisher and subscribers.
February 12, 2003 at 6:36 am
I'm using transactional replication but I guess the snapshot agent should work in the same way. If you want to compress the snapshot you must generate the snapshot in an...
February 12, 2003 at 6:23 am
To be sure that your sp is blocked, while you are running the stored procedure, execute on Query Analizar the t-sql command exec sp_who2. Si sp, tells you all the...
February 11, 2003 at 2:24 pm
Viewing 15 posts - 916 through 930 (of 1,097 total)