Search results for query: *

Is there anyway to log when a user logs into a Citrix client, how long they were active/inactive and when they logged off?

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...

I have set up a FTP file transfer through DTS. Is there anyway to delete the file from the FTP server after the file is retrieved?

No. The replication was dropped and deleted last week. I am trying to bring it back online. All subscriptions were also dropped

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?

Can you actually connect a remote server as a linked server? I have tried to no avail

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?

Within the enterprise manager, I am unable to open the tree for databases or management. Anyone ever had this happen?

I have a SQL server named Register that I need to create an update procedure on another SQL server. how do I do this?

Worked like a charm. Thanks so much Terry

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...

Sorry it is from a table to a table. The identity is set to one. Tried it out worked like a charm. Think I tried to overthink that one

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...

Worked like a charm. Thanks so much

And this fields are never the same where one data record could be (555) 555-5555 the next could be 555-555-5555

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...