Maybe I'm missing something here. It seems what I'm trying to do is pretty simple. I'm trying to query a database field with data type ntext, and the content is greater than 8000 in length. I'm using .NET 1.1 framework to run a query. SqlCommand cmd = new SqlCommand("SELECT message_body from t...more >>

Hi, I have a text file but its content is not delimited. For example I know that first 4 characters are my first column, next 3 characters are second column and so on. What's the fastest way to import such files into a table? My files are very large and the speed is important. Any help will...more >>

I need to add a special ID to each row in a column in several tables of my database. The counter has a prefix of 3 characters ABC + a number. Ex. ABC000000001 I've allready built a query to get all the tables that I would like to update. gives me the result: ex. TABLE1 TABLE2 TABLE3 ...more >>

I have one more question ;-). In the code below I have error: Msg 102, Level 15, State 1, Procedure AfterInsertMaterials, Line 11 Incorrect syntax near ';'. I don't know what is wrong. Table MaterialsInStocks has 6 columns. By the way (I am newbie), use semicolons generally or not? If I r...more >>

Hello, (Sorry for my English...) I am learning T-SQL and I would like to know if what I wrote makes sense. I wrote a INSTEAD OF trigger with TRANSACTION. In my material stock database application when new position of material document is created I need to update total quantity/value of material...more >>

Stop being a prick. You spoil the genial atmosphere of this newsgroup with your ill-mannered rants at people over petty issues. And your supposed intellectual arrogance is unfounded - sometimes, you are just plain wrong in your assertions. No-one likes you. So please either shut up and...more >>

Hi, I'm uggh, trying to change a Primary key value that was incorrectly added & must be changed to the next available generated key value. The trouble is, there are many related tables. If I try to change the PK for tbl1 I get a constraint error on tbl2. If I try to vhange it on tbl2 I ...more >>

I run SQL Server 2000, latest servicepack. My problem is that Select into tablename does not work when tablename is a temporary table. It works perfectly when tablename is a permanent table. I have a complicated stored procedure handling pivoting with a random number of columns a...more >>

I am getting this error daily and can not find the solutuon. ERROR: 15457, SEVERITY: 0, STATE : 1 CONFIGURATION option 'show advanced options' changed from 1 to 1. Run the Reconfigure statement to install Anyone has an idea? how to solve this error...more >>

Below is the WHERE clause that returns records whose date is the last business day of the previous month and the current date. The strange thing is I have to subtract 2 days from Saturday to get 3/30/07 when DATEADD(day, (0 - datepart(dd,getdate())), getdate()) returns 3/31/07. Can anyone e...more >>

I have a SQL 2000 database that has a pretty large table with an Integer column as a Primary Key. I want to make it an Identity column as I now assign next highest number on inserts. I tried changing it on a test database using EM and it seemed to change ok. I also did an insert and it pi...more >>

Hello. I was wondering if anyone knew if it's possible or how would I approach importing 2 sets of data that is returned when running a stored procedure that comes from a different sql server 2k machine into a table on our local sql server 2k machine? One result set of data to import is pret...more >>

I have a suspended process that sits in running processes returned by SP_WHO for 3 days already. SPID:10 Status: SUSPENDED Login Name: sa DB NAME: master Command:CHECKPOINT CPU Time: 2625937 DiskIO: 358622 An attempt to "kill 10 " failed saying that only user processes can be kille...more >>

Hi I have a stored procedure which takes input as create or replace procedure #temp @parameter varchar(50), --- containts like ( '4', '334' , '33') .. kind of a set. @para_count int @para_1 int, begin -- some work -- End I want to extract the 1st element from the @par...more >>

Ok I'm trying to loop through all the databases except for system databases for key word in SP,Views,etc... Well when I run it in query analyzer and based on what databases I choose from the drop down, I will get different results? I'm going through each database and loading the @dbName corret...more >>

Hello all, I am interested in developing an application using SQL Server. I have some rudimentary exposure to Access, VB .Net and ADO/DAO. I am looking for a book that deals with developing the user interface and tying it to the backend database. I already have a good grasp on database d...more >>

We has two different opinions about how use PKs in some tables. I need know what of this options are correct. Thaks !!! *** OPTION 1 *** Countries: (PK) CountryId Name States: (PK) CountrId (PK) StateId Name Surface Cities: (PK) CountryId (PK) StateId (PK) CityId Name **...more >>

I have a fairly simple VB program that loads data into a parent and child table. For each parent, there can be as few as 5 to 10 rows or as many as a couple of hundred. I'm invoking an ADO connection object to start the transaction, perform the insert into the parent followed by the several inse...more >>

Hi All, Not exactly sure if this post would be suitable for this group. While processing my analysis services cubes using partitionprocess.exe.....i am getting an error these days..."Protocol error in TDS stream (#-2147467259;Microsoft OLE DB Provider for SQL Server)"......Could some body tel...more >>

How can I get the structure (Column Name, Data Type, Nullable, Identity, etc...) of all the tables/views from a database. What I want to accomplish is to set up an audit system so I can know when someone modify a table, and track it back to what was changed. I found these but I need more infor...more >>

Working with XML documents, are there substantial enhancements in SQL2005 as compared to SQL2000? If this is a new project, why would it better to use SQL2005? Any suggestions would be appreciated. -- Thanks in advance - Sunil. ...more >>

Hi All, Probably an easy answer to this.. I have written a batch file that runs a stored procedure.. here is what's written in the batch. SQLCMD -q"Exec BACKUPDATABASE" -SWAT19714 -dOCHC2 this works fine however the command window will not close after the batch file has been executed.. her...more >>

We're completely 2000 right now but need to implement partitioning when we go to 2005 in a few months on a few of our large tables. I've been reading through the information on such statements as ALTER PARTITION SCHEME... ALTER PARTITION FUNCTION... ALTER INDEX Indexname ON Tablename REBU...more >>

I have a comments table for all customers. I would like to only select the lastest 3 comments for each CustID. Please help! Thanks in Advance, culam CustID comment dateandtime ------ -------------- ----------------------- 9859 Welcome L 2006-01-30 13:06:40.000 9859 Info P...more >>

I wanted to ask this one more time: Our servers are all SS 2000 SP4 sitting on top of Win 2000 SP4. The other day I was in a meeting with our JDE administrator and he made the comment that when we go to Windows Server 2003, we'll get a "30% performance improvement". Of course, that's a vagu...more >>

I've written 2 stored procedures that pull from different databases and tables, but I made sure are returning data fields named the same and with the same data types. I'd like to have another stored procedure that invokes one of these stored procedures and puts it's resultset into #temp1, and th...more >>

CREATE PROC test_proc AS DECLARE @num1 float DECLARE @num2 float DECLARE @num3 float SET @num1 = 4.0 SET @num2 = 0.0 IF @num2 > 0 BEGIN SET @num3 = @num1/@num2 END SELECT @num3 When I execute above stored procedure using QA or OSQL, I get output NULL but when I execute this procedu...more >>

CREATE PROC test_proc AS DECLARE @num1 float DECLARE @num2 float DECLARE @num3 float SET @num1 = 4.0 SET @num2 = 0.0 IF @num2 > 0 BEGIN SET @num3 = @num1/@num2 END SELECT @num3 When I execute above stored procedure using QA or OSQL, I get output NULL but when I execute this procedu...more >>

Hi There, How to remove duplicates character from a string, for e.g i've a string abccdedgh@@@@@@@test.comco now i need output like this abcdedgh@ts.om Thanks Ganesh ...more >>

I want to be able to run a .sql file from a stored procedure or function. My intent is to automate the creation of views and tables based on a user input. I am fairly sure that I can do this just by exposing the SQL in the stored procedure, but this means having the same code in multiple places...more >>

I know that stored procedures are fast because on first execution they create an execution plan and stored it. Do trigger has the same behavior? ...more >>

BACKUP failed to complete the command BACKUP DATABASE [SMS_A21] TO DISK = N'e:\MSSQL\BACKUP\SMS_A21\SMS_A21_db_200704150200.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT this is the first time i see this error. what does it mean? there is a space n drive also any advic...more >>

Hi, 'Employee' Table is referred as 'table1' 'Third Highest' is expressed as 'TOP 3' (For second highest 'TOP 2') SELECT MIN(a.Salary) FROM table1 a WHERE a.Salary IN (SELECT TOP 3 b.Salary FROM table1 b ORDER BY b.Salary DESC) ...more >>

Hi sir/madam, Here I have one stored procedure. When I executed that stored procedure it's giving 10 result sets (in that stored procedure 10 select statements there. For example select * from tablename with out writting any where condition and so on.). Here the requirement is how I get on...more >>

Hi, when comparing index structure of two tables in different databases, I'm getting following difference: Source table: INDEX [LIST_VAL] ([DG_ID], [SUB_TYPE], [ORDER_BY]) Target table: INDEX [LIST_VAL] ([SUB_TYPE], [DG_ID], [ORDER_BY]) As you can see, the difference is the sequence...more >>

Hi: I need to move 3 tables from one server to another, the two servers (source:2005, target:2000) not having connectivity, (so I can't use DTS). They are part of a larger database, and I don't want to back up the whole database and restore it. When I use TOAD for Oracle, I can script a tab...more >>

Hello. I got short example: --tabel X was created on SRV; database DB create table [x] ( [i] [int] IDENTITY (1, 1) NOT NULL , [txt] [char] (10) NOT NULL , constraint [PK_x] primary key clustered ([i]) ) --start of script with unexpected behaviour begin distributed tran set xact_a...more >>

Hi, I found the following script results differently on two servers: select convert(varchar, getdate() ) server1: '16 Apr 2007' (expected) server2: '04 16, 07' And all format codes for the convert function that presents a month as 'mon' will show a two digital number for the month on se...more >>

Hi, I have a mirrored databased, which is in FULL recovery mode. I take log backups every 1 hour and db backups every night. However, the log file keeps increasing and due to mirroring I can’t shrink the log with shrinkfile. Is this the recommended set-up for mirroring, am I trying to be ...more >>

I wrote a store procedure in sql server to update MyTable with some parameters and return the updated dataset by a select clause. When I execute then procedure in Query_Analyzer, it works well and the record_count of the dataset is right. But I call the procedure by ADO, it works and return doub...more >>

Hello, Ive fired up Sql 2005 Express studio. All i want to do is create a Stored Proc. I go programmability>Stored Procs>Add New... and i get a template full of garbage. How do i scrap all that junk and just have it create a blank page so i can CREATE..... Secondly whenever i try to s...more >>

Can a snapshot be created from a mirrored database? I want to mirror a principal db to a remote server, however, I would like to look at the mirrored db every so often. I was thinking that I might be able to create a snapshot of the mirrored db (in its restoring/mirrored) state to a new da...more >>

Hello Is there any place in Sql 2005 where I can define that during removing a record from table A also recored from table B should be removed (table A is main table and table B is related table). Best Regards Darek T. -- Mazars & Guérard Audyt Sp. z o. o. Z siedzib± w Warszawie ...more >>