This updates a previous post. We have updated our SQL Server 2000 to new hardware by reinstalling SQL Server 2K to a new, dual processor server. We performed a full SQL backup of the entire server, and did a full restore onto the new hardware, which has the same server name and IP address. O...more >>

Hello, I'm facing with a problem though it may look very simple for many of u it is a bit complicated for me So kindly please help me out i have a table emp with employee id,name and mgrid I need to display the managers and the employee working under that manager . How should this be do...more >>

Hello, I have a database in 2005 that I'd like to copy and attach in 2000. Is this possible? if so, how do I do it? I've tried doing a number of things from just trying to attach to the db file to trying to export and import via access and I can't seem to get anything to work. Any hel...more >>

Hello, I have a Win2K3 Server with SS2005 developers edition. I am working on a Windows XP Pro workstation which has SQL Server 2000 installed as well as the SQL Native Client. I'm using an MS Access ADP to connect to the server and for some reason it's extremely slow, even to the point o...more >>

I have a large query that I am trying to debug in query analyzer. However, the errors I get have no line number or reference to where they are failing. How can I find out what line in the query is causing a particular error message to appear? Thanks John Ivey South Pike School District ...more >>

Hello, I'm new to SQL Server, have alot of experience with DB2 and Oracle, and have been tasked with supporting SQL Server. Could anyone suggest a good administrator book? Thanks!! Dave Schaeffer ...more >>

Hi to all, Probably I'm just doing something stupid, but I would like you to tell me that (if it is so), and point the solution. There ist the thing: I' having a sp, where I call other sp inside. The only problem is, the name of this inside sp is builded variously, and executed over sp_e...more >>

hi, I wish to create a temporary table who's name is dynamic based on the argument. ALTER PROCEDURE [dbo].[generateTicketTable] @PID1 VARCHAR(50), @PID2 VARCHAR(50), @TICKET VARCHAR(20) AS BEGIN SET NOCOUNT ON; DECLARE @DATA XML SET @DATA = (SELECT dbo.getHistoryLocation...more >>

Actually, I don't know what is the meaning and difference of "N" in the function. Thanks. ...more >>

Always wondered, now I have the time to ask - we currently backup ALL databases and these seem to all grow in size, the MSDB BAK files are now 35mb each and growing!!! Can we remove these from our Enterprise Manager? - Master - Model - MSDB Cheers, @sh ...more >>

compare to ms sql 2000, the newer version seems to be slow when i try to open or modify a table. is this a demerit of the newer vesion or my machine problem? ...more >>

I have Visual Studio Tools for Office (VSTO) and the SS 2005 Developer that comes with it, all of which I can install on my local XP box. 1. Which one do I install first, VSTO or SS 2005 Developer?? 2. Regardless of which one is installed first, what's the best way after that to move or copy...more >>

Can anyone refer me to good 'recipes' or sources of information on this topic?? I have Visual Studio Tools for Office, which installs SS 2005 Express locally to my XP box, and I want to develop in SS 2005, then copy the tables or queries or reports etc. to a SS 2005 Standard server. Thank y...more >>

I have a production failover cluster running SQL Server 2000 at SP3 that I want to upgrade to SP4. I do not have a test failover cluster to test with so I need the install on the primary server to work the first time. Per the information I have I just install the patch on the primary server an...more >>

Hi, Looking for a quick and dirty on running an Access database as a linked server in SQL Server. Basically, the majority of my stuff is in SQL Server, but there is one lingering nightmare-of-an-Access-database no one wants to touch. I just want to create a linked server to use the Access ...more >>

How about backup with MSDE? is there some utility for it? tnx...more >>

I'm sure you all have seen situations where a field has a combined name in the format of "Lastname, Firstname Middlename" and I've seen examples of parsing that type of field. But what happens when the data within this type of field is inconsistent? Here are some examples Apple, John A. Ber...more >>

Does enabling/disabling Data Execution Prevention have a performance impact on SQL 2000 or SQL 2005? For SQL best performance - how should I configure for: Processor Scheduling: Programs or Background services Memory Usage: Programs or System Cache ...more >>

Hello Does anybody know where/if MSSQL (especially 2005) keeps logs of creating and deleteing jobs? Thanks in advance Bartolo ...more >>

This is the Trigger which is not working properly during Update, no any record is going to be updated so pls help. I am updating the requisition table when any update in quantity in podetails table CREATE TRIGGER trig_updateRequistion ON ERP.DBO.TranPurchaseOrderDetail INSTEAD OF UPDATE...more >>

Is there any difference between a nText field value='' and value=NULL ? ...more >>

hi, i have developed a web application. i need to connect to sqlserver 2000 to fetch data and i am getting the following error when requested for login page. Login failed for user 'NT AUTHORITY\NETWORK SERVICE' When i refresh the page it is working properly, i.e., i could see the login sc...more >>

I'm trying to import data from flat file in table and have few problems. 1. Field Delimiter is ',' (comma). If ',' occurs in quoted string it is still treated as field delimiter. This is BUG or ? 2. In table I have datetime field that can be null, but bulk insert reports error if in flat fil...more >>

Hi! I have some problems with ms sql server database connection. When I wrote the following function (in VB): sub Remplir_Theme() Dim connectionString As String =3D "Data Source=3D.\SQLExpress; AttachDbFileName=3D|DataDirectory|\BasedeDonnees_babySQL.mdf ;Integrated Security=3Dtrue; User In...more >>

Hi, I'm trying to figure out a way to compare two tables, table one has more entries than table two, I want SQL to compare table one to table two and spit out and XLS of the enries that exist in table one, but not in table two. So far I can't even get my query right...heh select * fro...more >>

Dear Experts, I would like to invite you to take part of my survey to share your expertise on the storage usage for enterprise applications. This is an educational survey for non-profit purposes, and it will be a part of my Master's dissertation. The following survey contains 14 questions...more >>

Hello, I've written an insert trigger to fill in data on 5 columns based on the key field column after a record is added to a table. The trigger works fine. But what I also want to do is to write a stored procedure that will update the 5 columns for the entire table based on the table key ...more >>

Using SQL Server 2000 and moving to a new computer. We did a full backup of the existing database to tape, brought up the new computer with a clean install using the same server name and IP address, and did a full restore. Not only were some permissions messed up, but Crystal Reports 10 and some...more >>

I have a file I'm trying to do some non-set-based processing with. In order to make sure I keep the order of the results, I want to BULK INSERT into a temp table with an identity column. The spec says that you should be able to use either KEEPIDENTITY or KEEPNULLS, but I can't get it to work. ...more >>

I just read that if you use an exchange server...the account that you start SQL with needs a mail on the exchange box. Is this true? I know I didn't need an account when I've set it up before...but I might have been using a POP3 server. I have Outlook 2003 installed on the server. Window...more >>

I was just messing around with some ad hoc views and table returning UDFs today so I could look at and print out data from a small table and noticed something strange. If I stick my select statement into a View the columns are returned in the order I specify in the SELECT, but if the same st...more >>

Hi all, I was given a task to create a houseHolding logic under a table that have millions records. first let me explain what is a house holding: let's say I have 2 records that have the same phone number, that mean that both records are under the same household, but this can get more compli...more >>

Hello, If I create a table with two columns of type "Text" will that cause any issues? If my memory serves me correctly I thought I read a while back that is it standard practice to only have one "Text" column per table. Any input would be appreciated. Thanks, Rob Panosh ...more >>

I have an existing table that i would like to add a uniquidentifier to each record of the table. I have already create a column for the uniqueid. What sql script could I run to actually place a value for the newly created column for each record? thanks for your help ahead of time ...more >>

Hi I have trouble with MSSQL2000 SP4 (without any hotfixes). During last two weeks it start works anormally. After last optimalization (about few months ago) it works good (fast, without blocks). Its buffer cache hit ratio was about 99.7-99.8. Last day it starts work slow, there was many block...more >>