Ok I am stuck in a catch-22. Over this weekend, I created a full transactional replication job on a 12 gig database including tables, sp's, the whole gammut. Something along the way screwed up and now I am trying to delete the subscription to the replication but the tempdb file fills up before...
When trying to add an article (table) to a replication job, the server hangs and locks the table down. The table only has 20 rows in it so it's not a size issue. I try and use the wizard and the server locks the table and won't finish. When using sp_addarticle in query analyzer, the query runs...
I have three tables tbl_Students, tbl_Enrolled and tbl_Classes. The tbl_Students and tbl_Enrolled have a one to one relationship. When a student is enrolled in a class in tbl_Classes, the ClassID field is placed in tbl_Enrolled to create a join between tbl_Enrolled and tbl_Classes.
I am trying...
i am trying to delete a published replication object and when i try it slowly but surely makes the SQL server slow to a crawl. i have tried to delete it from enterprise manager and used t-sql commands tono avail. has anyone ever hadthis happen?
BOL says that I can't unless I form it into a stored procedure. I have 13 satellite offices running a SQL 2000 database and one central SQL database. I need to figure out how to copy data from the 13 tables into the central. Anyone help?
When running an insert command I am receiving the subject error. I have tried to change some things in the code to reference ideas that I found on the net but to no avail. Can anyone help?
Create Procedure sp_saPostPOSData
As
Set nocount on
Declare @C_SyStudentID int...
I am in the process of writing an insert routine to a history file from a daily file. This history file has an id field which is used to link to other files. How can I increment additions to the history file so that each has a distinct id number (i.e. last record in history file is 10, first...
I am working on tractor feed forms and do not need Crystal to move to a new page after completing the page. Is there any way to change this option?
I have three detail records per page and currently after it prints the three detail records, it skips the next three forms and starts the next set...
I have a database that I need to retrieve telephone numbers out of. The problem lies that I need these numbers with no delimiters ('-','(',etc). How can I do this?
How do I reduce or actually increase the average page density of a data file or index?
I have a large file with 3 mill entries that has a page density of roughly 10 percent through all 12 indexes in the file.
I can't imagine that this is using my resources very efficiently as the datafile is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.