I'm trying to write a script that will go against sysprocesses (I think) and find the head of a blocking chain, and how many SPIDs it is blocking on down the line.
I found a reference to a script called head_blockers.sql in the Swynk Scripts database (posted March 2000), but the script appears to no longer be available for download.
Any help would be appreciated!
Thank you,
Susan Jones
I need to set up an alert to for when blocking happens. What condition do I use. I can't find the one that correlates to blocking.
Please help.
Much appraciated,
K
Hi,we're having a problem with SQL 2000 and Opta 2000 JDBC driverwhere there is large update running and at the same time,read is blocked for a while.We're looking for a way to catch this blocking processand if it last more than 10 minutes, then email or send out a message.I know sp_lock returns all current locksbut how do you know which one is blocking other processes?Thanks for your help in advance.
View 1 Replies View RelatedI see some time email say blocking took place and but it get resolved itself. how to find the history of batch/query which blocked another SPID?
View 3 Replies View RelatedI was trying to create stored proc
[code="create procedure dbo.sp_table1
@idint
as
begin
updatetable1
setisarchived = 1,
[Code] ....
But the query was continuously blocking the query below
updatetable1
setisarchived = 1,
modtime = getdate()
whereid = @id
andisarchived = 0
I was not sure, why the create procedure statement is blocking the update statement.
I want to implement a script which will run continuously to find out blocked sessions and send an email when ever it finds the blocking.
View 5 Replies View RelatedHello!
I try to execute the below statement on a column, I've been trying on a row where subType3 contains this string ",31,32,34,23,55,54,39,44,51,52," without the ",. The column is declared as varchar(MAX)
SELECT subType3 FROM aTable WHERE CONTAINS(subType3, '32')
The above statement executes and returns the result as expected, BUT if I execute this:
SELECT subType3 FROM aTable WHERE CONTAINS(subType3, '55')
then nothing is returned. I can't see any real pattern, 32, 34 and 54 returns the row. If I try with any of the others nothing is returned....Why is this?
I sort of need to use contains, if I dont wan't to start chopping up the string and patindex or something like that. Patindex works by the way, but when I have many values then it gets a bit cumbersome using anything else than contains.
Thanks for any and all help,
Cheers!
/Eskil
Hi all !
I have a table where there are a number of columns with varchar(20) and varchar(255).
I am looking at a table with 4 varchar(255) and 10 varchar(20) 's.
I have to estimates the size of the table.I can do that given the rowsize and the number of rows in the table.
My problem is what is the kind of over head that I need to take into account when I am dealing with a table with soo many variable length columns when calculating the row size?
What is the over head difference between char datatye and varchar datatype?
I can't go for char datatypes now.
Help and info regarding this is very much appreciated.
regards
Sush.
Hello
Is there a way to get the column head in query output.
Thanks
Question:
How do I return a list of items that matches one or more criteria that I pass in?
Background:
A user enters a sales lead (a company is looking for a place to have their event). That lead has a number of
criteria elements (start date, end date, city, region, maximum room rate, one or more amenities, etc. - more
details below) that should be used when trying to find Hotels that match that criteria. Obviously, some
criteria is more important than others (city, start and end date are more important than the maximum room
rate) - and it's unlikely that many (if any) of the Hotels will match *all* of the criteria entered by the
user. So, I'm looking to return a list of Hotels that match at least one of the criteria - if possible,
ordered by how many criteria elements match.
What makes this query particularly difficult, is that some of the criteria to match are stored in multiple
tables. For example, each Hotel has "Amenities" (Golf, Spa, etc.) - that are stored in a seperate table.
When a user enters a lead, they select which amenities they want to match. Also, a lead specifies a number
of rooms to block for each day between the Arrival and Departure date - these numbers can change from day
to day - but for this query - I think it's acceptible to get the largest number of rooms needed from any of
the days and compare that one number against the "MaxDailyRoomBlock" field of a Hotel (represented by the
"Property" table). Also, since a Hotel has different rates defined for each season, the query will have to
match the "MaxRate" against the rate of the correct season based on the Arrival and Departure dates. Also,
the rate can be within 20% of the stated "MaxRate".
Here are the following variables that will be passed into the query as criteria items:
RequestCity, RegionINDEID, ArrivalDate, DepartureDate, MaxRate, MaxTheaterSeating, MaxBanquetSeating,
MaxSchoolSeating, MaxBreakoutRooms, MaxRoomBlock
I know this is a huge post - and I sincerly appreciate any help you can provide.
DDL for Tables:
*In the DDL.txt attachment
Sample Data:
* In the data.txt attachment
Previous Attempts:
Unfortunately, I don't even know where to begin, so I haven't tried anything yet.
Expected Results:
PropertyIDNameNumOfMatches
-----------------------------------------------
1Marriot San Diego5
2Hilton San Diego3
3Hilton San Diego Downtown2
Thanks in advance, again...
I am the IS manager for a medium business. I am also the DBA and the programmer and help desk and trainer etc etc.
In 2003 I embarked on a project which went live in 2005. We contracted to have our order processing system rewritten into SQL. I went from a character based 4GL language called Progress running in a UNIX enviroment to a knock down, drag out, full blown microsoft solution. I have been operating this new system for two years making modest enhancements and improvements as my skills with microsoft are increasing and improving (retraining my brain to think objects)and hiring contractors to do the really cool fun stuff.
I have to learn Server 2003, SQL Server 2005, SQL Express, T-SQL, Replication, Reporting Services, SSIS, IIS, DTS, Visual Source Safe, Visual Studio, VB, C#, ADO.NET and the .NET Framework fits in here too although I don't really know where.
I hope you are starting to understand my feeling of being 'in over my head'. Right now everything is running perfect. I do backups, restore them and create new reports. Basic stuff.
On top of this our company has merged with a larger one and this bigger company does not have a microsoft solution. They have an AS400 home grown application that I do not want to learn. I will not go backwards!!!!! I will loose my job/position in the next couple of years. I want certifications (to get that interview).
I just don't have the skills to back up the certification (I don't want to be one of those exam cram people) I do a plethora of unrelated taks all day long. Not because I have to do them I choose to do them. I like both DBA and Programming.
So, if you were me, and could get certifications and have experience to back them up what would you do first?
I have a table that contains categories, users, modifydates . All three of those fields may be repeated many times.
I need to build a table that contains user, modifydate, oldcategory, newcategory, duration (number of days between modifydates when there is a category change)
I can use the min(modifydate) to get the 1st occurrence of each new category, but I am having trouble populating the oldvalue and then also getting the duration.
Adding to the complexity, I have to take the last entry of a null category prior to category being populated the first time and populate it with the first occurrence of category, Likewise, I have to populate the first occurrence of null after the last occurrence of a popoulated category. In other words, this simulates populated categories prior to first occurrence and after the last occurrence.
Any help would be great.
Log Shipping on SQL 2005 is failing because of a gap in the log chain. The schedule is every 15 minutes, the backup and copy jobs run without issue. The failure occurs early in the morning when there are no users, maintenance activities, or scheduled jobs - this has happened twice since we applied SP2. The database that is participating in the log shipping is approximately 20Gb, and recovery takes several hours.
Are there any known issues with log shipping on SP2? Any ideas why this might be happening? Is there any other information I can provide to help debug this issue?
I have an existing function and need to alter function to give result of the parent-description until its parent is reached.
--CREATE TABLE
CREATE TABLE [dbo].[CityData](
[Id] [int] NULL,
[ParentID] [int] NULL,
[City] [nchar](20) NULL,
[Location] [nchar](50) NULL,
[Amt] [int] NULL
) ON [PRIMARY]
[Code] ....
Hi
I have a huge matrix with 8 columns and then all the data that's generated when choosing a date span. These 8 columns are Topic, Salesperson, Company and so on and then the right part of the matrix grows with values for each month.
My problem is that there are no column headers for the first 8 columns!! How come?
What I did to resolve this was to put in a table in the top left cell and then write in the corresponding column header. This works €¦ in IE but not in PDF or Excel. And I really need it when I export it to Excel.
Any ideas?
Kind regards.
Hi!
Is it possible to use updategrams on chain relationships? When I try
I always get this message:
<?MSSQLError HResult="0x80004005" Source="Microsoft XML Extensions to
SQL Server" Description="There is an inconsistency in the schema
provided"?>
If you have got updategrams to work with chain relationships, please
let me know. Thanks for any help!
/Tomas
Server: Msg 8908, Level 22, State 6,
on index defragmentation on a table.
Table error: Database ID 490, object ID 517576882, index ID 0. Chain linkage mismatch. (1:13020)->next = (1:13021), but (1:13021)->prev = (1:13080).
from error.log found corresponding error on dbcc checkdatabase on this same database:
I/O error (bad page ID) detected during read at offset 0x00000006614000 in file
'T:DataABCABC_data.mdf'..
Waiting for type 0x4, current count 0x100022, current owning EC 0x76A85540.
Error: 823, Severity: 24, State: 2
is there a way to fix this chain linkage mismatch error?
thanks
-D
I have been throwing these lovely errors on my db (approx 16Gb) all of a sudden - they might all be related:
1) Operations Manager Critical Error Alert
Severity: Critical Error
Status: New
Source: MSSQLSERVER
Name: Attempt to fetch logical page belongs to different object .
Description: Error: 605, Severity: 21, State: 1
Attempt to fetch logical page (4:1878339) in database 'NGProd' belongs to object 'claim_requests', not to object 'Assessment_'.
2) Event Description:
Error: 644, Severity: 21, State: 5
Could not find the index entry for RID '36303030318eefd3713d52f4a85df3b0b8a889904e4e608102703230303530393139'
in index page (3:271543), index ID 9, database 'NGProd'.
3) Event Description:
Error: 8908, Severity: 22, State: 6
Table error: Database ID 10, object ID 86095893, index ID 0. Chain linkage mismatch. (4:1880687)->next = (4:441596), but (4:441596)->prev = (4:441595)
dbcc checkdb gives me 0 errors & running the built-in integrity reports does not seem to find anything.
I have been told that my db has "cracks" in it, and that I need to export ALL of it and then re-import. Seems a bit too much work...
Anyone have any ideas on what I should first attempt to do? I don't even know how to fix these errors... seems that I only throw then when users are accessing specific records.
Any help would be most welcome!
Thanks,
k
Hello :
I have a request which me dismissal 10 lines (normal select), I want to have quite lines in a single chain of character, separated one in the others by a comma:
A
B
C
D ------> A,B,C,D
What is that you have an idea for ca.
Thank you.
Data apx (5 million rows):
Span example:
-------------M---------------
___________-------------Rx-------------
Needs to b converted to this (ignore the underscore, used for spacing):
---M-------|-------M & Rx----|---Rx--
The time spans can slide either way.
Data example:
MemberID Eff_Date Term_Date Med_COB Rx_COB
1 20050101 20050912 Y N
1 20050310 20051120 N Y
1 20060101 <null> Y N
1 20060101 <null> N Y
Resulting Records need to be in this format:
MemberID Eff_Date Term_Date Med_COB Rx_COB
1 20050101 20050310 Y N
1 20050311 20050912 Y Y
1 20050913 20051120 N Y
1 20060101 <null> Y Y
Any help with this problem would be greatly appreciated. We are running SQL2K. I like most people,would like to stay away from cursors and loops if possible.
Thanks,
nemesis01
Here's My scenario,
I am using SQL2k5 with sp2. In have three branch stores in my site each with SQL 2k5 and a master server at headoffice also with SQL 2k5. The sales transactions for each store goes to a table called sales transaction. What I need is that the info from the sales transaction of each branch populate the sales transaction table at the head office, but not vice versa. That is to say the sales transaction table at each branch must have their information alone and no information from any other branch. Only the head office must have sales transactions from all branches in it's table. What type of replication do i use and how do i implement it?
Muchas muchas gracias.
Recently I have been getting a barrage of errors such as:
DESCRIPTION:Error: 8908, Severity: 22, State: 6
Table error: Database ID 16, object ID 1893581784, index ID 2. Chain
linkage mismatch. (1:17214)->next = (1:17060), but (1:17060)->prev =
(3:178).
and
DESCRIPTION:Error: 605, Severity: 21, State: 1
Attempt to fetch logical page (1:164756) in database 'Clients' belongs
to object 'activities', not to object 'entity_address_check'.
The problem began to originally manifest itself with a couple errors
similar to:
DESCRIPTION:Error: 605, Severity: 21, State: 1
Attempt to fetch logical page (1:4930) in database 'tempdb' belongs to
object '1732152167', not to object
'#allrowstable____________________________________ __________________________________________________ _________________000100003472'.
So far all of the errors have been isolated to indexes and I have been
able to repair the problems with CHECKDB fast_rebuild or by dropping
the index that is causing the error and recreating it. At times the
errors will appear for a couple hours overnight and then resolve
themselves before the morning. Originally the problem began to appear
on a single SQL Servers and now appears daily on all three SQL
Servers.
We've investigated whether the NOLOCK optimizer was the culprit but
out of all of our views and procedures there was nothing compiled with
that optimizer in any of the databases, so this seems an unlikely
cause (SEE http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B308886
)
We've reviewed IO on the servers, and nothing appears out of the
ordinary. We have even checked into the possibility of unreport IO
errors (SEE http://support.microsoft.com/default.aspx?scid=kb;en-us;826433&Product=sql2k
) but this still is inconclusive. HP did admit that their disc array
is not fully compatible with W2K Adv Server SP3, but the problem only
recently appeared and the upgrade to SP3 was completed nearly 2 months
ago.
We are running SQL Server 2000 EE, SP3 build 2195 on Windows 2000
Advanced Server. The server is setup as an A/P cluster on 2 HP
Proliant servers with a HP HTA200 disc array.
If anyone has any insight or suggestions, it would be great to hear
them.
I'm having a problem where I see consistency errors in my databases on a regular basis (at least twice a week).
I have several databases running on the same instance of SQL Server. During any given week, at least one of the databases will show consistency errors. At times, more than one at the same time will show these errors. These have odd effects on queries, sometimes making a SELECT (for instance) that should run in 5 seconds have to be killed after running for over an hour.
I'm running SQL Server 2000, version 8.00.194. The host OS is Windows 2000 with the latest service pack. RAID 5 is the storage solution.
Below are two DBCC outputs from different databases on the same machine. They are slightly different in that one starts out with "Parent node for page was not encountered"; and the other with "Page is missing a reference from previous page".
My hardware guys assure me there is no hardware failure going. I don't see anything that would suggest there is one in any of the event logs or in the Dell OpenManage system checks.
These DBCC errors are repairable without data loss, yet the databases have to be taken down to single user mode to do so (unacceptable during the day). But at the same time, certain operations in the database become impossible to perform when these errors crop up (such as the aforementioned infinite SELECT problem).
Any help in diagnosing why these pop up, or how to prevent them would be greatly appreciated.
The DBCC outputs:
-----------------------------------------
dbcc checkdb('ValidValues') with no_infomsgs
==========
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 3. Page (1:10921) is missing a reference from previous page (1:75359). Possible chain linkage problem.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 3. Page (1:75354) was not seen in the scan although its parent (1:75424) and previous (1:75352) refer to it. Check any previous errors.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 3. Index node page (1:75424), slot 19 refers to child page (1:75355) and previous child (1:75354), but they were not encountered.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 3. Index node page (1:75424), slot 20 refers to child page (1:75356) and previous child (1:75355), but they were not encountered.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 3. Index node page (1:75424), slot 21 refers to child page (1:75357) and previous child (1:75356), but they were not encountered.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 3. Index node page (1:75424), slot 22 refers to child page (1:75358) and previous child (1:75357), but they were not encountered.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 3. Index node page (1:75424), slot 23 refers to child page (1:75359) and previous child (1:75358), but they were not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Parent node for page (1:10931) was not encountered.
Server: Msg 8979, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Page (1:10932) is missing references from parent (unknown) and previous (page (1:75671)) nodes. Possible bad root entry in sysindexes.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Parent node for page (1:10933) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Parent node for page (1:10934) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Parent node for page (1:10937) was not encountered.
Server: Msg 8979, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Page (1:10940) is missing references from parent (unknown) and previous (page (0:0)) nodes. Possible bad root entry in sysindexes.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Parent node for page (1:10941) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Parent node for page (1:75664) was not encountered.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Index node page (0:0), slot 0 refers to child page (1:75665) and previous child (0:0), but they were not encountered.
Server: Msg 8981, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. The next pointer of (1:75664) refers to page (1:75666). Neither (1:75666) nor its parent were encountered. Possible bad chain linkage.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Parent node for page (1:75673) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Parent node for page (1:75674) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Parent node for page (1:75675) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Parent node for page (1:75676) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Parent node for page (1:75705) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Parent node for page (1:75706) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Parent node for page (1:75707) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Parent node for page (1:75708) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Parent node for page (1:75737) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Parent node for page (1:75738) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Parent node for page (1:75739) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 926626344, index ID 5. Parent node for page (1:75740) was not encountered.
CHECKDB found 0 allocation errors and 29 consistency errors in table 'Company' (object ID 926626344).
CHECKDB found 0 allocation errors and 29 consistency errors in database 'ValidValues'.
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (ValidValues ).
-----------------------------------------
dbcc checkdb('Revenue') with no_infomsgs
==========
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Parent node for page (1:110576) was not encountered.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Index node page (0:0), slot 0 refers to child page (1:110577) and previous child (0:0), but they were not encountered.
Server: Msg 8981, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. The next pointer of (1:110576) refers to page (1:110578). Neither (1:110578) nor its parent were encountered. Possible bad chain linkage.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Parent node for page (1:110585) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Parent node for page (1:110586) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Parent node for page (1:110587) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Parent node for page (1:110588) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Parent node for page (1:110617) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Parent node for page (1:110618) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Parent node for page (1:110619) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Parent node for page (1:110620) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Parent node for page (1:110649) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Parent node for page (1:110650) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Parent node for page (1:110651) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Parent node for page (1:110652) was not encountered.
Server: Msg 8979, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Page (1:124495) is missing references from parent (unknown) and previous (page (1:110581)) nodes. Possible bad root entry in sysindexes.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Parent node for page (1:124512) was not encountered.
Server: Msg 8979, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Page (1:124513) is missing references from parent (unknown) and previous (page (0:0)) nodes. Possible bad root entry in sysindexes.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Parent node for page (1:124521) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Parent node for page (1:124650) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Parent node for page (1:124651) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2089058478, index ID 2. Parent node for page (1:125214) was not encountered.
CHECKDB found 0 allocation errors and 22 consistency errors in table 'Operational_Reporting' (object ID 2089058478).
CHECKDB found 0 allocation errors and 22 consistency errors in database 'Revenue'.
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (Revenue ).
Hi All,
I was trying to install Sql Server Express 2005 using the setup made using Visual Studio 2005 Publisher Wizard, as a pre-requisite. During this i'm getting the following error...
"SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The certificate chain was issued by an authority that is not trusted."
What does this mean? Anyone is familiar with this, then pray please post a reply. I'm in the middle of nowhere now....
Thanks in Advance....
VigithVG
Hi
Just started using Visual Studio Express 2005 (Web) with Server 2005 Express and I am trying to extract the data from a SQL but cannot find how to connect to and open a SQL recordset so as to use the values of a single record dotted around a page. I would be using the values in the <Head> and <body> areas of the page. The body of the page would utilise standard data grids for sub and sub data, this being no problem.
Below is how I would have retrieved the "EndDate" value from an Access databse under asp.
Set Conn=Server.CreateObject("ADODB.Connection") Set rs=Server.CreateObject("ADODB.RecordSet") Conn.Open "DBQ=" & Server.MapPath("../private/Drapers.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};" rs.open "SELECT * FROM Products where ID = 44", Conn, 3, 3 rs("Metta1") rs("Metta2")
The following is from the Web.config file
<connectionStrings><add name="ConnectCB" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|CBBasic.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/></connectionStrings>
I have tried lots of things that were either code that was superceeded or just plainly didn't work.
Any help would be appreciated.
John
We are running SQL Server 2012 on Windows Server 2008. Just wondering what type of actions would break the backup-chain or backup sequence? For instance, if you have tlog backups being taken every 10 minutes and you stop the SQL Server Service for say 30 minutes. Would this action break the backup chain? Or would everything return to normal once the SQL Server Service is restarted?
View 7 Replies View RelatedOn our datawarehouse server we are regularly having a 1203 error, causing the sql-server to hang. We get this message in the errorlog: Failed Assertion = 'm_activeSdesList.Head () == NULL'. In the knowledgebase I found a bug description that is very lookalike to our problem.
Article: Q240853 FIX: Lock Escalation With Parallel Query May Cause 1203 Error And Server Shutdown
*** part of the article ***
SYMPTOMS
If a lock escalation occurs while running a parallel query, it is possible to encounter error message 1203 as follows:
spid7 Process 7 unlocking unowned resource: KEY: 13:117575457:2 (35010560ebcd)
spid7 Process 7 unlocking unowned resource: KEY: 13:117575457:2 (35010560ebcd)
spid7 Error: 1203, Severity: 20, State: 1
spid7 Process ID 7 attempting to unlock unowned resource KEY: 13:117575457:2 (35010560ebcd).
spid7 Error: 1203, Severity: 20, State: 1
spid7 Process ID 7 attempting to unlock unowned resource KEY: 13:117575457:2 (35010560ebcd).
The error message included in the error log probably mentions the same lock resource in several of the error messages.
Once the error is printed, an assertion message similar to the following is also printed:
1999-08-09 13:15:26.79 kernel SQL Server Assertion: File: <proc.c>, line=1866 Failed Assertion = 'm_activeSdesList.Head () == NULL'.
After a dump of the stack for all threads, the server initiates a shutdown of the SQL Server process.
...
*** end ***
You can find the complete article on: http://support.microsoft.com/support/kb/articles/q240/8/53.asp?LN=EN-US&SD=gn&FR=0
We can't use the workaround, because that would shut out parallelism, which is necessary for the project.
There is a fix, but in the article Microsoft says: "A supported fix that corrects this problem is now available from Microsoft, but it has not been fully regression tested and should be applied only to systems experiencing this specific problem.".
You understan,d this is not one of my favorite type of fixes...
Does anyone have already installed the fix mentioned? Had any problems with it, or did it cause some other troubles?
Thx,
Kurt De Cauwsemaecker
Database Administrator
Telepolis Antwerpen
If Transaction Log Backup fails due to a conflict could it break the Log Chain?
View 3 Replies View Related i have enable cross database chain,but it return error message:
The server principal "S-1-9-3-1149532189-1170944071-2610337685-3868961652." is not able to access the database "db2" under the current security context.
I list the sql script as follows:
Code Block
use master;
go
create database db1;
create database db2;
go
use db2
go
create table table1
(
col int
)
go
use db1
go
create user u1 without login
go
create proc p1
as
insert into db2.dbo.table1 values(1)
go
grant execute on p1 to u1
execute as user='u1'
exec p1
thanks
Hi.
I have problem executing several SSIS-packages in a chain.
To be more precise:
I have implemented a Biztalk 2006 application which via a local webservice executes an SSIS package. The package it self calls another SSIS package, which is located in the same folder as the calling package. The second package then calls a third package etc.
The problem arises, when the first package calls the second package. An Access Denied exception is received. Can any one explain me how to fix this?
The user connected to the application-pool that the weservice is running under, has execution-rights on all of the packages.
Thanks
I'm performing SQL Server native backups and Comvault Backups are breaking the backup chain?I can work around them if they only perfume 1 backup per day.We have a 3rd party hosting our servers so I do not have much control as to what they do.I have concerns about being able to get my databases Comvault being restored.
View 2 Replies View RelatedHi
I am trying to install SQL Server 2005 Express on my machine, which has Windows Server 2003 with Service Pack 1. I could not able to install properly and i am getting error always.
Here is the Error I am getting always "The certificate chain was issued by an authority that is not trusted" . I am trying for past few days i could not able to resolve.
Please help
Thanks
Here is the Error message from Summary.txt
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows Server 2003 family, Service Pack 1 (Build 3790)
Time : Tue Sep 05 12:31:18 2006
--------------------------------------------------------------------------------
Machine : SERVIDORCC
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Archivos de programaMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_SERVIDORCC_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}SSL Provider: The certificate chain was issued by an authority that is not trusted.
Error Number : 29515
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Tue Sep 05 17:12:41 2006
One sql transaction is in rollback state and optimization job is trying to restructure index on the same table that this transaction is using. As a result,
transaction is in 'blocking' state and optimization job is in 'blocked' state. 'Kill process' doesn't do anything. How can this situation be resolved?