Hi, I am struggling with the following SQL. Can anyone help me please. What is the problem? Errors: Server: Msg 156, Level 15, State 1, Line 6 Incorrect syntax near the keyword 'PROCEDURE'. Server: Msg 137, Level 15, State 1, Line 14 Must declare the variable '@mySomething'. BEGI...more >>

I have an application that lets users upload pictures. These pictures are stored in different folders depending on the user ID (of the user that it belongs to). The path can be figured out dynamically by knowing the user ID. However, the programmer that's coding my application has decided to ...more >>

Hello everybody, Try this: declare @table table(col int) select a.col from @table a join ( select c.col from @table c join ( select e.col from @table e where e.col = ( select max(g.col) from @t...more >>

Has there ever been any discussion of having an aggregate function that would return a comma seperated list of values... so for example if you had the following rows in a table called People: Id Name Age 1 Brian 18 2 Brian 20 3 Bob 25 4 Bill 10 5 Bob 30 And did a select that ...more >>

If you use the command UPDATE <tablename> SET <fieldname> = ' ... ' to update a CHAR or TEXT field there are some characters that can cause problems such as a single quote. Are there any other type of charaters like that? TIA ...more >>

Have a SQL Server database that I am populating (for a client) using file data from legacy COBOL / Unix system. They are using Microstrategy against the database for BI purposes...and it is working. When I load rows from legacy files, I am including a data/time stamp. Legacy system follows bas...more >>

Ok, suppose I have a dotnet application that uses MS SQL server. The SQL server is maxed out. Suppose the code is already optimized and suppose I've already maxed out the ram and processing power. What ways are there to load balance it so that I can scale the application further up? ...more >>

All, I found this script in one FIDONET conference and decided to test my servers available around. The result is more than strange. -- TSQL DECLARE @i INT,@j INT SET @j=0 SET @i=0 WHILE @i <= 3000000 BEGIN IF @i > 100 SET @j = @j+100 IF @i < 300 SET @j = @j-...more >>

We have installed SQL 64-bit on an Itanium server running windows 2003. We can't use enterprise manager to connect from any workstations We get this error: SQLSERVER does not exist or access denied. Even the SA account Fails. Help.. Thanks Masg ...more >>

Can someone tell me how to export data to the flat file with bcp that are comma delimited instead of the tab delimited by default. I'm sure it's just some configuration or something. I just need some quick answer. Thanks in advance. Wei ...more >>

Hi David You answered a recent query about entering NULLs in Enterprise Manager. Where did you learn this? Do you know of any other useful shortcuts? TIA Alan...more >>

Hello, In my MS SQL SERVER database i have an column with datatype image. Some records do have data in this column, some others don't. When i look at this table in Enterprise Manager then i see in every field '<image>' so no way to see directly wheter a filed has data or not. Is there a way to...more >>

We have a client that for their database every index is set to a FillFactor of 90. The tables vary heavily opn the amounts of reads compared to inserts/updates. After looking this topic up, I have found this rule: Low Update Tables (100-1 read to write ratio): 100% fillfactor High Update T...more >>

Is there anything available that will decode the password found in TDS7/8 login packets? (these are the packets that are sent to SQL Server to authenticate a user in mixed mode) I'm dealing with this situation... Often times my clients will hammer my sql server with login attempts, but t...more >>

Dear Colleagues: This is such an SQL newbie question its not even funny. To begin with, please forgive my informality as well as my lack of any specific error messages, etc.. . I think the questions are academic (the specific error messages and notes are strewn about my desk at work). Ok...more >>

Hello all, Hello, I posted this in the MS Access forum, but did not get a response. I'm hoping that someone here will have some input I have a problem which may just be a config problem. I have linked tables to a SQL DB view. For all users, it just has INSERT permissions to this table--e...more >>

I have a 24/7 Sql Server Database (4way processors 4GB ram, DL580's). I need to move a very large table (1 billion records, 20GB in size) without any downtime and without locking the table. I also need to be considerate of CPU utilization during this process. I have a clustered index and a no...more >>

I have a situation with a view. This view uses 2 or 3 or 4 tables to retrieve data, doesn't matter I have several. Someone came to me and said "During design, I forgot a field..." in one of the tables that make up this view. So the field was inserted into one of the tables. Now when I execute th...more >>

Hi there, On SQLServer 2000 , I want to do this: select randomly any unhandled customer from a table, and before doing anything else mark that customer as "being handled" (so my collegue won't begin handling the same customer). Right now I am using: UPDATE tbl_customers SET col_handledby=...more >>

i need some advice on how to set up some tables within a database. i am working on a project that inventories blood samples. the blood is recieved in packets. it is divided into tubes, plasma, cells and DNA are then extracted into tubes. the specimens are then inventoried into freezer boxes. ...more >>

Hi: Simple question--is there a tool that convert SQL script written in SQL Server to the equivalent in another DBMS such as Oracle or DB2? Thanks!! blair ...more >>

I has a strange question. My company is using a old system with Win NT 4.0 Server + MS SQL 7.0. The system is busy and handle a lot of SELECTs and INSERTs all the time. Sometimes, some transactions are blocked by some other transactions. For those INSERT transactions, we usually call a stored ...more >>

Can anyone help with the following error. I have a job that runs daily on a server that gets data from a database on a different server. Most nights the jobs runs fine, but every now and again I get an Error 7399, followed by Error 7312. This last happened in the early hours of this morning, ...more >>

I'm attempting to move a database which currently exists on an old Oracle 7.34 instance and tried to use Data Import via DTS to SQL 2000. The Oracle database consists of views, indexes,packages,triggers as well as tables structures. I tried DTS using both the ODBC and OLE for Oracle and only t...more >>

I'm attempting to move a database which currently exists on an old Oracle 7.34 instance and tried to use Data Import via DTS to SQL 2000. The Oracle database consists of views, indexes,packages,triggers as well as tables structures. I tried DTS using both the ODBC and OLE for Oracle and only t...more >>

Hello All We have a data migration project. This is basically what we plan to achieve we have a legacy system which as some data with German long texts like material texts,etc We want to take data coming in flat files which as this german texts and convert this to English text the texts are...more >>

Hello all. I restored a SQL Server 7.0 backup to SQL Server 2000. I get the following message when I run my asp page: Microsoft OLE DB Provider for SQL Server (0x80040E4D) Login failed for user 'XXX'. I can see the XXX user listed under users for the database, but not listed under login...more >>

Did someone come up with a solution for the performance problem you got in some cases when upgrading from version 7 to 2000? The query is 40 times slower in SQL 2000 and with a different query plan. The database is the same ( transfered ), all indexes in place and statistics updated. I have seen...more >>