I'm new to sql server programing. Please help me to scedule a stored procedure to run every hour. Thnak you all. ...more >>

I have a column that has text delimited by a percent sign that I wish to turn into rows. Example: A column contains ROBERT%CAMARDA, I want to turn that into two rows, one row with ROBERT and antoher row with CAMARDA. I will have source rows that have zero, one, or many percent sign delimiters ...more >>

Hello, I am trying to create a view that shows the following Field1: Sum of Amounts from Table A Field2: Count of Amounts from Table A Field3: Sum of of Amounts from Table B Field4: Count of Amounts from Table B .. .. .. Field3: Sum of of Amounts from Table H Field4: Count of Amounts...more >>

Hi, I wrote the following in the SQL Server 2005 Express Management Studio Query Analyzer and hit execute. Even though Query Analyzer indicated success when I hit refresh on the stored procedure folder the procedure does not show up in the stored procedure list. When I entered 'exec Test' I g...more >>

I have a data set like so: UTC_TIME Timestamp NodeID Message Flag Line Station 11/19/2005 10:45:07 1132397107.91 1 3 5 1028 1034 11/3/2005 21:05:35 1131051935.20 2 3 5 1009 1043 11/25/2005 21:12:16 ...more >>

This is a tuffie, but I think I'll learn new techniques in SQL. I wish to put data from MS Active Directory and put it into a table. Specificly I want user information (first name, last name and so forth) and the groups that they belong into a SQL table. LDIFDE is a utility that can create a csv...more >>

Hi, I created a linked server for MS SQL Server 2005 Express to an Oracle database using the OLE DB Provider for ODBC. My ODBC Source uses the Microsoft ODBC for Oracle driver. I'm using the OLE DB Provider for ODBC instead of the Oracle OLE DB providers because those don't handle Oracle's Nu...more >>

Hello Config : SQL 2000 on WIN 2000 (IIS 5.0) In my ASP page for some queries i have this error : Microsoft OLE DB Provider for SQL Server error '80040e31' Timeout expired My asp page calls a stored procedure passing many parameters. I used the SQL profiler to get the exact store...more >>

I have a stored procedure that works fine on SQL Server 2000 or 2005, but when run on an machine running MSDE, I get the Operand type clash, int is incompatible with text data type error. The data type is actually text and text is the type of data being passed. Any parameters not being used ar...more >>

Is a single transaction log created for a database or, if you have a primary and a secondary file group in that database, are two transaction logs generated? Yep, a newbie. Thanks, Phil ...more >>

I've got a csv that I am trying to import into a SQL Server (2000) table through an adp (Access 2000). The form used gives the user the ability to browse for a file, then will import the file into a temp table for processing using this vba code: DoCmd.TransferText acImportDelim, , "tmpPaTimeC...more >>

I'm trying to create a online update form to a SQL table. I've never done this function before, and I'm not quite sure I have the coding correct. Below is the coding for the Update statement. final String udc = "UPDATE INTO " + "Comm_WebSubmission Set ProjectID = request.getParameter("Projec...more >>

What do you think of a query that generates a System.Data.SqlClient.SqlException when submitted via a application, but when run through QueryAnalyzer or EnterpriseManager doesn't generate a error? Here are 2 examples of the query: SELECT table1.*,table2.field1,table2.field2,table2.field3 FRO...more >>

Question: (SQL Server 2000) Can I arbitrarily delete a transaction log file in either bulk or full with a cron job and still be able to restore a backup? Or are the log and the .bak enmeshed to the extent that this not do-able? Details: I need to exclude a file group from a backup as it's stat...more >>

When a SQL statement is executed against a SQL Server database is there a server-side setting which dictates the size of the fetch buffer? We are having some blocking issues on a new server install which do not occur on the old server until a much larger volume of data is selected. Any help ap...more >>

I was working on figuring out where a certain application was storing the multiple selection choices I was doing through the app. I finally figured out that they were being store in an IMAGE data type colum with the variable length of 26 bytes. This is the first time I ran into such way of sto...more >>

Hi Guru, This weekend, I migrated SQL Server7.0 to 2000 and below is the scenarios: 1.) At exactly 4:00PM on Sturday 17th, do full backup(T-SQL) and put a database into single user mode. 2.) Copy both Saturday 4PM and Friday night full dump to the SAN. 3.) Delete WinNT4.0. 4.) Reinsta...more >>

Hi, I have this stored procedure that I need to run daily, how do I do this? Thanks, Mike <>< ...more >>

Hi, We have around 150 databases as case sensitive, and we are planning to change it to case insensitive. Each database has around 180 tables, I have changed the collation on DB, but changing collation manually on each column is a daunting process. Is there any script or tool which can assist...more >>

Can anyone tell me if you can display line numbers in the query window of SQL 2005 Management Studio and if so how do I go about doing it? Thanks a bunch. TFD ...more >>

Hi, When I click on the properties of a linked server, all the General properties are read - only, which means that if I want to edit any general properties I have to delete the linked server and recreate it. Needless to say this is a pain. Is this by design or some kind of bug? Is there a wo...more >>

Hi, I'm using ASP 3.0 and ADO with a web based MS SQLServer 2000 database.Web page forms collect criteria for SQL queries (dynamic SQL?). These are mostly Select queries to return inventory lists. Inventory details are posted by means of Insert Update and Delete queries. All connections use...more >>

Hello, I have the following error message in the sqlagent.out file, looping each minute. 2005-12-19 10:58:54 - ! [298] SQLServer Error: 14262, The specified @job_id ('254D5C3B-CB1F-4B02-AD79-FF5AFE343E3B') does not exist. [SQLSTATE 42000] (ConnExecuteCachableOp) I restarted the sqlagent ...more >>

Greetings, I am having some trouble with a trigger. This is my first attempt at creating a trigger so any help would be great. The function of the trigger is, on the insert of a row to check the value inserted into to column VEH_REPAIR_CODE. If that value is not 19, send an email to the value...more >>

Hi again, I have setup a maintenance plan schedule, my question is; can I create an additional plans located on another network location ? In my attempts the only locations displayed are those on the current server. thank you ...more >>

Wondering if there is a physical or realistic limitation to the number of UNION statements I can create in a query? I have a client with approx 250 tables - the data needs to be kept in seperate tables, but I need to be filtering them to create single results sets. Each table holds between 35,0...more >>

Hi, Is it possible to have many different clients conncecting to a web based server all using, simultaneously, the same DSN-less connection string held in a server side include file? Many thanks Ray Allison ...more >>

Hi all, Seems like a fundamental question to me but I dont have a definite answer for it, Gurus please enlighten me. I have a table 'Table1' whose structure changes dynamically based on some configuration values from another table. This table is being used by a program, It was initially ...more >>

I've stumbled across the above error and am a little stuck. I've just installed SQL2000 (sp3) on my PC and restored a database from our Live server. On a simple Update statement on a #temp table, it fails with the above message. I think I understand what it means and found some old posts sugge...more >>

A few years ago I wrote an active-X server to maintain a single connection to a file .mdb from multiple apps on same PC because I was having to many database curptions. Should I use the same Active-X server for the same in a MS SQL Server DSN connection or is it ok to have multiple apps from ...more >>

SQL BPA says the following: "One or more objects are referencing tables/views without specifying a schema! Performance and predictability of the application may be improved by specifying schema names." "When SQL Server looks up a table/view without a schema qualification, it first searches ...more >>

Greetings, I have an application that need to get all the user defined child tables first before their parents. I wrote a query, given in this newsgroup only, as below SELECT o.name FROM sysobjects o WHERE o.type='U' ORDER BY case WHEN exists ( SELECT * ...more >>

Hi, I'm attempting to connect to an Oracle database using SQL Server 2005 Express (OS is Windows XP Professional) and having absolutely no luck. Here is the information SQL Plus gives me about the database when I log in - Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit ...more >>

I have heard that machines running applications with embedded MSDE frequently experience conflicts between the MSDE apps and other applications such as BackupExec. What can anyone tell me about this? And if this is true, does/will the new SQL Server Express Edition behave better? ...more >>

HI, I have a table with IDENTITY column with the datatype as INTEGER. Now this table record count is almost reaching its limt. that is total record count is almost near to 2^31-1. It will reach the limit with in another one or two months. In order to avoid the arithmentic overflow error 8...more >>