that's it - I have a varchar(10) field (not null) which I need to add an UNIQUE constraint to but I don't know how to? ...more >>

i try to copy a database to a laptop when i use RESTORE i get the error: "Too many backup devices specified for backup or restore; only 64 are allowed" when i use ATTACH i get the error: "Could not find row in sysindexes for database ID ..... Run DBCC CHECKTABLE on sysindexes. " so how can ...more >>

I would like to restore the master database from "Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)" which is running on W2K to "Microsoft SQL Server 2000 - 8.0...more >>

Hi, I'm trying to get to the provider options screen in SQL2K5 Management Studio, however I am unable to find it anywhere. This is really frustrating... Here is what I am trying to do: 1.. In SQL Mgmt Studio, connect to the SQL Server Database Engine and go to Server Objects->Linked Serve...more >>

Hi. I've been having issues with my MSSQL2000 installation's backup system. Here's what My script looks like. These three steps execute nightly at 11pm. backup database RXSQL to RXSQL_Backup with init backup Log RXSQL WITH TRUNCATE_ONLY DBCC SHRINKDATABASE (RXSQL, TRUNCATEONLY) And t...more >>

Hi. Can I restore to database MyTempDB from database MyProductionDB's backup and log files while MyProductionDB has active users? Thanks. ...more >>

Hi all. I have had to rebuilt our w2k3 server with sql2000 sp3. The o/s is fine and I have installed sql. Now when I try to restore the data from tape through enterprise manager the restore from tape option is grey out. I have tested the drive and restore other files from tape all fine (HP ...more >>

I have a table named Addressbook with fields: ID int Name nvarchar I want to change the type of ID to: int IDENTITY 1,1 Is there any way to do it from SQL Query Analyzer? Thanks Dimitris ...more >>

A mistake was made and "old" transaction logs (and old backups) were deleted. It appears that a long living transaction was living in one of those logs. Now the EP shows (no items). The DBs themselves are still functioning OK, just the EP shell that's not working. What's the proper resolution?...more >>

I am writing a dotnet app that needs to connect to SQL 2000. I have used the imports system.data.SqlClient. I have tried everything I can think of but I constantly get an error when it tries to connect to the server. "An error has occurred while establishing a connection to the server. (pro...more >>

When I run 'select * from master.dbo.sysprocesses' in Query Analyzer I get all the expected columns. If I run this from a program then I cannot see certain columns, like hostname. I'm connecting using the sa user id. I'm guessing some columns are restricted somehow for security reasons. Does ...more >>

I notice that SQL 2000 has a datatype of image. My question is after I setup the table and fields how do I populate the table with image data? ...more >>

Hi I downloaded Sql Server 2005 Express last year (or year before). I thnk it was the beta version. Anyway, do I need to update or how do I update or should I download the latest version? Many thanks in advance Richard ...more >>

Best practices to get a db backup to another server. I've got as far as working with an ActiveX task Workflow to use an FSO, but I'm stalled at doing a date comparison to get the latest backup copied. I had tried to simply copy the one and only backup file in a folder to the other server and...more >>

My impression was that logs grow until a backup or maintenance is done, then they shrink way down. I am using Shavlik NetChk (a patch scanner/deployer program) on Server 2003 w/SP1 using SQL 2005 w/SP1. The performance is suffering, and, I checked the file sizes and while the mdf filesiz...more >>

Hi, I wish to change the location of the database files during installation to another array/partition. How do I do this? I can't seem to change the data directory like I could in 2000. This would also be useful for a SQL Server Express install I am doing. Thanks. Andrew. -- Andrew...more >>

HI all.. I have *some* familiarity with SQL server 2000... but am stuck. I have TableA and TableB .. both with a common field called Company_Name. I need to select all Company_Name values from both tables, and built it into a list to be used for a View. I'm told that Temp tables might help m...more >>

I have an nvarchar field that stores a username, is there a way to make the field case sensitive ? A ...more >>

Is there a way within SQL to create a query with carriage returns within the output, so that the whole query is not all on one line? For example Instead of having "Make, Mode, Time , Date, etc." Return something like this: Make, Mode Time, Date Etc.. ...more >>

When I try to start the SQL Server Agent I am getting this error. [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started) Thsi is very frustrating and i cant put up the DB until im sure that I can have my backups working. Anyone kn...more >>

I have a list of addresses in MSSQL table, some of which appear twice, which is intentional/required. We want to display a list of addresses, but be able to group them into one table so that there are no repeats. It seems that we can only select one field at present when using the GROUP comm...more >>

Is there a way to Reference an alias field name in an SQL Statement? Example: Select 1 + 1 AS F1, F1 + 1 AS F2 ...more >>

Hi there I am using the following statement to calculate percentile ranks of a set of scores in quite a large table (400k rows). The tempdb file grows dramatically (to 40GB+) and the query never reaches a conclusion. Surely I'm doing something wrong?! (This is actually part of a broader calcu...more >>

Hi, I've used MySQL for years so I'm actually pretty good with SQL (or at least the MySQL flavor of it). I've recently been put in charge of a MS- 2005 Server project. I've been looking for examples for a really basic query but I can't find any. Anyway, here's what I need to do. SELEC...more >>

hi i am working on Windows 2000 Advanced Server + SP4 and SQL2000 Enterprise + SP4. i have database contains Tables, and i want make script to build Tables on other Database, but i need this script include Data in Tables too, i can make that ? and how? thanks -- Tarek M. Siala ...more >>

Greetings I have a SQL server that is used as a backup type of device. The server is only accessed by other servers(exchange, docsopen, anti spam etc.), not by the end users. The typical full transaction log/low disk space errors are now becoming more of a burden. I have a very basic w...more >>

-- which is best?... -- (I'm using SQL Server 2005) -- setting transaction per table CREATE TRIGGER trMyTrigger ON tbTable INSTEAD OF INSERT AS BEGIN -- PRODUCTS BEGIN TRANSACTION UPDATE tbProducts SET prodName = 'abc' INSERT tbProducts SELECT prodName FROM INSERTED COMMIT TRA...more >>

SET NOCOUNT ON declare @tab table(vc varchar(2000)) insert into @tab select '10.1' insert into @tab select '10.1.1' insert into @tab select '10.1.2' insert into @tab select '10.1.1.1' insert into @tab select '10.1.1.1.1' The problem is that i need to select only 10.1.1 and 10.1.2 when i ...more >>

Is it possible to put more than one Transact-SQL statement in a single line? I mean lines of statements in scripts such as for Query Analyzer. I think I saw that being done when I looked at sample scripts to get help with other things, but since I seldom put more than one statement in a line,...more >>

It doesnt start because it says the Event Log has not been started. Windows Event Log is started and working fine, is there another one ? I don't have a clue what to do and need to start the Agent or my backups won't work. I noticed someone has had the same issue but found no solutions. A...more >>

Regards, I'm installing SP1 for SQL 2005 for the first time in the lab and receive the following error whether I use Windows or SQL authentication. this is a healthy AD environment (according to MOM 2005 and my logs). Any thoughts on what I may be doing wrong? My error: ----------...more >>

MSDE has a connection limit (as far as i remember, you can't open more than 20 connections at the same time) but other editions of SQL 2000 has no limit for opening connections. Is there a limit for how many connections can be opened to SQL 2005 Express edition at the same time. ...more >>

Hi. I need to know how to create a maintenance plan in express 2005 with an automatic full backup type. I have been told that with express 2005 the wizzard to do that it´s not available. What can I do? Thanks José ...more >>

I am trying to backup/restore a database from SQL Server Express 2005 to SQL Server 2000, and receive the following error when attempting the restore: Error 3169: The backed up database uses version 611, the server supports version 539 and cannot restore or upgrade this database. I read in a...more >>

Hello, I have a table (T1) that has a field that holds a date with a time. In another table (T2) I have records related to T1 on an ID field (one T1 to many T2). T2 has a date field also, but this field does not have time (ie the time part is midnight). I want to join the two tables o...more >>

I have SQL Server 2000 installed which has a server name of NOTEBOOKDELL. I installed SQL Server 2005 Community Technology Review last October, 2005, and somehow gave it a server name of NOTEBOOKDELL\SQL2005 so that I can keep my SQL Server 2005 databases separate. All was well until I...more >>

hi, I'm using Yukon as backend for my web. I'm a little concerned of all the amount of records I'm making it keep... It records every session and user login which means for each day there will be about 500 new records created. Which are 15000 records over a month and 180.000 records over a ye...more >>

An error was encountered while attempting to browse the contents of <servername>. A network connection to the server could not be established Hi Above error received with backp exec 10d on w2k3 server with sql2005. Error received when trying to select Microsoft SQL server within backup s...more >>

Hi i am new to sqlserver family. In Oracle we have CONNECT BY & PRIOR clause is there any simillar function in SQLSERVER (2000 & 2005) , if not who can i achive this . Any examples will be quite helpfull thanks in adv thirumaran...more >>