Database

The problem ( or my be not ) is that you need administrator right to perform hard or soft maintenance in XP SO. and I want avoid that maintenance team have access to the databases. As we know BUILTIN\Administrator is derived from windows access rights. I've created a Sql login account with sysadmin rights but i can't to change permissions of BUILTIN\Administrator( for ex. avoid to init session). I don't know how do that..... thanks.

That's one magic number that I shouldn't have missed :wtf: I are Troll :)

Then I would think the function is a CLR function and there is a bug in there. Never having used the CLR in SQL Server I do not know how you debug such a beast. Never underestimate the power of human stupidity RAH

You should probably check with your dba :). One possibility could be the logs are full, another may be that you are waiting on a lock... Which DBMS are you using? Which version, and what is the SQL error number you are getting?

Thank you very much for your valuable response.

yes, but I bet there is a where clause, so are those columns indexed? Its far too complex to do in a fotrum without any table defs, index defs, usage stats etc etc. Run your query through query analyser and look at the execution plan, that should at least give you some clues. Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

How many rows are in the table? How many fields? What kind of data is it? Are your indices appropriate for the way you are wanting to extract the data? Can you update the structure to improve the performance or are you stuck with it? I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!

Access and SQL Server will both be fine as a back end then... I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!

I'm waiting for a reply, but I don't have a backup, and my response will be then you don't have a client!

Type everything back in from scratch?

I use the same approach because it helps clarify my intent but as you say it actually doesn't have any impact upon the query. The Sql Server Query Optimizer will determine the most efficient route based on the latest statistics.

A very good reference book for this subject is Inside Microsoft® SQL Server® 2008: T-SQL Querying[^] only two letters away from being an asset

Thank you, I'm sorry not to be able to help, I have not used Oracle in a decade or so. Never underestimate the power of human stupidity RAH

That is a very large topic, you are not going to get an sensible answer in a forum post, as softie said try Google [^]as the first step in your research. Never underestimate the power of human stupidity RAH

A more efficient statement would be this. update Table set field = new_value where PK = (select min(PK) from Table) only two letters away from being an asset

Here is a rough idea of how you could design a time keeping database ... Table: Timecard_Header HID - Primary key Auto generated sequence number. (Header ID) EMPID - Key to the employee table TCDATE - Timecard date TIME_IN - Datetimestamp of when the timecard begins (shift start) Include the date portion incase the shift begins at 11pm and runs across midnight TIME_OUT - Datetimestamp Table: Timecard_Details DID - Primary key. Sequence number (detail ID) HID - Foreign key reference back to the header record TIME_START - Beginning time for this time slice TIME_END - Ending time for this time slice TDTYPE - Timecard deail type (Use this to indicate Work, Break, Absence, etc) TDCODE - Used as a further explaination of the type, for example Absence - Vacation or Absence - Jury duty PCODE - Paycode (0 - Unpaid, 1 - Regular pay, 2 - Overtime, 3 - Doubletime, etc) PRate - Pay rate show the actual rate paid for this time slice. $10/hr Regular pay or $15 / hr for overtime This should give you an idea of one way of looking at the data, you should extend this model to meet your requirements.

I wasn't sure about the spelling. Hence I checked in google and got the results. Although I did not bothered to look down the page. It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

The suggestion given does exactly what you want it to do.

I could if I wanted to, but it doesn't help. The problem is that once the SQL server is reporting to be started to the SCM, it still hasn't made all databases online yet (only the master database is available). That work progresses after the SCM has been signalled that the service is running. I found the solution to be easier than I thought. All I have to do is to SELECT COUNT(*) FROM sys.databases WHERE name=@database_name AND state_desc='online' and see if it returns 0 or 1. Once the database manager reports the database as online, it is possible to use the database. -- Kein Mitleid Für Die Mehrheit

Sorry, I wasn't sure where to post since half of what I'm looking for is setting up the database for the product page and the other half is displaying it on the page. I looked at that link and I already know how to set that up. It's when links are clicked and I need a product page with 4-8 descriptions of the product that has me stumped. I guess I'll ask this over at the asp.net section. Thanks for your help.