SQL2005. New installation as a named instance on a local machine. Attached a database previously designed in SQL2000. My app calls for this database using integrated security. With SQL2000, no problems connecting and executing code against the db, including stored procedures. But with 2005...more >>

We get a old SQL 2000 server (with SP2). We are moving to a new server (HP DL380 with 2 Xeon 3.0 CPU, 1G RAM), SQL 2000 SP4 installed. We are doing some performance testing on the new server and found the followings, (1) Select statement takes about same speed on both servers. (2) Insert and...more >>

I thought it would be easy enough to change the start up locations for my server from EM database properties... WRONG!! I made the changes, stopped the SQL service, Moved the Data and log files (MDF and LDFs), then tried to restart the server and it fails to start. I tried to restart in sin...more >>

Hi What is de diferents beetwen non-leaf-level pages and leaf-level pages? Thanks Best Regards Cesar ...more >>

Running SQL Server 2000 - patched up to date, behind firewall, on Win2003 Server, using MacAfee VirusScan Enterprise Over the lunchtime, we seem to have lost several databases from a couple of server groups on our server! It appears no-one was working on the server at the time. Does any...more >>

I'm relatively new to SQL stored procedures...coming from Oracle world. I am writing stored procedures and I am trying to write "Exception Handling". In oracle, there were "predefined errors" that you could "catch", such as "Dup_Val_ON_INDEX" or "No Data Found". Is there a list of pre-establish...more >>

Hello Friends, I have been thinking of writing Stored procs in SQL CLR/ changing all of my Stored Procs to SQL CLR. Is there any thing that I need to keep in mind about the size of the sotred proc (like calculation intensive) before I do that? I mean can even change a TSQL stored proc whi...more >>

Hi All, I am trying to create maintenance plan for updating statistics, checking database integrity and database backup, using wizard. First of all, I don't see any option for how long do I want to keep backup files on the system (like we had on 2000). I find it very inconvinient. Is there an...more >>

I need help with an odd request. I have been asked to create a view price list that includes the price each customer will pay for any product. ProductID, customerID, and price is all I really need. Our rules for figuring out who pays what, is somewhat complex, and I would prefer to avoid curs...more >>

hello Table T1 has T1: MyID, MyDate1, MyNote1, MyCharge1, MyDate2,MyNote2, MyCharge2 How can I write my view to report these in MyID, MyDate1, MyNote1, MyCharge1 MyID, MyDate2,MyNote2, MyCharge2 format? ...more >>

I have a stored proc which receives a @k nchar(1) as parameter then I do two selects based on that value (SELECT ... WHERE kanji = @k) I'd like to know if it's worth it to add a select before these two ones : SELECT kanji_id WHERE kanji = @k and then base my two next selects on the id...more >>

I had a database called 'ENDesktop10Temp' in MSDE 2000. I restored it without problems into SQL Server 2005 Express. When I tried to backup the database from 2005 Express using either the Enterprise manager/SQL DMO/SMO, etc. I kept getting the following error -----------------------------...more >>

Hi, What are the advantage and disadvantage of 'WITH ENCRYPTION'. We have a few SQL 2000 machines with vendor bought software. Some development happens on the various application. Thanks, Stoney...more >>

setting up a new ibm xserve server. The SCSI serveRAID controller says to use 16kb stripe for generic "transaction processing database" (not sql server specific). but the IBM SQL server 2005 on xserve guide says to use 64kb stripes. posts I have seen say to use scsi controller defaults unles...more >>

I have a query that when executed against the host server, it completes in 11 seconds. When I execute the same query against a linked server it takes 100 seconds to run. I have checked the execution plan for the linked server query and it shows that 100% of the cost is the Remote Query. The...more >>

What would be the optimal max server memory setting for the following machine? Dedicated SQL Server: Intel Xeon MP 3.3 GHz (4 physical Processors) 136 GB (C Drive) 8.0 GB RAM Microsoft Windows 2003 Enterprise Edition Service Pack 1 Build 3790 SQL Server Enterprise 2000, with SP3 T...more >>

On a production server, I do a full backup monthly and then delete data from the tables that is older than the current date. On a separate non-production server I restored the initial full backup. My question is how can I add/restore the subsequent backups to the non-production server with out...more >>

Hello, Using SQL 2000 and need to choose a good backup solution. I'm aware that SQL has its own backup utility, but what about 3rd party backups solutions? My main choices seem to be Backupexec 10D or Arcserv 11. Can anyone sugget which is maybe a better solution for backing up SQL? ...more >>

Hi, I'm confused with what's being reported by SQL Server for the date of a transacation log backup. The backup had been taken on Jun 29, 2006, 12:14:20 p.m. This can be seen in the Archive SQL Server Logs. However, when I double-click that entry, I get the following result: Log backe...more >>

I am getting error when installing SQL server 2K Developer Ed in Win XP. It shows “An error occurred while creating one or more registry entries. The problem could be caused by a low registry quota”. Hope some one can give me some hints. Thanks, Elton ...more >>

Apparently one of my users lost their ODBC drivers for SQL Server. When I try to run the program that uses those drivers obviously I get all kind of errors. I tried going into the ODBC administrator and when I try to edit or delete the DSN I get a message about the drivers being missing and I ...more >>

I am looking for the Microsoft SQL Server 2000 books on line (BOL) website link that I can display the latest copy this program. Thanks, ...more >>

Hi Onibuzz, One month ago i have posted one topic on microsoft.public.sqlserver.programming group and u have posted a reply to it. Your reply was a great help to me but i am stuck with another small issue in the same query. I would greatly appreciate if you help me in finding the solution. ...more >>

hi all, i'm just SQLDMO newbie and need some help. i was wondering if i can use SQLDMO to do the following: 1- set a new password (change) sa password 2- delete any db accounts 3- add new db accounts 4- change startup accounts for sql services i'll appreciate it so much if anybody c...more >>

I want to analyze what statemetns were executed in stored procedures, for example. I'm trying hard to find tools for sql code coverage while there are tons of such tools for Java or C#. I was able to find only : http://www.sqlpower.com/dsa.html but I want to compare it with other solutions. ...more >>

Hi, Does anybody know if xp_sendmail & xp_readmail still exist in new SS 2005? I cannot find any info about them in BOL 2005. Thanks in advance Nikola ...more >>

Hello, I am searching how to use in osql scripts logins names containing '\' caharcter. Theses login are automatically created they contain a domain name fowwed by a group name. Thanks for help. CS ...more >>

Hi there My SQL server backups are running as nicely as they used to. Recently I got the following error: Message: The job failed. The owner () of job DB Backup Job for DB Maintenance Plan 'Daily Backup1' does not have server access. I'm not much of an SQL admin so I wasn't quite sure ho...more >>

Hello, just got SQL Server 2005 installed on a new production box and am trying desperately to get data to it from an old SQL2000 production box - unfortunately for me each time i try to use the copy database tools in order to copy the database i get to the step where i am to "configure the pa...more >>