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 >>