Hello, I have this error message when I execute my stored procedure in SSMS: The statement has been terminated. Msg -2, Level 11, State 0, Line 0 Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. It happened every time I run th...more >>

I am trying to convert field value to the length from another table. Basically try to truncate the data so it will fit into another table. My question can I put the select statement in place for the length of the varchar? Ex... convert (varchar(100), Field_Value) SELECT Field_Value, ...more >>

Need assistance to solve the following problem:- Master_Ac Sub_Ac name balance 1 1A ABC 0 1 1B ABC 0 1 1C ABC 0 2 1A DEF 0 2 ...more >>

I know there are many strategies with pros and cons for each... that being said, To perform a full DB backup, followed by a full backup of the transaction log, with truncation, what is the best way to accomplish this. I typically create a backup script in the management studio and copy it to...more >>

On updating the aspnet_users table, I get an insert error. I've never seen an insert error on an update. 'Cannot insert duplicate key row in object' There doesn't seem to be any duplicates when do a standard select. Thanks Dwight ...more >>

I have the following tables and query CREATE TABLE [dbo].[PlayList] ( [PlayListId] [uniqueidentifier] NOT NULL, [UserId] [uniqueidentifier] NOT NULL, [Comment] [varchar](1000) ) CREATE TABLE [dbo].[PlayListRating]( [PlayListId] [uniqueidentifier] NOT NULL, [RatedBy] [uniqueidentifi...more >>

I am trying to use VBScript to automate some commands like DBCC, Backup, etc. for a SQL server and then e-mail the results of those commands. Since these commands do not return ADODB "record sets" where do I access the results of these commands? All the Execute methods either a closed record ...more >>

I'm getting an error in visual studio that states I have too many arguements in my stored procedure, is there a way around this limitation? If not what is the best way to write to 30 columns? Thanks, -- Luke Davis, MCSE: Security DEM Networks - Senior Systems Architect 7225 N First, S...more >>

I'm having trouble coding a parameter string that I want to use in a IN clause later in a SQL Query. For an example, Select theName, theAddress, thePhone FROM aTable WHERE theName IN ('Jay', 'Chris', 'Kris') In the real query I want to use a Parameter but I can't seem to get the string...more >>

I have a block of code in a SQL statement that is protected by a version check using an IF statement. I want the entire thing to be re-runable and it compiles, but it fails on the second run through, even though it does not go into the IF block. For example (pseudo code): IF NOT EXIST...more >>

Inside a trigger ... - How I detected changes in records using the inserted/deleted tables? - What if the primary key changes? Thanks!...more >>

I was using this construction to delete some "duplicate" records from a table: Delete From TransStagingLoad From TransStagingLoad Inner Join (Select SSN_TIN, Acct_Number, Seq_Num, Trade_Date, Max(Settle_Date) As MaxSettle_Date From TransStagingLoad Group By SSN_TIN, Acct_Number, Seq_Num,...more >>

Anyone know how to find the number of processors available to the server? I can't fine anything in BOL - looked thru SERVERPROPERTY, system functions, and system stored procs to no avail. What I'm trying to do is run one process per processor. If you know any other ways to accomplish that I...more >>

CREATE TABLE [dbo].[price_change_all]( [ARTICLE] [decimal](18, 0) NULL, [STORE] [varchar](4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [VND_NO] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [BASE_COST] [decimal](11, 2) NULL, [NET_COST] [decimal](11, 2) NULL, [CREATE_DT] [date...more >>

Hi How to partition a table in sql server 2000? One my table is having 4545000 rows. Its performance is very poor. Is there any way to partition it as we do in SQL Sever 2005? BB ...more >>

Can I use the CASE function in the ORDER BY clause? I'd like to use either one or the other ORDER BY clause based on a criteria... something like this: ::::::::::::::::::::: ORDER BY CASE WHEN PCode<>'XXX' THEN A.col1,A.col2,A.col3,A.col4,A.col5 ELSE A.col1,A.col2,A.col5 END ...more >>

Hello, I would appreciate any insight into this issue. A table contains the following data (XCount only applies to items of type 1 and YCount only applies to items of type 2): ItemID ItemTypeID XCount YCount -------------------------------------------- 1 1 ...more >>

Two tables, both of which have a column called ID (char(10)). In table A, there are 1000 rows. Table B has over 2 million rows, but also contains rows which should match those of Table A. However it only contains 909 rows attributable to Table B. select count(*) from TableA a left outer jo...more >>

i'm trying to figure out who has the application lock on a particular resource. For example EXECUTE sp_getapplock @Resource = 'Edit Ticket {3259AA76-8F02-4361-B224-1422E57C6BAE}', @LockMode = 'Exclusive', @LockOwner = 'Session' The command(s) completed successfully....more >>

Hello, I have been reading the posts and have found them very useful and have found a way to sort my results in the order that I want either by using ORDER BY CASE or CHARINDEX. However, I am getting an error because I am using SELECT DISTINCT TOP 100 in the same stmt. If I remove DISTINCT th...more >>

I'm using sql 2000 and Access 2003. I have a Lname, Fname and Init fields. I'm using the following to create a Name field: ([Lname] + ', ' + [Fname] + ' ' + [Init]) If the employee has an init everthing works fine but if they don't have an init the name field is blank. I've tried this i...more >>

Recently I have noticed that I cannot see what is in a DTS local package on our SQL 2000 Server using Enterprise Manager. I don't know what was updated, but I can click on them but not see anything. I know there are items in there, but now I cannot see any of them. I cannot see any of the ...more >>

Hi. I have a table (table1) with an ID which relates to an ID value in another table (table2). However, in table2, there is often more than 1 record with that ID. Take the following example: Table1: Table1ID Table2ID 1 1 2 2 Table2: Table2ID ...more >>

Because my production server is Standard Edition, I want my local instance running Developer Edition to have only the features from Standard Edition. I want my local instance to raise the same errors as my production does whenever I try to use Enterprise Edition features. How to do that? TIA ...more >>

Hi. I have a table (table1) with an ID which relates to an ID value in another table (table2). However, in table2, there is often more than 1 record with that ID. Take the following example: Table1: Table1ID Table2ID 1 1 2 2 Table2: Table2ID ...more >>

Hello all. Got a quick question. In SQL 2K, there was a tool called 'Object Search' that you could use to search the entire db for an object (table, view, triggers, column, etc). I can't seem to find the 'Object Search' in SQL 2K5, or any tool/feature similar. Any ideas? TIA, Roz...more >>

Hi I have this query that updates all entries, but I want to update just one (doesn;t matter which, if that helps) update FOO SET Location='Z' from FOO join BAR on FOO.titleID = BAR.TitleID and FOO.Location in ('A','B','C') NB I only want to update one row in foo...more >>

I have an ActiveX component that lets me connect to a SMTP server but I'd like to avoid all those calls to sp_AOxxx. CLR is supposedly taking the place of Extended Stored Procedures (of which several SMTP-oriented dlls exist). Has anyone implemented the equivalent via CLR code?...more >>

....as opposed to being accessed by name. SQL Server 2005 Express In the same fashion that I can get the name of the current sproc via: SET @ProcName = OBJECT_NAME(@@PROCID) I'd like to get the values of all input parameters of a given sproc _without_ hardcoding the @param name. (i'm try...more >>

Hi: I want to know how to get the percentages of "Yes" values relative to the total count of records for each month. So i have a table: DateCol YNCol Jan 1, 8:34 Yes Jan 2, 9:55 No Jan30, 10:20 Yes And I want something to mimic this (I'm using a made up functio...more >>

Hello folks! I'm building a where clause that looks like this (you can copy and run this in your Query.Analyzer...it will return the sql statement) Declare @Model varchar(50) Declare @Customer varchar(50) Declare @AircraftType varchar(50) Declare @b tinyint Declare @SQL varchar(1000) Dec...more >>

I am trying to create a chart in a reporting tool. The requirement is to display the date in 'MON-YY' format. So, I used the following function to get it. REPLACE(RIGHT(CONVERT(VARCHAR(9), [Availability Month], 6), 6), ' ', '-') But what happens is that the result is text. So when the ch...more >>

I have declared an INSTEAD OF DELETE trigger on my table. First: I want to know what criteria was mentioned after WHERE clause in origional update statement. I want to add this criteria in another statemnt of the trigger. Second: What if multiple row is going to be affected by origional ...more >>

Hi. My organisation has three tiers - head office, area office, branch. There is one server for head office, one for each of 17 areas, the area servers having databases for area office and all branches in the area. Entities are regularly transferred between branches, each transfer involving s...more >>

hi guys, how can i create 1-to-1-relationship in MS sql server 2000? i tried using the drag and drop in the table diagram but it only allows me to create 1-to-many relationship type. do i need to do it programmatically via query analyzer? regards. ...more >>

can u list me the bugs of sql 2000 that are fixed in sql 2005...more >>

Hi, I'm sure this is a stupid error but I can't get a simple join to work. 2 tables; USR_AS400_SUPPORT & TS_STATES. The common field is called TS_ID. I want to get the TS_NAME field from TS_STATES, and the TS_IssueID and TS_tittle fields from USR_AS400_SUPPORT. My query looks like this: ...more >>

Hi, In my SQL Server 2000, the TableA has an integer type field NoToCarry, and the TableB has integer type field TotalNo. Can I set up the contraint for the TableA, so TableA's NoToCarry must not bigger than TableB's TotalNo? Thanks for help. Jason ...more >>

Hello guru. how can I pass a table variable to a stored procedure the procedure is going to call itself..(Nested sort of.) the nesting would be at the max 4 levels ...more >>

Hi, i have this huge sp below that when I update using ADO.NET it returns 2 rows affected. I am supposedly only updating one row as I specify the primary key. Any ideas please rotsey CREATE PROCEDURE sp_tbrnet_updateEmployees ( @EmployeeID int, @EmployeeNumber varchar(30), @Firs...more >>

Everything was working fine until suddenly this problem appeared from nowhere: Boot up the pc and go into SQL Server Management Studio. The database is present and the data can be accessed. Go into VB2005 Express and run the project. Everything works fine. Open Database Explorer and c...more >>

Dear All, I am developing a DBase that has Arabic Datafields, and i am implementing a search mechanism, so i want to use the LIKE command. But it never returns any data although i am sure that the data is there... any suggestions? SELECT G_id, S_id, A_id, G_Description, G_Title FROM ...more >>

I stored a .rtf file in a ntext datatype field. After some time i want to move the rtf format file to some other column with .txt format. Please any one help me. Regards, R.Sathiamoorthy ...more >>

I have a table called "CustomerContacts" that stores when staff an interest in an organisation. In the app I need to display all organisations with checkboxes unticked if the there is no record & ticked if there is a record , for any particular contact. So I need a query that I can just add ...more >>

I dynamically create my query based on filter criteria , order by criteria and paging criterias. I have no promlem at that point. My problem is that How can i get total record number of my recordset in stored procedure. What is the best way to get it. Should i use and output parameter in st...more >>