Viewing 15 posts - 601 through 615 (of 1,098 total)
To execute write:
EXEC sp_Helptext view_name from Query Analizer. But this won't show you the relations like the diagram does. If will only show you the tsql code used to create...
May 9, 2003 at 1:29 pm
Check with the network admin to see if the password that the sqlagent login uses expired
or was changed.
May 9, 2003 at 1:19 pm
Can you also post the error you recieve?
Why don't try to execute manually the result of the SELECT @strSqlTransExe and see if it inserts right? If it doesn't, also post...
May 9, 2003 at 12:52 pm
Does the @sqlVals variable has multiple values to insert?
Can you post the result of
SELECT @strSqlTransExe ?
May 9, 2003 at 11:37 am
or you could create a cursor with all the tables names from sysobjects, and execute the delete. But you should specify all the delete criterias for every table you want...
May 9, 2003 at 11:28 am
Why not try Transactional replication with republishing topology..
May 9, 2003 at 11:23 am
There is now way you can check that if you haven't implemented before a way to save when a user last connected.
You can search you db to see if the...
May 8, 2003 at 2:42 pm
You do have sysadmin permissions?
Try creating the publication with the stored procedures.
May 8, 2003 at 2:32 pm
Also to run updates faster and with better performance, if you are running SQL with SP3, you should consider using the sp_scriptdynamicupdproc, to create and use the replication sps at...
May 8, 2003 at 2:28 pm
Any info messages from the log error of the instalation?
May 8, 2003 at 2:13 pm
You should remove all the subscribers, then drop the publication, and then erase the distributor.
I recommend using stored procedures.
May 5, 2003 at 3:26 pm
To really know when it is really necesary to rebuild my indexes I create a
script that checks the result for dbcc showcontig command, read the Scan Density
value,...
May 5, 2003 at 11:10 am
Are you attaching the db files to a db with the same name that it had before?
May 5, 2003 at 11:06 am
Are you doing your backups to a remote server? It seems that
something happend in the network while executing the backups
May 2, 2003 at 2:21 pm
Viewing 15 posts - 601 through 615 (of 1,098 total)