Microsoft SQL Server Forum

Hi I'm using the SQL 2000 table variable to hold 2 different fact sets. I'm declaring the variable @CurrentTable and inserting into it using a SELECT statement with no problems. I'm leaving certain of the columns null in order to later update them with the PK. Problem is in the UPDATE syntax I'm using

I am trying to view all the ntext from a profiler trace. The data is truncated at 256 and I am not sure why... The max length is 1820 via this command:select max(datalength(textdata)) from "monitor forms usage" where textdata like '%gforms%' . I then issue set textsize 8000 select (textdata) from "monitor forms usage" where textdata like...

When you set up a full-text catalog in SQL Server and you set up the population schedule, a job gets created and scheduled under SQL Server Agent. The problem I encountered recently is when I disabled that job in SQL Server Agent, the full-text catalog continues to be populated with that schedule (every 15 minutes). So I looked at the...

Hi, I recently had to add a new column to a table that resides off-site, in a customer's environment. Previously, the table had around 300 columns, all of which were in alphabetical order. I found that the ALTER TABLE command appeared to be only capable of appending a new column, but wasn't capable of inserting one into the middle of...

The following SP gives an error of: Server: Msg 245, Level 16, State 1, Procedure spSelectSEICData, Line 26 Syntax error converting the varchar value '@' to a column of data type int. In the Procedure I am using the Select * for testing purposes. Here is the proc. CREATE PROCEDURE spSelectSEICData (

Hi, I am having a problem accessing SQL Server 2000 via UNIX. I am accessing SQL Server 2000 from Solaris using Sybase Open Client (CT-Lib). Here is the error message: CT-LIBRARY error: ct_connect(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect

I have a DTS job that exports into a tab-delimited file. The tab delimiting is working great BUT it also using quotes around the fields as well. (I assume because they are string vars). Can this quoting "feature" be turned off? Thanks

Consider the following (questionable, to be sure, but syntactally legal) stored procedure (using the Northwind database): Create Procedure Test As Return (Select Count(*) From Orders) Select * From Orders; If you execute this SP in QA via:

Has this happened to anyone else? I have a large job and all the queries run fine when used individually, but in the job, SQL says completed with success but in two cases the queries did not run. One of them is even ridiculously simple: DROP TABLE tblMyTable, etc.

Hi there, I'm pretty new to SQL and am having some porblems with a linked server. I have a table on a SQL server which stores employee information. I also have a view on a linked server which stores the same information. What I would like to happen is, whenever the view changes on the linked server I want the information to be changed in...

Hi! I hope anyone can help me with this very important problem! Since configurig one subscriber in our merge replication scenario to a subscribing publisher we get a lot of merge conflicts type 10 reason code 2. Because we have the german version i translate the reason text as meaningful as possible: The row was updated at...

I'm currently updating one of our web sites and have encountered a strange problem. The page that is giving me the problem is written in ASP and hits a SQL 2K DB. When I click submit I have 4 procs that need to be executed. I always get a sql server timeout error. I opened up Profiler and traced the events. The page hangs on the last...

Hi, I have a funny Error in our sql server 7 & 2000. When I compare two string in Unicode format. I receive that it is the same when I add new nchar. I don’t understand why? Could you help me ? declare @str nvarchar(128), @str2 nvarchar(128)

Bit of an obscure one here, so please bear with me. I have two copies of a database which should be identical. Both have a complex view which is identical. I can open the views and the data is as expected and match. I can query it in several ways as detailed below. The 5th version of the simple query below based on the second copy of the view...

hello can anyone tell me if it is possible to use activeX components (com/dcom) in MS-sql stored procedures? tia

Hi, has anyone gotten the error "semaphore timeout" when trying to do a backup to disk? The disk is a logical partition. There are two drives, c: and d:. Backing up to c: is fine. However, backing up to d: produces the error below. Thanks in advance for any help. Here is the command : backup database model to TestM2 2003-07-19...

I have production SQL Server database that must be moved to a new machine. There is a fairly complex DTS package on the original server that is used to handle the weekly updates to the database. Is there a way to export this DTS package in order to set it up on the new machine as well? Best Regards, Warren Wright

I can extablish a connection to the SQL Server, but when I try to expand the "Databases" folder to get to our DB's (any number of them), it never opens. I've let it try to connect for over 10 minutes and I just close out Enterprise Mgr and it just timesout and tells me the program is not responding. A couple weeks ago I got it to work. ...

http://www.d0m1.com/autoCodeBeta/default.asp?c=706 ae ltd is pleased to announce the autoCode beta programme: autoCode is a Windows-based integrated rapid application development environment supporting both IBM Informix and Microsoft SQL Server databases. Some of autoCode's features include automated stored-procedure generation, schema...

Does anybody know where a copy of the MS-SQLServer software is posted?

Can anyone help me with an problem I have come across in my database design. I have a primary table and a related table with 3 child records (each with a numeric field). I require a query to return the primary key from the main table and the PRODUCT (i.e. all numeric values multiplied together) of the three child records, much like a SUM...

Hi There, I can't seem to see what's wrong with the query below DELETE FROM Users_Details UD1 WHERE UD1.UserID = ( SELECT TOP 1 UD2.UserID FROM Users_Details UD2 WHERE UD1.useremail = UD2.useremail

Hello Everybody Please tell me which is the best method to adminster SQL Server database in remote web server. Eg. I am storing all the information of SQL database in my work place and after that have to upload the modified table to remote web server. Please tell me what is the easiest way or how I can achieve this without purchasing...

Hello, sorry for my english. i have to make a trigger titch will run DTs on the server. For example when table test and field1 get value 1 then run dts. is it possible ??

I am new to MSDE and want to deploy it in my company (because it is free). However, when I install it in a W2K professional machine, there is a message box saying that a "strong SA password is required". How can I solve the problem? Arthur Cheung (The MSDE engine was downloaded from the microsoft sql server web page)