Microsoft SQL Server Forum

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...

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...

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

im not very good at sql but need to query the database to use in my programming script. if the database is just like this id name parent_id 1 A null <----- root 2 B 1 3 C 1 4 ...

I have an error -239 when I insert a User Defined Function in my Impromtu Report. Erreur nº -239 : DMS-E-GENERAL, Une erreur est survenue pendant l'opération prepare request. DMS-E-SS_PARSER, Une erreur a été détectée pendant le traitement de la requête SQL. DMS-E-SS_INFO_SYNTAX, La description de la fonction 'mytest' dans le

Hi, A query is exceeding the length of varchar and nvarchar variable. Because I'm picking the data from each record from table and giving it to the query. suggest me some way to do it. sample query:

Hi, -- SQL Stmt 1 SELECT * FROM Table1 WHERE Field1 = 123 AND Field2 = 234 AND Field3 = 345 AND Field4 = 456 AND Field5 = 567 AND Field6 = 678

I have an Access 2000 application that uses sql server as back end. We're trying to avoid using ODBC to set up linked tables in access. Is udl an alternative way? I set up the udl file but don't know how to use them for linked tables in Access? This is what I have in my udl file. ---- ; Everything after this line is an OLE DB initstring...

Hi all, I have a query as follows: update stage.FinanceVehicleSummary set vin = (select VIN from stage.ChasisLookup where stage.chasislookup.chasis = stage.FinanceVehicleSummary.ChasisNo and stage.chasislookup.sr_registration_number = stage.FinanceVehicleSummary.srregno) and i get this message: Subquery returned more than 1 value. This...

I just discovered that all my records appear twice inside my table, in other words, they repeat on the row below. How can I delete all of the duplicates? I'm sure there must be a tidy line of sql to do that. Thanks, Bill

I've read frequently how stored procedures we create shouldn't be named with sp_ since SQL Server will first check the master db before the current db when trying to find the sp to execute. I always nodded and thought how I was glad I hadn't done that. For some reason it never clicked that UDF behavior could be the same. I have several...

I need to export a list of name and email address fields from a SQL table, in some format so that a user can take the file I generate and Import it into Outlook and it will keep all the names together in a Group or Distribution List rather than dumping them into the user's main address book. Any ideas? Francesco

I have the need to restore a database to a user's laptop on a daily basis. This has been no problem using Enterprise Manager. I found a stored procedure to run the restore and tried to call it from a visual basic program. While I can connect to the database, I get an error telling me "exclusive access could not be obtained because the...

Hi, I want to find out in my SP the filegroup associated with a particular table? I was not able to establish the relationship between sysobjects and sysfilegroups table. Is there any other way to find filegroup of a table in T_SQL? Also lets say there are 3 dtatfiles in a filegroup 'FG1' and table 'xyz' is created on filegroup 'FG1' - Is...

Auto Close Idle helps you utilize your multi-user concurrent users licenses more efficiently. It closes unattended clients remotely after a certain period of time or manually. Furthermore, clients can close the most idle user automatically without the need for the administrator's intervention. For more information visit our web site... ...

I have the following cutdown version of table: VehicleID Time Station ------------- ------- ---------- 1 9:00 A 1 9:10 B 1 9:20 C 1 9:30 A 1 9:40 B 1 9:50 C

Hello.. I designed a table named receipt_master which include purchase order & shipping & goods_return header information, with a flags column, they can be distinguished. then I designed a receipt_detail table, include all the detailed information( product_id, qty, unit_price.......) of above receipt... My question is, should I seperate...

I have a table contains huge rows of data. Performance issue raised. I am thinking archive some data so that the table will not be that big. The most convience way is move it to another table. The problem is: will this solve my performance problem? or I need to move it to another database to reduce the database size? Regards, TrueNo

Hi, what I am trying to discern is if there is any way of logging SP activity on a SQL server 2k DB. Ideally I would want to log SP name, parameters, user and time. I found sp_monitor in MSDN but that just gives overall statistics. Not specific enough to aid debugging. Thanks in advance,

The problem i am facing is described as below: I have one client application which execute some stored procedure using SqlExecDirect and just after executing the statement if connection with SqlServer gets broken sometimes the client gets hang. Basically the response does not come from odbc statement. If i put connection time out it will...

I wish to backup a db to a shared folder on a network PC in same domain (also runnung SQL server) Can not recognise file path. Any help please? KS

i have weblogic (7 and 8.1) installations that need to talk securely via JDBC to mssql database. preferrably using type4 (or at least type2) driver. is there anything out there that can be of any help? thank you. -anton

Hello, If I run an action SP from MS Access using ADO: ... cmd.execute where the SP is something like Create... Update tbl1 set fld1 = 'something' where... how can I retrive the count of records affected like from Query

Aside from temp table, in what circumstance one would have only one column for a table (be it data or key)? I can't think of any case but some of you may. Thanks.

I have an application with highly compressable strings (gzip encoding usually does somewhere between 20-50X reduction.) My base 350MB database is mostly made up of these slowly (or even static) strings. I would like to compress these so that my disk I/O and memory footprint is greatly reduced. Some databases have the ability to provide a...