I am trying to roll back a SQL Server 2000 database to a previous point in time, but I am not allowed to select the date I want in the 'point in time' dialog - it always reverts back to the date of the transaction log backup. So far, I have done the following, in the following order: 1....more >>

Folks, Any help with creating a SP that denormalizes the below table to the desired output will be appreciated. Current Input Table Structure: SNum KeyName KeyVal value 1 SCM1 name DFW 1 SCM1 OVal 200 1 SCM1 OSum 500 2 SCM2 name ORL 2 SCM...more >>

I would like to find out if there are any free tools that could be used to monitor a sql instance and list the a. most frequently run stored procedures and how long each takes b. most frequently run views and how long each takes netiq used to have app manager - is that still available ? ...more >>

Doesn anyone know how to tell what licensing mode a SQL Server is running. Per Processor or Per Seat? ...more >>

Hey all, Ok I have a client that currently have 3gig of memory in their SQL Server (SQL2005). They are using the /3gb switch in their boot.ini so in theory SQL server should use greater than 2 gig. Ok from my understanding, if they put in an extra 1 gig of ram to make the server now have...more >>

I need the following select to return values as doubles or floats, not whole numbers . Right now I get back integers (not rounded to boot): SELECT AVG( RideCountAM) as AMAvg, AVG(RideCountPM) as PMAvg etc. This is a dynamic select statement being used in an SqlDataSource. Thanks for any su...more >>

A week or so ago, my Global Catalog Server failed. I had additional DC's with FSMO's transferred, except for the GC. After clearing the metadata and people could function again, I started having trouble with SQL 2000 and authentication for scheduled jobs. The errors generated were authentic...more >>

I have a trigger I Am trying to create that will delete the record from my rental table when the status in the status table = Under Warranty. Here is what I have so far. By the way, both table have the jobnumber in common set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER TRIGGER ...more >>

Hi, I have a job that I want to schedule to run every 10 minutes in Sql Agent for Sql Server 2000. It is possible that my job could try to run while a previous run is still working. (At least I think it is). Is there a way that I can query to see if my job is already running? Thanks ...more >>

Hi, When I am using following script, I am getting an error message ALTER DATABASE mydb SET SINGLE_USER WITH ROLLBACK IMMEDIATE RESTORE DATABASE mydb FROM DISK ='\\myServer\c$\backup\mydb_oltp\mydb_oltp_db_200608062107.BAK' Server: Msg 3101, Level 16, State 1, Line 1 Exclusive access...more >>

I am trying to create a trigger where if the check box iin infopath is checked then it deletes the whole record from the database. I am not sure where to even start on this trigger. Please Help. ...more >>

We're contemplating an upgrade to SQL Server 2005 but I'd like to know if ongoing support for SQL Server 2000 is a potential issue. Thanks!...more >>

I need to run a query that will pull the most recent revision, and it must be based on the RevisionDate (if you need to know why it is because the revision column can contain letters, numbers, hyphens, or underscores - numbers, in this case have the highest value, but SQL interprets letters as h...more >>

Is there anywhere I can find out what SQL Server options are available and how to set them? Specifically (at the moment) I'd like to know if I can limit the amount of memory SQL Server Express is allowed to use and, if so, how. ...more >>

I would like to be able to do something like this: use mydb exec sp_grantdbaccess 'localhost\Users' go When I do, I get this error msg: Windows NT user or group 'localhost\Users' not found. Check the name again. The error message implies that I should be able to add a group. A co-wo...more >>

How can I check (where can I check) to see if SP1 was loaded onto a server? I checked Help, About. I check Control Panel. Any other suggestions?...more >>

Hi, I have a database server and my predecessor created replication and then dropped it. Now I am stuck with some servers under Remote Servers. When I try to delete them I get an error message: 20583 cannot drop server because it is used as a subscriber. Any hints on how I can drop these Remo...more >>

Hi All, I am having a problem with SqlServer 2000 sp3 in regards to getting it to accept SQL Authentication for users I have created. For example, on my sql server box (win2K3) I create a user "sps_serviceLOCAL", and add it to the Administrators group. I then add that account to the SQL Se...more >>

Hi, I have a database server and my predecessor created replication and then dropped it. Now I am stuck with some servers under Remote Servers. When I try to delete them I get an error message: 20583 cannot drop server because it is used as a subscriber. Any hints on how I can drop these Remo...more >>

I'm cuestion how to update at all this is my sentence update Table1 set Total = sum(b.monto) from Table1 a , Details b Where a.numerCode = b.numerCode the answer is : an aggregate may not apper in the set list of an Update statement. Thanks for you help. Chrees...more >>

Hi, while reinstalling Sql server 2000 (after complete uninstall process), system says: "previous installation leaves suspended operations on files into computer. It needs to be restarted before executing installation program." Problem still remains , also after resterting pc many times...more >>

Hi, To look up information about indexes for a given table in SQL Server 2005, I can use: sp_helpindex TableName or select * from sys.indexes where object_id = object_id('TableName') But this just gives me information about the column or columns on which the index has been defined. How d...more >>

I received a copy of a 2005 database I need to restore so I can evaluate its structure. I have just installed 2005 - how do I restore the database (it is a .bak file)? Any help would be greatly appreciated (I am just learning 2005 - but understand the basics of 2000). Thank you....more >>

Hi, last month I installed SQL Server 2000 on a new server (Install SQL2000 and then upgraded to SP4) because that server is going to replace the main production server. I've restored the database dumps from the old server to the new one and did also copy the SQL Agent jobs. Also configured...more >>

I have a database that has grown much larger than I expect. There is a specific table that seems to be unusally large. If I copy the data from that table out into a temp table then copy it back in, it frees up over 90% of the space that it was taking up. I cannot alter the database structure ...more >>

Hello, I'm exporting data from text file which contains 15 lakh records. Each field is delimited by "," and record is delimited by "$". Only 163200 records were inserted. I'm using this option bcp tablename in "datafile.txt" -c -t"," -r"$" -S"MyServer" -U"sa" -P"pwd123" Any worka...more >>

Good morning, I am new to sql server and I have an issue with my backups. So I set up these jobs: Backup for System database: Model, Master, MSDB DATABASE separately (every day at 22h) Model, Master, MSDB log separately (every hour, between 5h-21h) Backup for User Database Databa...more >>

Hi, I am running SQL Server 2000 SP3. For Security purpose i want to disable SA Account. But i am not sure that, we can disable SA account. Please give me reply. Thanks & Regards, Sajid C. ...more >>

Hi, Appreciate if anyone could advise: Main task: Back up existing SQL 2000 database and replicate a new SQL 2005 database to a remote site. Background: (1) A major application upgrade has been done using a new SQL 2005 database (at a remote site). We are ready to put the application ...more >>

When I try to connect to an sql express db on another machine, I get this message TITLE: Connect to Server ------------------------------ Cannot connect to REIDARNOTEBOOK\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a con...more >>