Is there any way to make a field larger then the 4000 characters that nvarchar allows? ...more >>

Greetings, I have been asked to convert a decimal value to hexadecimal and store the hex characters as a string. I can convert to binary(hex) just fine using an int to binary casting, but when I convert it to a char string, it shows only the funky binary characters (+=D0=BB). For example....more >>

Hello, I have an application that used an access database and I am currently migrating to SQL Server. The software is designed to use Odbc object found in the .Net framework version 1.1. I have a simple select statement that is driving me nuts. It works fine with the Access databases b...more >>

Hi We have Access Project as the front end for a SQL Server database. If we create a table from within MS Access it appears in SQL Server, but we cannot edit/add/delete the records in this table from within the MS Access project. If we open the table from within SQL Server we are able to edit...more >>

I would like to reference the environmental variable %temp% from xp_sendmail. Specifically, I would like to attach a file from the directory specified by the %temp% variable. exec xp_sendmail .... @attach = '%temp%\filename' gives me an "xp_sendmail: failed with mail error 0x80004005" e...more >>

Hi Is there a way in MS SQL 2000 to insert the results of a Sproc into a #temp table without having to create it up front ? e.g. instead of Create table #tmp(ID INT) insert into #tmp exec dbo.myProc (where dbo.myProc returns several rows of a single INT field) do something like ...more >>

Hi, I have this query that summarizes curtain types of "transaction" records in a table called "transactions". The summary table called "resultset" contains foreign key column in transactions called "transaction_id" and a column called "gift_number" which represent the chronological order of ...more >>

I have about 30 stored procedures that are using the same SELECT statement (but doing different things with it). Would it hurt performance significantly if I created a view for this statement and have the stored proc's reference the view? You can imagine what is involved when the SELECT statem...more >>

Hi: I have a DTS package that first brings in data from another database into SQL Server. In the source database, the database tables are like this: TableName20041014 for example. At any one time, 10 of these tables are in the source database, every day the oldest one is deleted, i.e.: ...more >>

Hi: When working in Query Analyzer, I was working executing different code in different batches. I noticed that if I executed the same batch twice in a row, the second time it would complete immediately (and say it was successful), but it wouldn't actually do anything. The same would happen i...more >>

Hi, I am not sure if this would be the right heading for the question but, this is something I haven't faced before. In a mssql 2000 sp3 server has around 30 users and 30 databases. Each user is a dbowner of an individual database. There is not any user owns two or more database in t...more >>

I have 2 tables as follow:- Table1 ParticipantNo GPartiNo 1 1 1 2 1 3 2 1 2 2 Table2 ParticipantNo GPartiNo 1 1 1 3 2 2 I need a query that can return rows from Table1...more >>

Hi All; I am brand new to SQL Server, and have reluctantly inherited the responsibility of configuring SQL so that it can upload stuff from our local database onto the one our hosted web site. My main question involves identifying it as a server. How (give me all the juicy details) should...more >>

is there an sql statement i can run that shows me only records that aren't identical between two tables? tks ...more >>

Hey there, I'm curious about MySQL. Could anyone quickly summarize the differences between MySQL and SQL Server and outline why someone might pick SQL Server over MySQL? (Please post replies here, email address is fake) Cheers, Geoff Glave in Vancouver, Canada ...more >>

I'm having a calendar feature developed whereby users can add recurring events. These recurring events can have start and end dates, meaning they will recur only within a date range. For instance, user A creates an event that recurs every Tuesday, from 1/1/05 - 3/2/06. The developer has deci...more >>

I'm looking to store an actual disk structure in a SQL server, and have it mapped to an actual drive that a user would have a hard time knowing it's anything but an extra hard drive. My problem is this. I have to be able to replicate a file structure to remote, unattached users. I was envi...more >>

hi, newbie question, How can I get the database filling percentage. ie the database is 56% full. using sql server 7.0 thanks...more >>

Hello All, I have a row of numbers returned from a query that I need turned into a single field for grouping purposes. I was wondering if you know of a way to do that. So if my return record set from select MyIDs from v_Ordersinprocessdetails where id = 57 and job = 56955 and mijoid = 2260 ...more >>

Hi: I have a DTS package that does the following: 1. Data Pump: Grabs a table from a Sybase database, all fields and all records, and puts it in SQL Table 1. 2. Data Pump: Selects only certain records and puts them in a particular order, writes this to SQL Table 2. 3. SQL Task: SQL Code to...more >>

Hello, I recently built an ASP.NET app that uses a stored procedure with the xp_cmdshell to execute a few DOS commands on another servers hard drive. The server I need access to is another machine on my network. For simplicity's sake, here's an example: exec master..xp_cmdshell 'echo "h...more >>

Does anyone have any idea why I would be getting this error INTERMITTENTLY? What is the best way to troubleshoot it? Connection Failed SQLState: 01000 SQL Server Error: 53 [Microsoft][OBDC SQL Server Driver][DBNETLIB]Connection Open (Connect()). Connection Failed: SQLState: 08001 SQL Serv...more >>

Hola!! Existe algun Collate en SQL Server 2000 en donde todas las entidades de una base de datos (tablas, views, stores, ect) sean case-insensitive y que los datos almacenados sean case-sensitive? Muchas Gracias!! Natalia...more >>

We have a working MS Access 2000 database hosted externally and a couple applications running against them. Fortunately, the site is getting busy, so it's time ot migrate to SQL Server 2000. What tool is available in either platform to facilitate this transition gracefully? Thanks, Chuck...more >>

Hi, all: I have a strange problem with my DTS package. I have a table with autogrow number column as primary key. I truncate the database before my data load. My DTS data load task is simple. I have make sure that identity column are not mapped to my data column. I also make sure in the opt...more >>

hi all we're upgrading our development server. what's the easiest way to copy all of sql server (all databases, all users, etc) to the new installation? tks ...more >>

Hello Group, when i use bit-datatype for saving boolean-values then sql-server aggregates up to 8 in one byte-field. how sql-server saves the 3-states (true, false, NULL)? in my opinion a 8-aggregation is only possibly for NOT NULL bit-column-specifications. is this right? Thanx for a answe...more >>

What is the best percentage of memory to use for a workstation running MS-SQL? Thansk, -p ...more >>

I have a report the gets the following data for each member in a report table format, this query takes parameters and returns about 20 records and each has the same information shown below. Name company title address phone email effective date However, instead of this data "snaking" to...more >>

I am trying to calculate the number of business days between two dates for each row returned in a query. I would prefer to avoid using a stored procedure, if possible, because I am using this for Crystal Reports and I have parameters that get built with Crystal to narrow down the resultset. I...more >>

Can someone please help me with this query. I have a table that records students test results, on various days. The fields of interest are StudentID, Score, and TestDate. Now, I want a query that will show fields in this table, for each students highest score. So, for each student, there ...more >>

Can someone please help me with this query. I have a table that records students test results, on various days. The fields of interest are StudentID, Score, and TestDate. Now, I want a query that will show fields in this table, for each students highest score. So, for each student, there ...more >>

Can someone please help me with this query. I have a table that records students test results, on various days. The fields of interest are StudentID, Score, and TestDate. Now, I want a query that will show fields in this table, for each students highest score. So, for each student, there ...more >>

Hi all, This might be a very stupid question: To do an upgrade of the SQL Server driver, would it be sufficient to just copy the latest version of the SQLSRV32.dll to the C:\Windows\system32 directory (overwriting the existent one). Or would I need to do more? Thanks in advance, BoB ...more >>

hi all i want to pass something like "3,5,8" as a varChar to a stored proc, split into an array using something like arrValues = split(@sString, ",") and then do something like: for i = 0 to uBound(arrValues) insert into myTable(column) values (arrValues(i)) next i do this sort of t...more >>

Hi, A nice easy one for you. I'm using the Northwind database and want a SQL statement that will tell me the day and quantity that the most orders were placed on. I have; SELECT orderdate, sum(quantity) as totalsold FROM orders inner join [order details] ON orders.orderid = [order deta...more >>

We have Compaq 8500. 2 drives died,and when we put new drives in, the sql local drive which contained most data were empty. What would you suggest?...more >>

Dear all, we are running an sql server 2000 which host our customer database which is collected onsite, we would like to offer order tracking to our customers through our website. Our website and email is hosted by another company and we just upload our content. What I am thinking of doing...more >>

Dear all, We have custom software for our operation which is using sql server over a lan at present and is working fine, what i am trying to research is using the same application over terminal services on a terminal server, I have a terminal server with the software installed this gets its...more >>

Hi: I want to import data from a Sybase database via a SQL Server DTS package. The database views in Sybase I will be importing from all have different names according to the date of the data in that view. For example: database.dbo.SybaseView20041122 only has data for Nov. 22, 2004. I want ...more >>