Hi , I get this error on my server event log "The identity of application pool, 'TestAppPool' is invalid ..." .. I donot have any idea about this error. Can you please guid me understant this error,and if possible what is cause and resolution. Thanks in advance...more >>

Is it possible to create a partitioned view on a table that has a text field in it (obviously not as a partitioning field)? I tried but I get the following error: "The text, ntext, or image data type cannot be selected as DISTINCT." I didn't see anything in the BOL about a restriction on table...more >>

Hi, I'm designing a database with this scenario: Our application will be used in big organization that each organization has some sub-organizations. Each sub-organization has divisions(each division can be beneath another division or beneath a sub-organization directly), each division has roles...more >>

hi, I am working on sql server 2000 replication. One of our sql servers has multipul publications that push out to several subscribers, and some of the subscribers are the database on the same publisher server. and I've encountered the following failures with only one of its publicati...more >>

I am designing an HR system and have the following solution for calculating duration of working days for absence. Please advise any obvious problems with the udfGetWorkingDays function and its use in the computed column in the AbsenceDetails table. IF EXISTS ( SELECT * FROM dbo.sy...more >>

There is a table: create table tmp (id1 int, id2 int) and some data in there: 1 2 1 3 1 4 1 5 2 1 2 1 2 1 10 11 11 10 10 22 How do I select unique id pairs where column order is not important? For example row values: 1-2 or 2-1 is the one unique pair. But 1-2,1-3,1-4 o...more >>

HI I have a question about truncate table: while working on Query analyser by mistake i have run the truncate command immediately it deleted all the data in the table. now i want the data back . how can i get it. Pls give ur value able solution. Thanks S Kaliyan ...more >>

I am currently trying to automatically perform and alter view by using a cursor. I know that most of the people that will reply is going to flame, but hey, this is how the boss wants it. Here's the deal, I am using a query to the information_schema.tables to retrieve all the table names that m...more >>

how can I have transaction over more than one procedure on the same database? one idea is to create new procedure, which runs all other procedure: CREATE PROCDURE procTran as BEGIN TRANSACTION exec procedure1 exec procedure2 exec procedure3 exec procedure4 COMMIT TRA...more >>

Hi, Can someone help me on my way to use dynamic parameters in a pass-through-query in access. I've some forms which are referenced in jet queries and need to be referenced in pass-through-queries. I tried to use the same approach with queries, but it didn't worked. If someone knows an a...more >>

Hi I have 2 tables, Rules table stores A set of rules and User Rules table stores the Rules assigned to the User. once i pass the UserID and Type ,I want the record set as follows RuleID, RuleName, IsAssigned (= 0 if that user is assigned that rule otherwise should be Null) I have written ...more >>

Hello: I am having some trouble I was hoping you might be able to help me with. Basically what I have is an Items table like this: Item | Colors ------------------- Chair | Red, Blue, Black Table | Red, Green, Blue Couch | Green, Yellow I need to run a query of some sort that c...more >>

Hi, I have a simple command.ExecuteNonQuery() to insert some data into the SQL DB. The data can be inserted, but the characters like '\n' are somehow stripped during the process. I want to keep it. My code looks like below. SqlCommand insertCommand = new SqlCommand(); SqlCommand comma...more >>

Hello! There are two tables to organize a tree structure. I need to populate these tables by data from XML-file. OPENXML would work fine, but what is the best technique using it in this case? I couldn't find how I can use OPENXML to organize a tree. Thank you! Sergey. Note: The...more >>

Is it possible get all dependencies of a stored procedure - that is: all views/tables used in the sp. It is to be used for part of documentation, so what I really need is a routine to do it for all sp's. I've looked at sp_depends, but it seems not to be "stabile"...can't figure out why. ...more >>

Gidday, there are several programs which give you a script to write a table - eg aspupload (createtable.sql) to include in your database, or indeed to create a complete database ... but I can't find where to run them from any thoughts? ron ...more >>

Hello World, May I ask how to reason the following: I have two queries which return exactly the same results (and 220 rows). I place the two queries and run a execution plan behind them. The one that takes 10 seconds by itself now with "Query cost (relative to the batch)" 92.44%, while ...more >>

Hi all. In a normal select. E.g SELECT ???? as Place, t.Name, Sum(t.OrderSum) as Ordered FROM t GROUP BY t.Name ORDER BY t.Ordered I Want a counter that indikates the place in the list. The name that has ordered the most numbered with 1 and so on.... ...more >>

How to get top 10 distinct OrderIDs in select like this USE NORTHWIND GO SELECT TOP 10 Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, [Order Details].ProductID, [Order Details].UnitPrice FROM Orders INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID ...more >>

Im trying to create an Index on a view and getting: Server: Msg 1936, Level 16, State 1, Line 1 Cannot index the view 'Northwind.dbo.tmpSpeed'. It contains one or more disallowed constructs. Whats the dealio? alter view tmpSpeed with schemabinding as SELECT Client.ClientKey, ...more >>

Ive got a Proc that takes way too long in Production. (30 seconds or more) It contains temp tables. The only way I could figure to get rid of them was to use a subquery. It worked but made the Proc even slower. Basically I was hoping someone could tell me how to re-write the proc in a way that im...more >>

A table can have 1,024 columns.But taking into consideration speed and design of the database, how many fields do you think a table can have? Thanks in advance....more >>

We have a SQL Server 2000 database that has about 10 million records. The database has 1 table, and the table has 3 columns. CREATE TABLE [dbo].[Packet] ( [PACKET_TIME] [datetime] NOT NULL , [PACKET_CONTRACT] [varchar] (8) NOT NULL , [PACKET_DATA] [varchar] (2000) NOT NULL ) I have a cluster...more >>

HI all, I want to build a stored procedure that executes 2 select queries where the second select query is dependent on the result of the first. The first select query reults in a row, that row needs to be inserted in the WHERE claus from the second select query. Someone knows how I have to...more >>

Hello, I would like to create a trigger on the table Mytable, for when the designstatus field is updated. If we are updating the design status to the value that it already is then we don't want the trigger to perform. I.e. if Mytable.designstatus = 2 and we try to update it to 2 t...more >>

Hello -- I think this is the term for what I want (something that could be generated in ACCESS using a pivot table, or, maybe Yukon). We have data for sales by sales people in sales regions. More than one person sells in a region. We want to display data as follows: ...more >>

I am trying to create a a foreign key contraint on a table. When I checked BOL, I gte Javascript errors when I want to see the code associated with thew following. Can someone help and post Sample code for the adding the constraint when creating a new table and also where the table already...more >>

Hi, Working on a t-sql project that will process a table prepared by a front end. The front end: 1) processes a spreadsheet whose contents vary each run 2) creates a sql server table 3) places the spreadsheet data into the table My client wants all the processing on the back end (t-sql). ...more >>

I'm trying to get this to work but it won't: CREATE TABLE #tmp_help ( Name NVARCHAR( 128 ), Owner NVARCHAR( 128 ), Object_type NVARCHAR( 31 ) ) INSERT #tmp_help EXEC sp_help -- or INSERT #tmp_help ( name, owner, object_type ) EXEC sp_help I've got the field definitions from sql ...more >>

I have a varchar stored as monyy and I need to convert it to a date. I have tried convert(datetime,'APR03',101) and that does not work. Any help is appreciated. Thanks...more >>

Hi, I have the table structure below: CREATE TABLE [dbo].[Companies] ( [CompanyID] [int] NOT NULL , [Company_Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Company_Owned_By] [int] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[Companies] ADD CONSTRAINT [PK_Compani...more >>

I have a VB program that calls a SQL Server stored procedure that insert to the database. This is what I do in VB: adoCon.execute "exec myInsertSP " & "@sContract='" & sContract & "'," & "@sData '=" & sData & "'" myInsertSP is: create procedure myInsertSP @sContract varchar(8), @sDat...more >>

Hi, here is the code to create 2 tables CREATE TABLE [tblAbsence] ( [intAbsID] [int] IDENTITY (1, 1) NOT NULL , [strLogonName] [varchar] (30) COLLATE Latin1_General_CI_AS NOT NULL , [intYear] [int] NOT NULL , [strAbsRsnCode] [varchar] (12) COLLATE Latin1_General_CI_AS NOT NULL , [dtmAbs...more >>

I hava a table which has ten digits representing datetime. I am not able to convert this number to datetime. Is there any way. I am really in need of this solution. Please, Help me. Thanks in advance. Looking forward for your cooperation. -- Message posted via http://www.sqlmonster.com...more >>

As I understand the issue of disappearing permissions in tempdb has been discussed widely however I failed to find a solution to my particular problem, hence I raise it again. I realize that tempdb is created each time the server comes up and it's copied from the model database, so no explan...more >>