Search results for query: *

I need some help with setting up our linked servers. We have a couple of jobs that run on a weekly basis that need sysadmin access to our linked servers. The rest of the time we only want only the report users that have a login on the linked server to have select access to them. So here is...

We have a user that has a Mac OS X and office 2004. Any idea if we can connect to a Microsoft SQL Server OLAP cube? I can't find how to do it. We know that it wasn't available in Office 98 but we hope that they put it in the newest version. We will take any info that you have. Thanks! John

I am creating a script that will perform a bunch of steps to lock down any new servers that we create. One of the steps is to remove the builtin\Administrators group. I have tried using sp_dropgroup and sp_droprole but neither of them work. Is there a way to drop this group via TSQL...

Can someone verify that it is impossible to connect to the console of a windows 2000 server? I have tried several things but have been unsuccessful with each thing. I have done several searches on google but haven't turned up a definite answer yet. I would appreciate the help! Thanks! John

Older Compaq machine with Windows 98 just reloaded on it. I put in a US Robotics 56k winmodem. Windows 98 finds it and I installed the driver for it, no problem. I go to set up a internet connection and when it trys to dial out, it says that the modem cannot be found or that the port is...

We have a table, Addresses, that contains around 2 million rows. We have 3 other tables that have foreign key contraints that reference the Addresses table. Each of those 3 tables contain around 2 million rows. The Addresses table has a primary key of CycleId, ExtractTypeId, AcctNo. It has a...

I have a win98 machine that i just reloaded. At first, windows was seeing that there was a US Robotics SPortster windom 28.8 modem installed and was asking me to load the driver for it. I went out and downloaded what I thought was the right driver. When I pointed it to the downloaded files...

I just reloaded windows 98 on my friend's machine. After the installation was complete, the machine would not start up in normal mode. It kept wanting to start in safe mode. I looked in the device manager under the display adapters and it shows two things. One being the S3 Trio 32/64PCI...

We are trying to create an URL that we can pass a username & password in and it will log users into ePortfolio automatically. Has anyone else does this? We would appreciate any help you can offer. Thanks! John

I have a project to go through and find best SQL Server security best practices. One of the practices I came across said to use windows encrypted file system to encrypt our SQL Server database files. Has anyone done this? Is there any performance issues with doing this? I didn't know if...

I have a Crystal designer who has created a report that prints out bag tags. She would like to have it print out 2 pages for every record in the report. There is one record per page. Is this a Crystal function that we can take advantage or is it more of a printer setting? I am not sure. If...

We have a running total field that is counting the number of records on a page. It is putting 54 records on a page. We need the running total field to reset after each 54 records. We tried editing the running total field and set it to reset on the formula: count(Records) = 54. This is not...

I suppressed the default interface for my database that I am publishing via IWP. I would like the users to be able to make changes. The problem is that the submit changes button is on the interface. Is there a script step that i can use to submit the changes via a button? Any help would be...

I have a DTS package that is executing a stored procedure as one of the steps. Within the SP, I do some error handling and raise an error if one occurs. How do I see that error that is raised or is there a certain error severity that I need to use to cancel the DTS package? The output file...

I need some help with a DTS package I am trying to design. Here is what I want to do: I have 4 dbase files that I want to load into corresponding SQL tables. The files do not contain a meaningful date. So I want to add a SnapShotDate to them. I want to be able to specify this SnapShotDate...

I need some help with getting a point in time restore to work successfully. I need to restore my database to a time between 10/7/2003 6 pm and 10/8/2003 1 am. It doesn't matter what time it is between then. Data was corrected before 6 and a purge process was fired at 1 am so we want the data...

We implemented FM Server 5 a couple of weeks ago. I set the server up to not disconnect guests idle for any amount of time. It has worked great for the two weeks. Last night the server disconnected several idle guests unexpectedly. Does anyone know why it would do this all of a sudden? I...

I am trying to capture some data that is being written to the Windows application log. I can't find a way to do this via TSQL. Does anyone know of a way to do this? I did find a stored procedure named sp_eventlog but it is undocumented. It accepts 4 parameters but I can't figure out what...

Is FMServer compatible with Windows 2003 Server? Has anyone tried this setup? I would appreciate any input you can offer. Thanks, John

I am trying to create a data access page against a sample Access database. I go through the wizard to create the data access page and it creates the page successfully and at the end it brings up the page. It works at that point. When I try to copy the html file it produces to the wwwroot...