Hi, We let our users through a simple dialog create view columns, like "Price/Qty". Is there a general way to get nulls in all cells where division by 0 appear instead of using the more complicated CASE everywhere in formulas ... I've tried to SET ARITHIGNORE ON before running the view...more >>

Hi, I've 2 SQL Server, SQL1 as Primary and SQL2 as Stand-By Server. Database size is about 5 GB. I want to restore full and T-logs on SQL2, so my SQL1 Recovery model is set to Full. As I don't have off-peak hours, I can not detach/attach database and move it to SQL2. once a day, I need to...more >>

I'm wanting to make a database that stores all the installed software on each machine in our domain. I want to be able search for a specific software and it return all the machines its installed on. Plus list all install software for a selected pc. How would I go about designing this?...more >>

I am running SQL Server 2000 and must sort on an alphanumeric field. There is no pattern consistency for the values in the column (let's call it FILENUM varchar(30)). I am having a difficult time coming up with a solution. Given a set of filenumbers: 1dd 1 1x4 1cc2 1110-345-720a3 11 ...more >>

Hi, I am using SQLDMO in my application to create data tables, full-text catalogs and jobs to populate the catalogs. My datatables are created successfully but I get error on line where it says : Dim oSQLServer as SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServer I have added reference...more >>

I am installing a 2nd instance of SQL 2000 to our existing development server. Do I need to stop the existing/default instance that is running prior to the install and will the 2nd install need the server to be re-booted? thanks Meenal ...more >>

Hi ~ I realize that this has been posted on, but I am confused. We are getting an error in our event logs at odd times (not at backup times or anything) with the infamous Error: 17883, Severity: 1, State: 0 Process 0:0 (e54) UMS Context 0x121CA9A0 appears to be non-yielding on Scheduler 3, o...more >>

Hi experts We have server with 2 cpu PIII 1.GHz, host for an application and its database. Recently the performance has been slow and after monitoring only cpu % processor time counter showed 50-60% for one instance and 20-30 % for second inst. memory and disks counters are ok for me. Sql s...more >>

I'm not sure how to ask this, but I'll try my best. I have 4 tables, which are related to each other. In table sites, I have a record (site_id = 1). This record gets assigned a vendor by the following process. 1. The users table gets an entry (user_id = 1) 2. The vendors table gets an entry ...more >>

When a database on my server was created (I'm the new admin of an existing SQL server) 14G of memory was allocated for the Transaction Log File. The log file is only 2G and I would like to remove all that extra free space as we are having server space issues. I already shrunk the file, so tha...more >>

hi i am looking for some advice on how to move a database from a stand alone sql server to a clustered sql server. i tried the copy db wizard, it failed with a meaningless error i tried to do a backup and restore and that works only if i restore it to the t: drive, i can't specify a dif...more >>

Is it absolutely necessary to have primary key’s on every table. I have several examples in a db where the logical choice for a pk is never used in joins, where clauses, or order by clauses. I would like to create a clustered index on these tables but not necessarily a primary key. Anyone...more >>

Hi, In SQL 2k I have a log file of 277.99 MB with space used 57 MB and I'm trying to shrink it and it doesn't, Any suggestions? ...more >>

I need help, I can someone please let me know how can I save a file from the sql to another drive or directory....more >>

I am migrating Sybase databases to SQL 2000. For the most part I am using a Microsoft tool named 'Sybase Migration Wizard'. It really a DTS tool. The problem that I'm running into is that the size of the databases are 3, 4 or more times bigger in SQL then they where in Sybase. The database th...more >>

Hello, I'm trying to join results from two tables and still don't understand why the following statement doesn't work: SELECT rating FROM (SELECT DISTINCT TOP 10 bp.rating, bp2.Cnt FROM businesspartners bp INNER JOIN ...more >>

HI all, i m using sql server 2000 with sp3 and around 10 to 12 users connect to it at a time users are telling it almost take 5 to 10 minutes to show the database list and so on ... for next things. my sql server is running on old hp server c...more >>

I am getting a deadlock message and it is referencing the following: SPID: 192 ECID: 0 Statement Type: DELETE Line #: 77 When I execute a sp_helptext on the SP in question - there are 4 delete statements but none of these are on line 77 of the sp_helptext output. In fact line # 77 of the sp_h...more >>

Hey all that I want is to be able to run from another DB. This "sp_MShelpindex" like the "indexkey_property" only work running from the DB where the index sits. I need to join this information from multiple DBs in a single query, and I was wondering if (and how) this is possible. Thanks ...more >>

Hi all, Question about creating a linked servers in SQL 2000: We have a few different database servers ... let's call them ServerA, ServerB, and ServerZ. ServerZ is a remote standby server that contains standby databases for databases on ServerA and ServerB. ServerZ is on a network tha...more >>

Hi all! Does anyone know a method to avoid Tlog Backups during full backups? I've some backups that running during 2 hours and my tlogs running every 15 minutes so my tlogs become blocked during that, i want a method to avoid tlogs running during the full backup, since i've a lot of db's and...more >>

We wish to look into setting up a mirrored server at another site in case we lose access to our head office. The company is based in London, fairly near potential bomb targets etc. There are three other locations, one having a 4GB leased line to head office. Assuming we are not going to jum...more >>

Dear all, i have server wihch is running sql server and users are using it . now i want to change the server name . if i change server name sql server name will remain or not ? if i...more >>

I'm trying to find out if there are performance penalties running SQL2000 in WOW in Windows 2003 x64 Enterprise Server. Microsoft's pre-sales team has given me useless information. Does anyone know the answer to this question? Thank you! ...more >>

When I make a new database the Guest account is not created. It also does not exist in Logins under Security | Logins in the Enterprise Manager. It does exist in all the databases that were created by various install programs. How do I fix this? -- George Hester __________________________...more >>

Hello, I created a Maintenance plan and the only thing I have it do is perform an Integrity Check on the database. It's been running successfully for 2 years. I recently Added Replication to this server, having the data from this server replicated onto a backup server. During that setup,...more >>

I am doing a row update in a table and the text contains a ' character, just wondering how to do this? for example UPDATE table SET field2 = 'text to enter to table's but does not work' WHERE field1 = 133 the second apostrophy I want to not end the text section with. Thanks. -- Paul G...more >>

I need to write a DDL Create script for a table in TempDb. In Query Analyzer, I can see the table, but when I right click on the table and attempt to script the Create I get a message telling that it could not find the object in the collection (and it suggests I may want to use qualifiers)....more >>

I have configured log shipping. I want to add a user for reporting purpose in the secondary server ,but the database on secondary server is in read only - warm stand by mode. How can I add a user in the database which is configured for log shippng. Is there any way so that I can stop log shippi...more >>

This is probably an easy one for those experienced gurus out there... I am attempting to write a stored procedure which will be the record source for a form in MS Access Project. This works fine: CREATE PROCEDURE dbo.spHSITES_LNlookup @LastName nvarchar(50) AS If @LastName = 'all' ...more >>

I'm trying to e-mail the results of a trigger that fires on an employee table. I'm trying to included the results of either the DELETED or INSERTED tables, but nothing is returned. Can xp_sendmail include DELETED or INSERTED table queries in the @query = parameter? I'm trying to send an e...more >>

I have made a table with a field of type datetime which stores the time. My problem is I want to display the time as 10:00AM while it stores as 10:00:00 AM. Is it at all possible in SQL server to store it as 10:00 AM if not how do we display it as 10:00 AM. Thanks,...more >>

I am attempting to restore from a .bak file located on a network share. I am using the 'Restore Database' wizard in EM. The db size is 110 Gigs After approximately 4 hours the process fails. Error message: --------------------------- Microsoft SQL-DMO (ODBC SQLState: 42000) ----------...more >>

Why does this Stored Procedure delete all rows? \\ SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE dbo.usp_DeleteCylnMotionSensor_B ( @fkDevice char(36), @cmVarchar06 varchar(50) )AS SET NOCOUNT ON; DELETE tbl040Cmpt FROM (SELECT TOP 1 * FROM tbl040Cmpt) AS ...more >>

I am using a remote connection to connect to a specific server (13B) and I am running a trace from there against another server (138). I have a template to track performance points and am saving the results to a table. My problem is that when I run this trace, I also am creating a very large s...more >>

Hi I have Sql2000 Server , i want to change the @@version. Can i change the result of SELECT @@version ? Where can i do this ? -- Paul...more >>

Dear Guru, How to modify the template.ini in order to install SQL 2005 to a custom location? By using splash.hta GUI installation wizard, all the files will be installed under the default <%program files%> even I specified the installation path. Next, I used the following command ...more >>

There are still a few obsolete databases showing in the SQL restore panel in the field "Show backups of database". Properly when someone drop the obsolete databases without selecting "delete backup history". How can I get rid of the database names in the backup history ? SQL : SQL Serve...more >>

Hi, My app (VB.NET, .NET Framework 1.1) intalls database tables for a database. Then it is supposed to create full-text catalogs. It works well on my machine but not on another machine. here is error message I get: An unhandled exception of type 'System.Runtime.InteropServices.COMExcepti...more >>

What is the use of running the command "CREATE STATISTICS"? SQL 2K. Thanks, Harry ...more >>

I've looked but I can't find. Is there a way to get the windows login name in TSQL? Also I would like the workstation name (computer name). The software we use doesn't use a separate login name for each user, so everyone is actually logging in using the same database login, but I need some wa...more >>

How can you login to a Windows-auth-only SQLServer from a VPN? Since you login to Windows locally, you aren't authenticated to the domain. For shares, you get around this by authenticating to the domain for each share. But how about SQL Server? There doesn't seem to be a way to do this. I've t...more >>

The more CPUs I assign to SQL Server the worse the application gets. The hardware has 2 Gig of memory, Raid-5, 2 CPU each with HT technology. I run 6 threads each was doing the same query to check for scalability and load. As I start to add CPUs the worse and more sporadic the numbers become. ...more >>

We have 4 CPU 8GB Dell server running SQL2k Enterprise on Windows 2003 Enterprise. What will be the effect on SQL server performance if we add more CPUs ? Are there any calulations (or numbers available) we can do to determine the effect of additional CPUs on SQLl server performace ( no of...more >>

sql2k sp3 Ive always used Linked Servers and as such dont really know about Remote Servers. Anyways, here is the deal. Box1 -- Replication Publisher. Has a Remote Server defined for Box2, which is a Subscriber to Box1. So, Im trying to exec a proc on Box2 while logged on to Box1 while...more >>

Dear All, I have a receiving application. The app works like below: 1. The operator must key in the delivery notes of the truck at the receiving offices 2. The operator scans each items within a truck at the warehouse. After finish unloading the items of one delivery notes (of truck), I ...more >>

Hi, i want to permit a user to create tables and only drop the tables that he creates. With db_ddladmin he can drop any table, but i want than he can only drop the tables that he create. What i can do??...more >>

I see an application DiagnosticMan in the Process Info of Current Activity in SQL Server 2000. Does anyone know what it is? Thanks, Peter...more >>

Hi friends! I have a new hardware to migrate all databases, engine, jobs, maintenance plans, dblinks and so on. I will install this server With Win2003, SQL2000 SP3, like the old server. So, the question is, what is the best way to move all the 'SQL Architecture' from one server to the oth...more >>

Hi all, Sorry for the frequent posts, but I have one other thing I'd like to figure out. Can I write a query to determine if a database is in standby or read-only mode? I would like to put a check in the restore routine for custom log shipping so that DIFFs and TRANS are restored when n...more >>