Server Hang During Drop Merge Subscriptions ....
Jul 24, 2007does anyone has idea why the server hang when i try to drop merge subscriptions?
any suggestion would be appreciate.
thanks.
ADVERTISEMENT
One Or More Subscriptions Have Been Marked Inactive. Drop And Re-create All Subscriptions For This Node...
May 16, 2007Greetings,
We periodically get the following message in our three server peer-to-peer transactional replication environment:
"One or more subscriptions have been marked inactive. Drop and re-create all subscriptions for this node that are failing with this error."
What causes a subscription to be marked inactive? What properties or settings can be adjusted to minimize or eliminate this occurrence?
Everthing seems to be running OK and then we get the message. It afflicts the higest change volume publication on our slowest overseas server.
Thanks,
BCB
HOW To Pull Merge Subscriptions In SQL Server 2000 Using Stored Procedures ??? (URGENT)
Dec 15, 2005I've successfully carried out pull subscription using Wizard in SQL server 2000.
But NOW its the time to deploy the project & I've to do it programatically........
i tried to use the default stored procedures like "sp_addmergepullsubscription ", "sp_addmergepullsubscription_agent ", "sp_reinitmergepullsubscription ", with respective parameters.
Then using replmerge.exe i tried to execute the batch file But could not succeed......
Can anyone guide me from the Basics ??? (i knw the Replication Architecture its heirarchy....but have NO idea of performing it Programatically......!!!!!!!!)
by BASICS, i mean......how should i execute the resp. stored procedures with what parametes & the order i should follow in order to successfully pull a merge subscription in SQL server 2000.
if a Sample code is mentioned as example, would be better for me to understand....
Thanking all of you in anticipation...........
Mandar
SS2005 Replication - Cannot Drop Subscriptions From Publisher
Jun 22, 2006I am executing sp_dropmergesubscription, but the rows are still in dbo.msmerge_subscriptions, and are still shown in the replication monitor as expired; the last synch dates were in april (expiration is set to 10 days). The 'expired subscription clean up' job appears to be running okay. I need to remove these subscriptions from the publisher as the subscribers are mobile devices, which sometimes are lost.
Enumerate Subscriptions In A Merge Replicated CE Database?
Jun 27, 2007
How can I list all of the Subscriptions in a CE Database that was created with the .Net System.Data.SqlServerCe.SqlCeReplication.AddSubscription method?
After I create the CE database in an sdf file, I can connect to it with SQL Servr Mgmt Studio, then see the list of Subscriptions in the Object TreeView, under "Replication"
But I can't find that Subscription list in any properties or methods of System.Data.SqlServerCe.SqlCeReplication or System.Data.SqlServerCe.SqlCeConnection
Should I be looking in RMO features like Microsoft.SqlServer.Replication??
We want to confirm that a local CE database was last synced from the expected SQL Server database by checking the Publisher property of each subscription in the CE database.
Thanks
Email Subscriptions: Changing From Address For Different Subscriptions On Same Server
Jan 18, 2007I doubt this is possible, but can someone think of a way to change the email address used for sending report subscriptions based on the report or subscription?
It's a need that I've heard from a number of different clients. Scenario: a company has one reporting services server with reports running from numerous departments. Report subscriptions are sent to internal and external email addresses and there's a business need to use different "from" addresses based on the report (or audience).
How To Access Or Modify Local Subscriptions Data In Merge Replication
Apr 3, 2007Hello,
If I want to access or modify my local subscription data(not the configuration) how can I do that(from sql server 2005 or from asp.net)? Also can i update directly to the local subscriptions data or do I need another layer which will update from a table for example??
Thank you
Salah
Cannot Drop A Table On Two Servers After Merge Replication
Oct 3, 2001Hi,
I tried with success to replicate a table_test_repl from my local server to an other server.
I used only one table for testing.
After that, i can't drop the 2 tables a_test_repl (on my local server and the other : I've got a message 'cannot drop the table because it is published for replication'
What can I do? I need absolutely to drop these tables to keep a clean model
and I can't drop the database and try again.
Thanks to your answers
Axel
Server Hang
Feb 6, 2007Guys.
Quite a large log attached.
I had 5 servers hang all on the same day, all within about 5 mins of each other scattered across 4 corners of the UK. Our support team tell me that it has something to do with SQL Server, but cannot say what.
I can see looking at the error log of one of the servers, that there are about4 entries everyday since startup, and this continues right up until the night before the freeze.
At 22:00 the night before the freeze, a load of entries are written (Iv'e cut down the list to make it easier to read). then at around 4am the servers all froze.
Could someone take a sneaky peak at these logs and tell me in your own opinion what caused this to happen.
The first section, is what I believe to be normal
2006-11-28 20:52:53.68 server Copyright (C) 1988-2002 Microsoft Corporation.
2006-11-28 20:52:53.68 server All rights reserved.
2006-11-28 20:52:53.68 server Server Process ID is 952.
2006-11-28 20:52:53.68 server Logging SQL Server messages in file 'D:Program FilesMicrosoft SQL ServerMSSQLlogERRORLOG'.
2006-11-28 20:52:53.73 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2006-11-28 20:52:54.75 server Working Set size set to 409600 kilobytes.
2006-11-28 20:52:54.90 server SQL Server configured for thread mode processing.
2006-11-28 20:52:54.90 server Processor affinity turned ON, processor mask 0x1
2006-11-28 20:52:54.92 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2006-11-28 20:52:55.20 server Attempting to initialize Distributed Transaction Coordinator.
2006-11-28 20:52:57.20 server Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
2006-11-28 20:52:57.53 spid3 Starting up database 'master'.
2006-11-28 20:52:59.31 spid3 Server name is 'SN047483'.
2006-11-28 20:52:59.31 server Using 'SSNETLIB.DLL' version '8.0.760'.
2006-11-28 20:52:59.31 spid5 Starting up database 'model'.
2006-11-28 20:52:59.50 spid8 Starting up database 'msdb'.
2006-11-28 20:52:59.50 spid9 Starting up database 'pubs'.
2006-11-28 20:52:59.53 spid10 Starting up database 'udb'.
2006-11-28 20:52:59.64 spid11 Starting up database 'vgold'.
2006-11-28 20:53:00.07 server SQL server listening on 155.202.58.53: 1433.
2006-11-28 20:53:00.07 server SQL server listening on 127.0.0.1: 1433.
2006-11-28 20:53:00.29 spid5 Clearing tempdb database.
2006-11-28 20:53:00.64 server SQL server listening on TCP, Shared Memory, Named Pipes.
2006-11-28 20:53:00.64 server SQL Server is ready for client connections
2006-11-28 20:53:00.71 spid9 Starting up database 'dbs'.
2006-11-28 20:53:01.01 spid8 Recovery is checkpointing database 'msdb' (4)
2006-11-28 20:53:01.50 spid5 Starting up database 'tempdb'.
2006-11-28 20:53:53.78 spid3 Recovery complete.
2006-11-28 20:53:53.78 spid3 SQL global counter collection task is created.
2006-11-28 20:53:54.32 spid59 Using 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure 'xp_qv'.
2006-11-29 00:00:01.10 spid69 Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'xp_instance_regread'.
2006-11-29 02:00:01.54 spid69 Using 'xplog70.dll' version '2000.80.760' to execute extended stored procedure 'xp_cmdshell'.
2006-11-29 02:00:09.31 backup Database backed up: Database: master, creation date(time): 2006/11/28(20:52:57), pages dumped: 1907, first LSN: 159:245:1, last LSN: 159:247:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}).
2006-11-29 02:00:11.46 backup Database backed up: Database: msdb, creation date(time): 2000/08/06(01:40:56), pages dumped: 1667, first LSN: 397:332:1, last LSN: 397:335:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}).
2006-11-29 02:01:58.10 backup Database backed up: Database: dbs, creation date(time): 2004/10/05(08:00:04), pages dumped: 94467, first LSN: 114:53199:1, last LSN: 114:53203:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}).
2006-11-29 02:01:58.20 backup Database log truncated: Database: dbs.
2006-11-29 10:51:33.43 spid62 Using 'odsole70.dll' version '2000.80.760' to execute extended stored procedure 'sp_OACreate'.
2006-11-30 02:00:04.34 backup Database backed up: Database: master, creation date(time): 2006/11/28(20:52:57), pages dumped: 1907, first LSN: 159:260:1, last LSN: 159:262:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}).
2006-11-30 02:00:06.57 backup Database backed up: Database: msdb, creation date(time): 2000/08/06(01:40:56), pages dumped: 1667, first LSN: 398:26:1, last LSN: 398:29:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}).
2006-11-30 02:01:53.84 backup Database backed up: Database: dbs, creation date(time): 2004/10/05(08:00:04), pages dumped: 94467, first LSN: 114:54895:1, last LSN: 114:54899:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}).
2006-11-30 02:01:53.93 backup Database log truncated: Database: dbs.
2006-11-30 13:10:09.96 spid67 Error: 60002, Severity: 15, State: 1
2006-11-30 13:10:09.96 spid67 PBX login_id 5592 already exists in user id 379. Proc Name: um_user_insert.
2006-12-01 02:00:04.51 backup Database backed up: Database: master, creation date(time): 2006/11/28(20:52:57), pages dumped: 1907, first LSN: 159:275:1, last LSN: 159:277:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}).
2006-12-01 02:00:06.76 backup Database backed up: Database: msdb, creation date(time): 2000/08/06(01:40:56), pages dumped: 1667, first LSN: 398:408:1, last LSN: 398:411:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}).
2006-12-01 02:01:52.31 backup Database backed up: Database: dbs, creation date(time): 2004/10/05(08:00:04), pages dumped: 94515, first LSN: 114:55915:1, last LSN: 114:55923:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'QMBACKDEVICE'}).
2006-12-01 02:01:52.39 backup Database log truncated: Database: dbs.
This second section then has around a good few hundred entries.
2006-12-01 22:00:01.98 spid67 Error: 60132, Severity: 15, State: 1
2006-12-01 22:00:01.98 spid67 Folder 7 is not assigned to user 11 Proc Name: ags_workflow_sess_count.
2006-12-01 22:00:02.04 spid67 Error: 60132, Severity: 15, State: 1
2006-12-01 22:00:02.04 spid67 Folder 7 is not assigned to user 11 Proc Name: ags_workflow_sess_count.
2006-12-01 22:18:02.57 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 22:18:02.57 spid66 Folder 7 is not assigned to user 63 Proc Name: ags_workflow_sess_count.
2006-12-01 22:43:37.42 spid67 Error: 60132, Severity: 15, State: 1
2006-12-01 22:43:37.42 spid67 Folder 7 is not assigned to user 493 Proc Name: ags_workflow_sess_count.
2006-12-01 22:43:37.43 spid67 Error: 60132, Severity: 15, State: 1
2006-12-01 22:43:37.43 spid67 Folder 7 is not assigned to user 493 Proc Name: ags_workflow_sess_count.
2006-12-01 22:44:37.51 spid58 Error: 60132, Severity: 15, State: 1
2006-12-01 22:44:37.51 spid58 Folder 7 is not assigned to user 613 Proc Name: ags_workflow_sess_count.
2006-12-01 22:46:07.00 spid67 Error: 60132, Severity: 15, State: 1
2006-12-01 22:46:07.00 spid67 Folder 7 is not assigned to user 660 Proc Name: ags_workflow_sess_count.
2006-12-01 23:00:20.65 spid58 Error: 60132, Severity: 15, State: 1
2006-12-01 23:00:20.65 spid58 Folder 7 is not assigned to user 949 Proc Name: ags_workflow_sess_count.
2006-12-01 23:00:20.67 spid58 Error: 60132, Severity: 15, State: 1
2006-12-01 23:00:20.67 spid58 Folder 7 is not assigned to user 973 Proc Name: ags_workflow_sess_count.
2006-12-01 23:02:33.07 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:02:33.07 spid66 Folder 7 is not assigned to user 1010 Proc Name: ags_workflow_sess_count.
2006-12-01 23:04:38.10 spid58 Error: 60132, Severity: 15, State: 1
2006-12-01 23:04:38.10 spid58 Folder 7 is not assigned to user 1247 Proc Name: ags_workflow_sess_count.
2006-12-01 23:04:38.12 spid58 Error: 60132, Severity: 15, State: 1
2006-12-01 23:04:38.12 spid58 Folder 7 is not assigned to user 1266 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.59 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.59 spid66 Folder 7 is not assigned to user 1659 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.59 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.59 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.59 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.59 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.60 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.60 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.60 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.60 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.62 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.62 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.62 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.62 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.62 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.62 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.62 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.62 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.64 spid66 Error: 60132, Severity: 15, State: 1
2006-12-01 23:06:08.64 spid66 Folder 7 is not assigned to user 1812 Proc Name: ags_workflow_sess_count.
2006-12-01 23:06:08.64 spid66 Error: 60132, Severity: 15, State: 1
This section shows from 4am onwards
2007-01-13 04:05:09.87 spid71 Error: 60132, Severity: 15, State: 1
2007-01-13 04:05:09.87 spid71 Folder 7 is not assigned to user 613 Proc Name: ags_workflow_sess_count.
2007-01-13 04:05:13.40 spid75 Error: 60132, Severity: 15, State: 1
2007-01-13 04:05:13.40 spid75 Folder 7 is not assigned to user 660 Proc Name: ags_workflow_sess_count.
2007-01-13 04:05:16.15 spid77 Error: 60132, Severity: 15, State: 1
2007-01-13 04:05:16.15 spid77 Folder 7 is not assigned to user 660 Proc Name: ags_workflow_sess_count.
2007-01-13 04:05:17.29 spid61 Error: 60132, Severity: 15, State: 1
2007-01-13 04:05:17.29 spid61 Folder 7 is not assigned to user 660 Proc Name: ags_workflow_sess_count.
2007-01-13 04:05:18.12 spid69 Error: 60132, Severity: 15, State: 1
2007-01-13 04:05:18.12 spid69 Folder 7 is not assigned to user 63 Proc Name: ags_workflow_sess_count.
2007-01-13 04:10:28.81 spid51 Unable to load OLE/DB initialization service.
2007-01-13 04:58:12.21 server Error: 17883, Severity: 1, State: 0
2007-01-13 04:58:12.21 server The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x250A5C68.
2007-01-13 04:59:12.21 server Error: 17883, Severity: 1, State: 0
2007-01-13 04:59:12.21 server The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x250A5C68.
2007-01-13 05:00:12.21 server Error: 17883, Severity: 1, State: 0
2007-01-13 05:00:12.21 server The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x250A5C68.
2007-01-13 05:01:12.21 server Error: 17883, Severity: 1, State: 0
2007-01-13 05:01:12.21 server The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x250A5C68.
2007-01-13 05:02:12.21 server Error: 17883, Severity: 1, State: 0
2007-01-13 05:02:12.21 server The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x250A5C68.
2007-01-13 05:03:12.21 server Error: 17883, Severity: 1, State: 0
Problem On SQL Server Hang
Dec 10, 2007Hi guys, I am having a serious problem on my SQL server. Assuming there's a web server (Cold Fusion in IIS) connects to my SQL server (SQL server 2005 and million records in it which consider quite big for the db size), it works fine and run smoothly during weekday. However, there will be lots of users accessing the db through my web application (located at my web server) until my web application get hang. Not only that, even I want to access my SQL server from my place using management studio also fail.
I try remote desktop into the SQL server, view the 'Task Manager', it shows 1-2% CPU usage that it takes; and i'm able to open the SQL server using management studio. Therefore, I try to restart my web service( IIS ) , and it still unable to open my web application. However, once I restart the SQL service, my web application is available. This issue happens to me every weekend with several times. It's no point for me to restart the SQL service again and again.
1) What's the reason that I need to restart the SQL service then only I can open the web application? Is it the SQL server
hang or the connection problem?
2) Is it lots of record in the database causing the server gets hang since lots of user accessing the database?
3) Where can I check out the exactly problem on it ? IIS log or SQL log?
Hope can get any assistance from here and get a solution/suggestion from you guys as soon as possible.
Best Regards,
Hans
SQL Server 2000 Installation Hang
Sep 30, 2004Hi,
I am using Windows 2003 Standard Server (stand alone) and trying to install SQL Server 2000 Enterprise edition. The installation stops whenever I have entered the sa password (the dialog box disappeared and then nothing happed, but the "setupsql" process (something like this) is still there).
The same happened when I install SQL Server 2000 in Windows 2000 Server. For Win2K, I can first install SQL Server 7.0 and then upgrade to 2000 (same SQL Server 2000 installation CD!). However, Windows 2003 doesn't support SQL Server 7.0. So I can't use this method...
Any idea?
Thanks.
Michael
*I have turned off Norton already.
Weak Performance And SQL-Server Hang-Ups
Dec 2, 2004Greetings everybody,
lately we are experiencing some very strange behaviour on the part of our
SQL-Server.
We are using SQL-Server as a combined Database for one COM+ application and one J2EE-Application. All of this is installed on the same machine (dual-CPU, 2 GB RAM).
This setup has been up and running for almost a year now.
In the last two weeks there have been incidences where the performance of SQL-Server is decreasing steadily until it finally hangs completely (just SQL-Server, not the machine itself).
This happens 2-3 times a week, curiously always between 9 and 10 a.m.!
After stopping and restarting the actual SQL-Server "Service", everything is back to normal (until the next morning or the morning after that).
There are a few automated batches that access the database via the COM+ Server. These run at night and are completed before work begins at ca. 7 a.m.
Profiler-Logs show a few "Escalate Locks", but those alone cannot account for this strange behaviour.
Any help or info would be greatly appreciated.
SQL Server 2005 Service Hang
May 31, 2008
Dear All,
SQL Server 2005 a lot of time hangs. Any advice is highly appreciated!
Please have a look at the error log from this link http://download.yousendit.com/B787CBD235FC2417
Regards,
LG
Dbcc SomeDLL(free) Causes Server To Hang Out
Apr 1, 2008 Hi there.
When I try to free previously registered DLL, server is starting to execute query and it takes a number of minutes and nothing happens.
Here is an example:
sp_addextendedproc 'xp_test','test.dll' //works fine
exec master..xp_test '999' //works fine
sp_dropextendedproc 'xp_test' //works fine
dbcc test(free) //do not work
I've tested it on:
SQL MSDE SP3 //i was getting an acces violation first: spid 51 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at 0x00000000
SQL MSDE SP4 //but on this SP I have the same behaviour as on server 2005 / infinite query execution time
SQL Server 2005 standard //infinite query execution time
SQL Server 2005 standard with SP2 //infinite query execution time
I can't understand this because this started after chaning my machine.
It worked without any problems on the previous one and I've used this metod very often on the same dll which hasn't changed.
Is there any way to solve this?
Thanks for your time.
DB Engine :: Database Server Is In Hang State
Oct 13, 2015SQL server DB server is in hang state. Is this is due to high memory utilization?
View 9 Replies View RelatedSQL Server 2005 Failover Cluster Installation Hang
Jun 11, 2008Hai -
Currently i am do sql server 2005 failover cluster installation on win 2003 server.
It is showing preparing to install please wait and there is no progress from last two hours.
Is there any way to check whether installation is going on or where can i check log files for this installation.
Please advise asap.
Cheers:)
vsh
SQL Server 2005 In Subscriptions
Jun 20, 2006Does SQL Server 2005 come in any MSDN subscription packs? The content list isn't generally comprehensive and all the subscriptions seem to come with SQL Server 2000.
View 1 Replies View RelatedReport Server Subscriptions - Job Owner
Jul 23, 2005Hi,I am trying to setup a subscription but I keep running into problems.I setup the subscription fine, I see that it creates a job in SQLServer. It shows a specific domain account as the owner and I can'tfigure out why. The problem is that this account is in a differentdomain and it's having problems authenticating when it runs. I did usethis account for the services and whatnot when I originally set it up,but I've changed the account that SQL Server and SQL Server Agent rununder, but it still uses this account as the owner. The only otherthing I can think of is that the database owner ofSystemCenterReporting is still this account. Is this why it's listingthis account as the owner of the job? Where else could it be?Thanks,Bill
View 2 Replies View RelatedDrop All Indexes In A Table, How To Drop All For User Tables In Database
Oct 9, 2006Hi,I found this SQL in the news group to drop indexs in a table. I need ascript that will drop all indexes in all user tables of a givendatabase:DECLARE @indexName NVARCHAR(128)DECLARE @dropIndexSql NVARCHAR(4000)DECLARE tableIndexes CURSOR FORSELECT name FROM sysindexesWHERE id = OBJECT_ID(N'F_BI_Registration_Tracking_Summary')AND indid 0AND indid < 255AND INDEXPROPERTY(id, name, 'IsStatistics') = 0OPEN tableIndexesFETCH NEXT FROM tableIndexes INTO @indexNameWHILE @@fetch_status = 0BEGINSET @dropIndexSql = N' DROP INDEXF_BI_Registration_Tracking_Summary.' + @indexNameEXEC sp_executesql @dropIndexSqlFETCH NEXT FROM tableIndexes INTO @indexNameENDCLOSE tableIndexesDEALLOCATE tableIndexesTIARob
View 2 Replies View RelatedHow To Migrate Data-driven Subscriptions To Different Server
Nov 30, 2007hi guys,
I have created data-driven subscriptions on top of the existing reports on my development server.
I have same reports on QA's report server but without the DD subscriptions.
Is there an easy way to migrate data-driven subscriptions to QA report server or the only way to do is create each subscription manually?
Thankskev
Job Hang
Sep 1, 2006Hi,
I am running the following TSQL command and it hangs. These commands are running from SQL 2000 server and it is querying information for SQL20005 database.
Running simple EXEC command work fine but running using Insert hangs.
Set @Cmd = @ServerName + '.' + @dbname + '.dbo.sp_helpntgroup'
Print @Cmd
Insert into dbo.DBSecurity ( NTGroupName, NTGroupID, SID, HasDbAccess)
Exec (@Cmd)
Any idea,
Transactional Publication With Updatable Subscriptions In SQL Server 2005, SvPk 2
Jul 31, 2007
Subscription to "Transactional Publication with Updateable Subscriptions" works only one way. Changes take effect on subscriber, but the subcriber is unable to update data on publisher.
I have Sanpshot Agent process running under SQL Server Agent service account with login 'sa.' All agents are running at the Distributor (Publishing Server.)
The subscriber is unable to connect to the Distributor using the SQL Server login.
Following is the error message I get:
Creating Subscription(s)...
- Creating subscription for 'SQL3' (Warning)
Messages
Unable to set the Publisher login for the updatable subscription. You may have to set this up directly on the Subscriber machine using sp_link_publication. (New Subscription Wizard)
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
MSDTC on server 'SQL3' is unavailable.
Changed database context to 'DB_SQL1_to_SQL3_on_3'. (Microsoft SQL Server, Error: 8501)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=8501&LinkId=20476
Please suggest procedure to end this dilemma. The link has no info available.
Adding New Subscription To SQL Server 2005s Local Subscriptions Fails...
Jun 23, 2006Hi everyone,
I am trying to add a new subscription to the local subscriptions of a SQL Server 2005. As soon as I click on SERVER_NAME -> Replication -> Local Replications -> New Subscription, I get the following error message:
TITLE: New Subscription Wizard
------------------------------
Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic Installing Replication in SQL Server Books Online.
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.ReplUtilitiesErrorSR&EvtID=ReplicationNotInstalled&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
Die EXECUTE-Berechtigung wurde für das 'sp_MS_replication_installed'-Objekt, 'mssqlsystemresource'-Datenbank, 'sys'-Schema verweigert. (Microsoft SQL Server, Error: 229)
Translated from German to english:
EXECUTE-Permission for the 'sp_MS_replication_installed'-Object, 'mssqlsystemresource'-Database, 'sys'-Schema denied. (Microsoft SQL Server, Error: 229)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Btw, I am using the SQL Server Management Studio.
Thanks,
Olcay
SQL Hang SELECT * (bit OT)
Jan 12, 2006Hi Everyone,
I'm having a bit of a dispute with one of my clients' software developers.
This client has a server, installed by us (Windows 2003 Std. SP1/ SQL 2000 SP3a) (Dual Xeon 2.8, 4GB RAM)
They are having performance issues with the software developers application, which is based on SQL.
I'm having trouble believing the issues are caused by the server, but the software dev's blaming us for the problems.
Yesterday i got a mail from them that a specific SQL query "hangs" upon execution and this is likely caused by a bad install of the server or SQL (yeah right). This query is: select * from table, wich hangs the server upon running. Theyt say a select row(item) from table does work (duh).
Now i know a bit of SQL and i'm thinking this select all from that table query locking up the server is most likely caused by a table that has grown so big that it just locks up.
Am i right thinking this has nothing to do with the hardware/software (sbs/sql), but is merely caused by bad programming and/or lack of SQL knowledge at the dev's side? Especially since last year the DB grew to about 40 GB and i had to tell them to think about putting it in simple mode to make it smaller. Something they'd never heared about...
Any ideas would be very welcome.
I don't want to go throw mud around with us blaming them and them blaming us and the client being the one with the problems.
I just want to make a well thought out statement to the software dev. and then try to find the right solution.
Thanks,
Dennes
UMS Scheduler Hang
Apr 10, 2006Hi Guru,Our HR sql 2000 production server is 800.760 built (SP3a) with 2GB ofRAM and 2 CPU hiper threading. This server is very low activity whereprocessor runs average 1-3 during the day. However, in the last twomonths, I've seen the following message occurred a few times on thisserver.Error: 17883, Severity: 1, State: 0The Scheduler 2 appears to be hung. SPID 0, ECID 0, UMS Context0x0381F660.I did extensive research and read both KB 815056 and 10885 but I couldnot correlate these KBs in to my issue. The reason is, I don't thinkour server is very busy to cause the checkpoint process to be delayed.The database keeps growing only 5-10MB in a week and I allocated thespace during off hour.What is the solution to fix this issue? Will I fix this issue byapplying the hotfix MS03-031?Thanks so much,Silaphet,
View 1 Replies View RelatedBackup Job Hang
Jul 26, 2006hi,everyone!I meet strange thing when I create a maintance job for backup alldatabase.and this backup job just stands "Executing job step '(step 1)'" for averylong time .SQL server startup account is this account for network bakcupafter I issue sp_databases sp, I found my full database size only 1GB,and I found my backupfile is complete.I view event log and Sql server Log and no found error!why do it take so long time, but stands 'executing ' status and neverfinish.help me!best regards!
View 1 Replies View RelatedSQL Replication Hang
Jan 28, 2008My SQL CE Replication is hanging during a full CreateDatabase download. My SDF file is around 13 MB loaded onto an SDIO card. I need to be able to blow away the SDF file and fully reload from remote locations.
I get all of the table 'upload' and 'download' async events and it appears to be working but then just hangs until I guess the device runs out of memory. I get several beeps and then the hourglass. After a reboot, the DB file is not usable.
I've been using SQL CE 3.0 for awhile and it has worked ok in the past. I upgraded to SQL CE 3.5 but I see the same behavior.
My replication data consists of about 30K inserts across about 30 tables.
Any ideas on how to debug a problem like this? I'm really stuck with this bug.
thank you
SSIS Hang
Sep 8, 2006I sumbit a package A in MSDB in SQL2005 EE server with SP1 by dtexec.
Package A called 2 packages B and C in MSDB to do some data flow task.
The package A finished successfully in about 2 to 3 mins.
Howerver, when I submitted the package A again. Package A hanged.
I checked the Activity Monitor and found all related Package A, B, C task is sleeping.
I killed the dtexec and then re-submit the package A. Package A finished successfully this time in expected duration.
It is strange.
Could anyone tell me the reason of hanging?
Thank you very much.
Job Hang Issue
Dec 28, 2007
I have a job that FTP's a backup file offsite daily. Sometime the job hangs (for undetermined reason). The job never terminates. Is there ar way to force termination of the job after so many minutes? This is a Operating System command job.
I see the parameter "Shutdown Timeout Interval" in SQL Server Agent - currently set to 15 seconds. This apparently is not used or not working, as my job was hung for several days and it was not detected. The job runs daly. Since the prior run was "still running - hung", it didn't start, causing my offsite backups to fail following the job hang.
How can I force termination of a job if it doesn't complete in so many minutes?
BackUp/Dump Hang Up?
Jul 13, 1998Hi,
excuse me if this problem has been discussed before!
We handle the addmittance in our university with IIS 4.0 and MS SQL Server 6.5 ... a group of 12 operators keep the server busy entering the information about students...
I run backup of the hole database on every 1 hour in order to have a recent copy of the date base in case the disk fail (we had bad luck with a quantum HDD few weeks ago).
The problems begun when the data base got to 18 MEGs and at about 32 connections to the SQL server when the dump finish the server goes out...
Anyone heard about this before and how to handle it?
Yours truly WarJo
PS: Sorry for my englsih... not good enought
DTS Oracle Jobs Hang
Feb 23, 2004hello:
My situation is
(1) I upgraded MS SQL 7.0 from original edition to SP 4
(2) DTS packages which download data from an oracle server work fine both on a remote machine and on the Server
(3) When these packages are scheduled to run as jobs they do not succeed and do not fail they just keep running e.g for 58 hours over the weekend
(4) even if I start the job on the server I still get the same behaviour:
Can anyone help please?
Snapshot Agent Is On Hang
Nov 30, 2015We have initiated reinitialize subscription by which snapshot agent is started and hanged at 26%.We have a publication of 6 articles, transactional replication, using SQL Server 2008R2.
View 3 Replies View RelatedDTS 2K And Hang With Ingres Import
Apr 20, 2006Hi All,
I have a problem with a DTS package to import data from one of our Ingres based Databases.
I've recently moved the DTS package from one server to another and recreated the Ingres ODBC Settings, which are all OK.
When I run the package through EM and the CMD line, it runs OK, but not as a scheduled task.
I've had a look at a KB Article Q318819 and followed the steps about package threads on 3rd party drivers, but this doesent help, nor does making sure DTSRun isnt in the current task list.
Could anyone help me out please?
TIA.