I am running Backup Exec which installed it's own instance of SQL. I have also installed SQL Express on the same server. They are started using the following command lines: C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC|Binn\sqlservr.exe -sBKUPEXEC and C:\Program Files\Microsoft SQL S...more >>

I'm trying to copy date from one DB on one server into a new table on a DB on another server. My syntax: SELECT * INTO [DBServer,1892].DBPublic.Databasename.tablebame as myAlias FROM myLocalDbTable For now, I'm just trying to run this in enterprise manager. I keep getting this error: ...more >>

Hi, I can't seem to find the place in the Management Studio to configure if a stored procedure will be executed when the server starts. Does anyone happen to know where to find it in the Studio or if it's removed from the GUI, and has to be done through sp_procoption now? Thanks. ...more >>

I have a table which has two fields which make up the primary key: LORD and LLINE. I want to insert records from a temp table (TWDECLTMP) if they are not in the table (TWDECL). The following where statement does not work: WHERE [dbo].[TWDECLTMP].LORD Not in (Select [dbo].[TWDECL].LORD FR...more >>

Each month, we get a table with all data for the month from a vendor. We use the data to generate reports. We have been combining the data into one larger table so we can run reports across months. Now we are close to running out of room on the hard drive. We have seperated the data and lo...more >>

I am getting an aritmetic overflow error when I try to update a smalldatetime field with the current datetime. I have tried almost every permuation of the DateTime class in C# and none of these addresses the error. What is the string format that SQl Server 2005 is expecting to see when the ...more >>

have installed this database[and accompanying log file]. followed technical directions on how to install and try to attached but get this error:-- C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\MSS\MSSQL.1\MSSQL\AdventureWorksDW_Log.LDF" is compressed but does not reside in a read-only...more >>

I have a table with following structure: Empno VarChar(10) not null StartDate DateTime not null EndDate DateTime not null Suppose I have the following sample data: 12345 01-07-2007 12-07-2007 12345 13-07-2007 18-07-2007 Because both records are for ...more >>

I have the following SQL statement: SELECT field1 FROM table1 WHERE field2=25 ORDER BY field3 This statement works fine, but the results contain duplicates, because field1 contains the same value in multiple records. I would have thought that modifying the statement with the keyword DISTIN...more >>

Well, I tried posting this in the m.p.ss.tools group, and all I got was a lot of "why aren't you using the Query Analyzer, it's so much better". So let me state right at the outset that I don't LIKE the Query Analyzer, and telling me I should try using that instead is NOT the answer I'm looki...more >>

Hello, I am having difficulty figuring out how to convert a result of a query. Here is the situation. The table (omitting the irrelevant columns): CREATE TABLE [Ticket] ( ID bigint, TrDate datetime, ExecFlag int ) I am trying to get a comparative summary of the number of tickets...more >>

Hi all I need to install Portal Server 2003 and SQL 2005 on my network. My boss asked me to install the trail version first before they decide to buy the packakge. I see there is only a SQL 2005 Server EXPRESS version that i can download and then i must upgrade to SQL 2005 Server. What is t...more >>

I have year, month, and day stored as smallints. Each in each own column. How do I get this data to a date format so I can manipulate as a date. At the end I would like to calculate a person's age by getting the difference between today's date and their date of birth Currently the database ...more >>

Hi, I need to install SQL Server Express on a low-performance PC, say 600 MHz and 480 MB RAM. I know two ways: 1) Deploying my VB.NET application: the installer download from the Internet SQL SE and begin the installation. Once completed it says "installation timeout error" and exits....more >>

I am trying to create table relationships in SQL server 2005 Express with out success. I am using Microsoft Management Sudio Express. The problem is I can see the toolbar that points to relationship, Query, Table creation but they are all greyed out. The tables I have were created by Access up...more >>

Hi, I experience the same issue of this guy: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1136124&SiteID=1 Please, does anyone know how to fix it? I use VB.NET Express and SQL Server Express. It doesn't recognize any date format in the 'Execute query' window. Thanks Marco ...more >>

What is the method of finding out what the total number of SQL Queries my server does per day? ...more >>

all, i'm trying to configure the search service for WSS 3.0 and i keep getting this, Rebuild the database with the Latin1_General_CI_AS_KS_WS collation I have googled it and they all say uninstall and reinstall SQL (2000) but if i do that wouldn't i lose all the date (some intranets have b...more >>

Hello, I imported dbf files (dbase) into an msde database. I see the tables with the data in the msde database. The data is identical. The only change made to the code is in the DSN assignment in the Recordset's GetDefaultConnect(), return _T("ODBC;DSN=themsde"). Both DSN's are ODBC, t...more >>

Hi there , I don't know where to put these questions , so i'll try here first. I'm migrating from ms access to ms sql server 2000 , but still remaining in MS access frontend. While upsizing the db , i needed to change a stored procedure (query) to APPEND data from one table to another. A...more >>

I have the following challenge: I have a table "Table1" with two columns: Column A int Column B int I am using the combination of A and B as a unique identifer. I suspect there is bug in the stored procedure, therefore, I need to find where there is a duplicate row where coulmn A and B val...more >>

I have a table with two columns that should be unqiue Column A int Column B int How would I go about writing a select statement to select where coulmn A = column B ? Case? ...more >>

Hello Everybody how can i get the lowest unique value in a column. i mean that any value that have similarities will be eliminated from calculating the minimum value. thanks in advance...more >>

Hello, i am searching for a tool that lets me monitor which statement are executed in the SQLServer. I have read in some places about a program called "sqlmonitor.exe" but i cannot find it in my SQLServer 2005 Express installation. Is that program only available in the full version of S...more >>

i am working on a search method to find a text string within a comma delimited field, like this the chipno. name (text) chipno (text) smith 123, 4567, 132000 peter 12345, 7099, 88, 10, 299 how can i search the number such as '123'? I don't like to pick up both '123...more >>

I am developing around sql server express 2005, and I have a database that I, and a few other people work on. Right now whenever someone needs to make changes, they need to go to where the database is on the server, copy it locally, attatch it, make changes, detatch, and copy it back over to th...more >>

Hello all, I'm new to SQL2005 and I seem to be missing something when it comes to performance counters and the WMI interface. Back in the day of SQL 2000 there was a set of WMI objects that I could access with performance information located in the CIMV2 namespace Win32_PerfFormattedDat...more >>

Hi guys, I have to import a .dbf to a SQL 2005 Server. Since SQL2005 doesn't support importing dbf, I tried to first open it using Excel or Access, but the problem is that the database has about 11.000.000 records... so Excel is not enough and Access seems to crash. I've been able to "l...more >>

I want to use this simple query: select distinct(date) from mytable. However, the database column contains date and the time associated hence returns me multiple records for the same date. Is there a function or some other way in which I can filter out the time and use the query only on t...more >>

Hello! I have the following table: CREATE TABLE [dbo].[image] ( [id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL , [tn] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1251_CI_AS NULL , [img] [image] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO Can anyone help me to...more >>

I have three tables of data. Table "A" is for filenames (and attributes), TABLE "B" is a keyword table that has entries for filename and keyword pairs, TABLE "C" has entries for secondary file keywords and filename pairs. I need to be able to search these tables to produce a dataset. The quer...more >>

Is that right that 3gb is the minimum for SQL Workgroup version running on a Win 32bit Server? Or is that the limited amount of memory it can use, see attached chart. Confused since higher versions say limited to OS max. http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx ...more >>

How would I store a count into a variable> I tried intCount = Select Count(*) from sometable but this doesn't work. How can I do this? Thanks. ...more >>

Looking at the differences from SQL Server Workgroup and Standard. The Workgroup states Windows on Windows for 64 bit support, the Standards says YES. What does that mean? ...more >>

Hi, Hope someone can help me. I currently use an SBS2003R2 server which has SQL2000 SP4 (Build 8.0.2039) installed. We use SQL in Exchange plus Brightstore Backup. Today we have come across a sitiation that for some reason our Microsoft Serach Service will not start, no matter what we do. ...more >>

I have this line in a select statement in a view: IIf([PriceExt]>0,[GP]/[PriceExt],0) AS [GP%] I get an error message saying that > is not recognized. I also have ! in the select statement -- I'm converting from MS Access -- and it says it does't recognize it either. What do I need to...more >>

My computer is on a Local Area Network. This network has more than 200 connection. I want to host a web site on my personal computer which should be visible over this network. I want to use Access and SQL but i know nothing about SQL. Fromewhere should i start... please guide me or give me ...more >>

Is there some article/information on How to host the Sharepoint Server 2007 DB on a seperate SQL2000 Server? I would like to run these from 2 seperate servers. Advise Please. Thank you...more >>

Hi, I work with Enterprise manager v8.0 and was wondering if it's possible to set up two DTS packages serving two different purposes and then set up a third DTS package to run them in the correct order. I tend to break apart my DTS packages in the event that something goes wrong and I ha...more >>

I'm using SQL 2000 I have these fileds in a table: DateDiff("y",[DateConfirmedShpDateReceivedTarget],GetDate()) AS DaysConfirmedReceived, DateDiff("y",[ConfirmedShpDateTarget],GetDate()) AS DaysConfirmed I'd like to add them together but this doesn't work: [DaysConfirmedReceived]+[Day...more >>

As far as I know when you purchase a license for the production server, you're allowed to use that license for a second instance for testing purposes without having to purchase additional license. Can anyone confirm or deny this? Thanks Daniel ...more >>

Hi, I am writing a series of queries that are to: 1. Read a table (table A) containing duplicate member numbers. 2. Output the member number and call date & time of latest record for each member number based on the call date & time field. So far my process declares a variable of type tab...more >>

Hi, I have a live application database in Oracle that I would like my SQL Server Express to connect to. Is this possible? If so, how to do it? Someone in another newsgroup suggested, that the feature is turened off by default, but I cant seem to find any place to turn it back on. Thanks,...more >>

I want to add data from one table to another, grouped by postcode. For some background, I want to add the data from our bookings table to our marketing table. The problem is a customer could make two bookings in any day and I only want to add their data once. Each booking has a unique key (b...more >>

I am trying to delete a database I created in SQL2005 express using SQL 2005 management studio... I get error... can not open msdb...msdb marked as suspect by SQL server 2005. I checked msdb under system databases and I see msdb marked as (Suspect) with yellow exclamation mark. What does this ...more >>

I am using a sql statement from MS Access which uses syntax like this: cboComboBox.Column(2) This is a drop down box and the data in the 3rd column is what I want to use. How can I do this in a form with SQL 2000? Thanks. ...more >>

Greetings, If the database already uploaded, anyway to delete certain users? As far as I known, deleting users will affected at least 4 tables, which is: - - aspnet_Membership - aspnet_Profile - aspnet_Users - aspnet_UsersInRoles Any table I miss out? Question How do total...more >>

Hi all, I have 2 SQL2000 servers, they will be some kind of replicas... let me try to explain the situation : The first server is the master, the second will be a subset of the first, ... namely : (for the second server) some tables not needed totally and some tables have some un-wanted dat...more >>

I'm getting an error that says I have an invalid sql statement: Here's the statement: SELECT * FROM dbo.vwTmpQuery3 WHERE (CNME = N 'ACE HARDWARE-TW') What do I need to change? Thanks! ...more >>