Hi, Can anyone point me in the right direction for creating link tables in SQL 2000 standard edition? I want to link to tables in a Intersystems Cache database. Thanks in advance, SW ...more >>

Hi, I want to set up log shipping. I have SQL 2000 Standard edition running on two instances of SQL server running on the same machine. If I installed SQL server 2000 Enterprise edition on another machine, I'd be able to take advantage of built-in log shipping functionality and it would be...more >>

Hi, I have used an access table to create a chart report to show how many calls were handled in a month. How do i conver the Access sql to MS sql server view. Here is the access sql: SELECT (Format([ComplaintDate],"mmm"" '""yy")) AS Expr1, Count(*) AS [Count] FROM [Complaints] GROUP BY (Fo...more >>

How to connect users to sql server in a small net where users are connected to one of the PC's and there is no server machine? thanks ...more >>

hi, is there a way to find all stored procs in a database and the date they were updated? Also can I query some "master" table to find when the table schemas were last updated? This because I'm trying to synchronise a project I'm working on locally and remotely at the same time... thx ...more >>

I moved a database from one server to another. After doing so, someone told me that the data files need to be moved to a secondary disk. I'm needing to know how to change SQL Server so that all of it's database files are located somewhere besides the default location. How do I do this? I w...more >>

Hi, Here is the problem: I need to get all rows from TableA where TableB.Nbr is 5 and 10 (and 15). Example here: TableA ====== Id, Title 01, Row1 02, Row2 03, Row3 Tables are related with Id and AId. TableB ====== Id, AId, Nbr 01, 01, 5 02, 01, 10 03, 01, 15...more >>

Hi NG! I have to migrate an Access Backend-DB (all the tables and relations) to SQL-Server 2005. With SQL-Server 2000 came DTS for problems like this. Is there anything like DTS in SQL-Server 2005? Thanks for helping! Greetings from Austria Helmut ...more >>

Environment: VS2005 C#, SQL Server 2005 I have a routine that accepts an XML doc, creates a connection to the database, calls sp_setapprole as a stored procedure, inserts two rows after deserializing the XML, and then closes/disposes of the connection and the command used to insert the reco...more >>

Hi, I kida work out this sql, which gives me 2 values that I need: Select b.maidennm, b.userid, b.EID, MAX(a.id) as addressid from addresses a inner join users as b on a.userid = b.userid where b.firmid = 2 and usertype = 'employer' GROUP BY b.maidennm, b.userid, b.EID order by b.ma...more >>

Hi, I made a form where visitors can introduce data. I use this: strsql="INSERT INTO mytable (field1,field2 ...) values('" & lol & "',#" & dat & ...)" My problem is that when someone introduces a quotation mark, i get a error and the insert fails (e.g. nam'e). How can i prevent that? Co...more >>

Good night, I have the sql below, might be an easy one but I can't find my way around it. This displays all addresses for a given user, you will see there is an INNER JOIN, the thing is this is a one to multiple relationship and some clients have multiple addresses, when that is the case I ...more >>

err... is there something like "defragmenting" a database like we do with file system? My idea that after lots of ALTER TABLEs, ALTER COLUMNs, updates, inserts and deletes some master table could be irregularily scheduled because I notice the sql server is starting to work slower with the da...more >>

I have a server with an existing set of databases. We have a new server that we'll be migrating to and so what I'd like to do is get at least one database copied over to the new machine so I can do some testing. The problem is, the two machines have little or no network connectivity currentl...more >>

hi, I recently migrated a database from an old server to a new one. however, one of the tables didn't copy over all of the data, specifically one column. I have the missing data on the old server but am unable to restore from a backup b/c new data has already been input to the new server. is ...more >>

I am pretty new to SQL Server, I believe we run SQL Server 2000. I have a table with about 150,000 records that get accessed everyday. I need to export a list of all the records accessed during the day. I have a field that timestamps each update. What is the easiest and most convenient w...more >>

if I have a Sql stored proc returning tables based on several IF... ELSE statements, shouldn't there be only 1 resultset? Because my frontend (Simego Sql Admin Tools) shows me 4 resultsets as if all 4 SELECT queries where run although insed IF...ELSE statements ...more >>

is there no way using CASE just to control the flow, the following isn't accepted by sql server: CASE @myVar WHEN 1 THEN SELECT ... WHEN 2 THEN SELECT .. ELSE SELECT .. END I cannot use SELECT before CASE because of complex statments eg CASE @m...more >>

Hi, Good Day, I'm not a new user to MSSQL, but I'm not sure where to post this question. I'm doing a system for a chinese company and would like to store the chinese character data into MSSQL, would like to know whether MSSQL support chinese character? Thanks in advanced. rgds, phoe...more >>

I have recently been given access to a SQL Server 2000-Enterprise Edition on a corporate server. Since I am a new user, I would like to play around with SQL Server but do not wish to mess things up on the live database servicing a Web site. I was told that I can install a Developers Edition o...more >>

Anyone give me some pointers on pulling several queries into one report? I need to sum up a numerical field and then show it as one line in a report. The same table is being queried over and over again, with only a change in the organziation.propertytype. Thanks SELECT SUBSCRIPTION.PRI...more >>

Hi, I need to update some data based on the results of a select query. The following select statement returns the values: SELECT DISTINCT A.itemid, B.DateSigned, B.RefID, C.EnteredBy, C.Action, B.Status, C.dateEntered FROM A INNER JOIN B ON A.it...more >>

Hi, Just a quick question I am trying to setup replication between a Standard edition (Subscriber) of SQL Server 2000 and an Enterprise edition (Publisher) and the Standard edition can not connect to the Enterprise edition (distributor). I can ping the Publisher from the subscriber, so I wa...more >>

I'm getting ready to write my first trigger, The trigger will fire after a record is added to a parent, and it will add a record to a child table, with the parent record's identiry value as a foreign key. It occured to me this must be a fairly common chore, and I should probably work from a...more >>

I have SQL Express installed on a remote server. It installed without issue. I'm trying to connect to it over the internet with Enterprise Manager and failing! What I've done so far... 1) SQL Express is running 2) SQL Browser is running 3) I enabled TCP/IP and set it to listen to the machin...more >>

Hello. I'm relatively new at SQL queries, so here's what I need. I have two tables, identically structured with data where some is the same and some is different. I need simply to query for those differences; i.e., if a field in a record does not have an identical record in table two, how do I f...more >>

I have a stored proc which starts with setting a @EntriesList varhcar(255) parameter and then iterates the results and returns a table with 3 columns. It seems because of this first query: SET @EntriesList = (SELECT ... FROM ... WHERE ...) I always get 4 columns in the final table. How c...more >>

I am running a distributed query in an SP and get this error when I try to run it Server: Msg 7306, Level 16, State 2, Procedure sp_transfer_tbltest, Line 28 Could not open table '"testivs1"."dbo"."tbltest"' from OLE DB provider 'SQLOLEDB'. The provider does not support an index scan on thi...more >>

I would like to link an Excel Spreadsheet to my SQL 2K Database. Where do I need to start? For example. I would like to have a cell in Excel that gives me the sum of Sales Orders in my SQL Database. I would also like for this to be able to change according to a date field in excel that c...more >>

I design computer-based training that stores user scores in a database. The training software sends the data to ASP pages that send the data on to the database. Because of a large client, I am using SQL Server rather than Microsoft Access for the db. I have designed and tested the db usin...more >>

I've been tasked with estimating the approximate amount of disk space required for a new SQL Server database. I have the initial and expected record counts, but I'm unsure how to translate that into disk space requirements. How can I best determine this? Is there a formula that new users lik...more >>

Hi everyone, Just a quick question regarding reindexing. Is it necessary to do a dbcc reindex on every table, every day? And if a reindex task which usually takes 45 minutes, suddenly takes 15 hours, what might be a reason for that? Thanks in advance, SQLnewbie ...more >>

I have question about licensing of MS SQL server. I read information about license per processor We are developing application provides large database and few services that make some functions with the data. This application is used by other third party systems (IS) as solution for our clients. I...more >>

Hello all, I got a application which is developed using VB6.0 as front end and MS-Access as backend. Now i would like to change the database from MS-Access to MS-SQLserver. How do I change the databse from MS-Access to MS-SQLServer? Regards Jack...more >>

Dim CnDisp Dim oRs ViewSizePg = 5 Set cnDisp = Server.CreateObject("ADODB.Connection") Set oRs = Server.CreateObject("ADODB.Recordset") The following yields no returned records in an ASP VB page yet, the SQL statement alone yields records in a pure query environment!! Why i...more >>

Sorry just a test ...more >>

I had Microsoft SQL Server 2005 Tools Express Edition Beta 2 installed at a previous point in time. Now the install for the release version fails. The message says that components of the beta product were detected and installation aborts. There is now record of beta software in the Add/Remo...more >>

Hi, Any help would be appreciated. I am looking for information about storing text messages sent by mobile phone in an Access or SQL Server 2000 database. Would anyone have articles,tutorials etc on this subject? Thank you David Kennedy ...more >>

Hello, In my SQL database, I've got 3 types of tables, which I think are used in almost every database. 1. A table which is designed by a dba/developer and contains static data. 2. A table which is designed by a dba/developer and contains dynamic data, depending on what a application us...more >>

I'm adminstering a SQL Server 2000 database on a Dell PowerEdge 1800 server, running MS Win2k3 Server Standard OS. The tape drive is Dell PowerVault 100 / DAT 72, SCSI interface. Dell included, and I installed, Veritas / Symantec BackupExec QSE, which I had been using to perform daily backup...more >>

I have this query which selects items from the News table I want to run a stored proc which cuts the HTMLBody column down too 100 chars and removes html can I do something like SELECT DateIn, Title, EXEC CutHtml(HtmlBody) AS CutBody FROM News ... ? ...more >>

I'm using an access project to view data from a Sql Server database. Is there a way to save the changes I make to the datasheet view (like column width, order, sorting) in the adp file? It used to ask me if I wanted to save changes when I closed a table but it doesn't anymore. Thanks, Mi...more >>

Hi, I have a table with "dates of birth". It is in smalldate format. mm/dd/yyyy (time) I need to select all record in which today is their birthday. Meaning the month and the day are the same as today's How can I make this 'select' ? I tried: Select * from users where dob = MMCo...more >>

we are installing sql server 2000 Enterprise edition on windows 2003 server. The thing we want to do is when we install sql we want the sql transaction log files to be in seperate drive because sometime they tend to be really big. can somebody please tell me how to do it thank you shoby ...more >>

How can i determine the reason of the first error ? It started somehow when the admin restarted the server..But he claims he did not do anything at all.. Sql Server Agent is logged on domain server as administrator not as local system .. Thanks 1-Windows cannot determine the user o...more >>

Is there a way to programmtically copy data from a database on one server to another database on another server without them being linked? I can do it through dts but not through t-sql. For instance, CREATE TABLE [dbo].[tblStuff] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [Code] [varcha...more >>

I would like to know if I should replace all ntext datatypes in my current database with nvarchar(max) or is it only for use in stored procs? Is it possible and if so would it make the database size less? ...more >>

Are views faster than stored procedures if you're working with a complicated select query with lots of joins, etc? Or is it just easier to maintain. When should you use a view instead of a stored procedure? ...more >>

Hi All, I want to know when dbo.MSdistribution_history table will be created and where it will be present (under master database or any other database)? I think this table will be created when you enable replication on your SQL Server and will reside under master database. Please correct...more >>

I am trying to do the following: Objective: Check to see if a store has recorded 'Actual' sales at least once for each three month period starting 1.1.00 through 3.1.05. At least once for Jan, Feb, Mar of 2000. Then at least once for Feb, Mar, Apr. Then Mar, Apr, May, and so on through to t...more >>