DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_moviecats_cats'. With trans repl and DRI enabled, I get the above error once and...
I have created a full text index on a varchar(200) col of my 'movies' table. The table has about 2000 rows, so there is lots to index. But even...
I've used the sp_'s from this article: HOW TO: Transfer Logins and Passwords Between Instances of SQL Server...
One of my users created a table named 'dtproperties' of type system and now I can't delete it, when I try as 'dbo' it says: 'you tried to delete one...
1 Way trans. replication to a mysql database SQL Server Env: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Windows NT 5.0 (Build 2195: Service...
MSSQL 2000 sp3a -- to a remote--> mysql 4.0.20-standard The ports are open and a DSN has been created between the two using the native mysql...
I have a maint plan that backups up the t-logs (and one for the databases) of all the user databases, while executing, the job runs nice and fast,...
sql2k, sp3a Transactional replication snapshot file created without error, but when the distribution agent runs for about 2 minutes the error is:...
I have a Master/Slave transaction replication setup where the slave is read only. The master server is very old and I need to take it offline, Would...
SQL 2000 Servers: DB1 & DB2 DB1 --> replicates a database to DB2 DB1 has DB2 as a remote server (not a linked server) I need to run a query on...
SQL Server 2000 Merge Publication's Push subscriptions are expiring early. (before the 14 days) No messages given, any known reasons ?
So, In Windows 2000 does the local system account have network access or not ? quote:...
Why does the database keep starting up all the time ? Auto-close is set to OFF Snippit from ERRORLOG.1 2004-02-19 11:54:27.45 spid57 Starting...
I've inserted images into an sql table (image col) to view the image from an Access form This inserts the image successfully but Access doesn't...
I have a few tables without a PK or unique constraint The merge replication added the uniqueidentifier as the rowguid So, I'd like to make that...
In a VB6 app, I make an ADO connection to MSDB using the sa account and run sp_start_job @job_name = 'abc' Sometimes in the job history it says...
Would deleting the guest account from MSDB and distributon DB's do any unforseen harm ? One reason I ask is because I don't want anyone with a...
Running SQL Server 2000 on Win2k but the domain isn't Active Directory yet, it's NT4. My question is, can I add the NT4 domain groups to roles in my...
I was browsing BOL for the sp_ to script a publication + subscriptions but couldn't find any. I found the section "scripting replication" and it...
I created a backup of the biz database from our Main Server. I went to our test server, imported it for the first time, created a publication from...
Separate names with a comma.
