I am updating a C# web project which stores the contents of an ASP web form in an SQL Server 2000 database. Originally the code deleted all the current contents of the database and then re-inserted them. However, the requirements have changed and it is now necessary to timestamp changes to in...more >>

I've got a SQL Server 2000 database serving a classic ASP web application. The performance of the database keeps nosediving and I can't figure out why. When preforming normally, running a known query will return a result set in 5 seconds. After time, or more commonly after a big data import...more >>

Hello, I'm trying to setup SQL Server SP4 on a windows 2003 cluster, but the setup hangs on the Validating User dialog box, I've seen the sqlsp.log file and it seems the program hangs when it stops and starts the SQL service with the SCM.exe program. After 20 minutes or so, the program throw...more >>

Hi All, I was going to apply SP4 to the SQL server in my test environment, and did Select @@Version and was surprised to see SP1. I applied SP3 manually months ago. I then did serverproperty('ProductLevel') and select serverproperty('ProductVersion') and got the right answers, SP3 and 8.00...more >>

Hi: Is there some way of accessing the username (SQL Account) that is running a stored procedure? Basically, in the absence of good row level security options in this verison of SQL, I want to create a proc like this: ---------- DECLARE @username SELECT @username = userfield FROM Possibl...more >>

Hi I have a couple of databases running on SQL server 2000 standard. All are under 300MB in size each. I want to install SQL server express 2005 and transfer the databases. Can someone please tell me how I should transfer the databases? ...more >>

Is there a simple way to export all table metadata (i.e. fields and field data types)? I've been introduced to a DB with over 40 tables, and I would like an easy way to diagram the fields without having to manually input each table and its fields into a new spreadsheet or Visio doc. Thanks. ...more >>

AIM EXECUTIVE tgugger@aimexec.com 419-380-8853 DBA/ MS SQL SERVER 2002/ BATON ROUGE Position: Data Bas...more >>

I've been given a series of text files where all the fields are delimted by a vertical bar, but each row takes up two rows in the text file. So if I use any delimter like CR or LF etc., it treats each row like two rows, since each row just finishes with a vertical bar and then a return. Is th...more >>

Hi! I have two SQL 2000 standard edition servers that are linked. I experience serius speed issues when I try to insert into a table on one of the remote servers. The processor, disk and network utilization is nearly not noticable. The tricky part is when I do a insert into serverB from s...more >>

Is there a simple way to convert an MS Access mdb database to MS SQL Server 2000 or MySQL? ...more >>

Hi Does anyone know the latest planned release date for 2005? Thanks ...more >>

It takes 60mb when not doing anything. At the same time, MySQL only takes 1.6mb. What makes the difference so great as they're both SQL servers? Oh and does PostgreSQL support the features supported in Ms SQL ? (I'm not talking about Server features such as replication) ...more >>

Greetings. I would like to set up a script that will update the column sizes for certain table/column combinations that the login has access to. It can be done via EM, however it automagically takes care of dependent "stuff" like making other related objects resized also. I'm not sure if ...more >>

Is there TSQL code out there that would convert "3232235826" to standard IP dotted notation? THanks. ...more >>

I am trying to make a lookup column for a table I have in a MS-Access Data Project. I can not get this to work. Where can I find an example on the network as to how to do this? My email is mcharney at dunlap hospital dot org or mbcharney at sbc global dot net Thanks in advance. Mik...more >>

Hi, i've some problems with sp_executesql. I want to store some queries in a table(-field) together with a description in another field. With a 'select top 1' I tried to get a result, which succeeded. Next I wanted to execute the result (which is a query). This is what I can't get working. ...more >>

If I do this in Query Analyzer: DECLARE @WORK INT SET @WORK = (100 - 50) / 100 The result is zero. I've checked my SQL Server 2K (SP4) settings and there's nothing obvious. Perhaps a fresh set of eyes can shed some light on this. Thanks Paul...more >>

I wanted to use sp_OACreate, sp_OAMethod and sp_OADestroy to execute a DTS package from a stored procedure. I had the dba (using the sa account) create a wrapper stored procedure as recommended in http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqldev/html/sqldev_10182004.as...more >>

Hi guys I have experinced some strange sql problem. There is the query I execute. ------------------------------=AD------------- Select count(field_A) from table Table_A where field_A is null and field_A is not null ------------------------------=AD-------------- Field_A is integ...more >>

Hi, I need to limit results in the following query type: http://www.somewhere.com/php/sql-a.php3?server=1&db=mydatabase&table=mytable&sql_query=SELECT+Field_1%2CField_2%2CField_3%2Cidno+from+mytable+where+1+and+field_1+like+%22string%22+&sql_order=&pos=1 I found a reference that says I shou...more >>

Using SQL Server 7, stored procedures, ASP.NET in VB The problem is this. If I do an insert with a sp INSERT INTO NAMES(FIRSTNAME)VALUES(@FIRSTNAME) When I attempt it access this. The Resulting string is not "David" it is "David " Thus in ASP.NET I ...more >>

Hi. I have some code I have no control over and can not modify. It uses jdbc and rowcount to determine if a problem has occurred after a delete. I have a trigger I need to add which, after the delete, goes out and does various things which affect the rowcount, so that when the trigger is done...more >>

MSSQL 2000 Query Analyzer How do you get MSSQL 2000 to accept the French and some other European countries currency decimal character of ( , ) instead of the one used by the US decimal character of ( . ) . I have the Computer-Control Panel-Regional Setting set to French (France) ENGLIS...more >>

I'm pretty new to SQL server. Currently i'm trying to use a stroed procedure in ADO, it builds OK but may be causing a problem in my code, so i attempted to translate it into Query Analyser to check. Heres the stored procedure: CREATE PROCEDURE proc_CheckForDuplicates (@usrName varchar(15) = ...more >>

I am receiving the following error when applying the 0686 hotfix on a node in our cluster. The node has just been rebuild and added to our cluster. SP2 was applied successfully to the node; however, when applying the hotfix I receive the following error. Colon (:) missing after drive letter in ...more >>

I do this quite offen: A stored procedure that insert a record into a table if it does not exist (based on the key) or update the existing record. Sometime I use IF EXIST (SELECT ...) Sometime I do SELECT .. then check the @@ROWCOUNT Sometime I do SELECT COUNT(*) and see it it's 0. Sometime ...more >>

Hi, I'm having a problem understanding some results that I'm seeing and I hope someone here can help me out. I'm sure this is a FAQ by now, but I've had trouble googling relevant results. Considering the following Sql statement: SELECT 'Huh' WHERE 'a' = 'a ' -- that last one is quote a s...more >>

Hello, I am working on custom application and as I am updating my app/development db I have to update production database. Is there any way to automate this process or get list of differences between two databases. I heard for SQL Bundle but was wondering if there's any cheaper, if not ...more >>