|
how to get sql server 2005 last execution time? is there any system store procedure? plz help...
|
|
|
|
|
You could always find some way to look in the log file. Not sure if this is how you want to do it...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi all,
I have an application which uses MS Access, SQL Server and MYSQL as back ends
Only one connection is opened at a time
My problem is,
when i tried to open the my sql connection after closing an MS Access connection it shows the following error message, but no problem with the SQL Server
Cannot start your application. The workgroup information file is missing or opened exclusively by another user
I am using Connection15::Open to open the connection
I used same connection object to open all connection
Thanks
Sivan
www.ktsinfotech.com
|
|
|
|
|
I think that your connection string is not good.
Try and find another connection string.
I have a question: mysql works before you start access?
|
|
|
|
|
Yes If i started my sql at first then it works
i connected to my sql before connecting to ms access
but whenever i tried to connect to my sql after closing a connection to ms access then it shows this message
i am using the same connection object to connect to all these databases
my connection string is
"DRIVER={MySQL ODBC 3.51 Driver};Server=My Databasee server;DATABASE=My database;UID=My user name(root); pwd=my password"
pls correct me if there is anything wrong in this connection string
I'm using an odbc driver to connect to my sql(MySQL ODBC 3.51) with ADO
thanks
www.ktsinfotech.com
|
|
|
|
|
The text, ntext, or image data type cannot be selected as DISTINCT.
how to solve this problem
|
|
|
|
|
The best way to do this is to place your text/image type in a separate table and then reference them through an FK which can be handled with SELECT DISTINCT.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Is there any single query to remove all tables, triggers, stored procedures in oracle DB?
Best Regards,
Mushq
Mushtaque Ahmed Nizamani
Software Engineer
Ultimus Pakistan
|
|
|
|
|
DROP DATABASE dbname. Of course that also drops the database, but without the tables, triggers, etc..., it's just taking up space anyway.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
I generally try to keep all of an application's tables, triggers, procedures, etc.. owned by a user that I refer to as a schema owner. This provides the ability at some point to
<br />
DROP USER <application_name> CASCADE; and everything is gone. This can especially come in handy with creating a backup database, complete with up to date data using an export file from a production database.
Chris Meech
I am Canadian. [heard in a local bar]
|
|
|
|
|
Hi,
Lets say I have 2 tables, DEALER and CARS whereby DEALER describes the details of the car dealer and CARS describes the details of the cars
that are for sale in a car dealer. So this implies that DEALER has many details of car dealers and CARS has many details of cars. So am I right in suggesting this is a many to many relationship since more than 1 dealer can sell the same car? If so how do I convert my tables so that I only have a one to many relationship?
Thanks for any information.
|
|
|
|
|
The normal method is to use a link table. Here's an example:
(Table dealer)
DealerID (PK)
DealerName
(Table car)
CarID (PK)
CarName
(Table DealerCars)
DealerID (FK to Dealer.DealerID)
CarID (FK to Car.CarID)
Note that these are really terrible field names, but they serve to get the point across. The car and dealer tables have no direct relationships. Instead, the link table describes the relationship between the two.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
When you break down a many-to-many relationship, you get two one-to-many relationships.
|
|
|
|
|
i have a table "Activity" contains two column "personid1" "personid2". i have to select those two column with the personname from person table.
how should i write the query?
I am Entry level person
|
|
|
|
|
can you please provide structure of both tables with sampledata
Regards
KP
|
|
|
|
|
something like that:
select a.personid1, a.personid2, p1.name, p2.name
from Activity a join person p1 on a.personid1 = p1.id join person p2 on a.personid2 = p2.id
(didn't test it though)
Furthermore, I suggest reading a book about SQL 
-^-^-^-^-^-
no risk no funk ................... please vote ------>
|
|
|
|
|
Activity Table: tblActivity
PersonId1
PersonId2
Person Table : tblPerson
PersonId
PersonName
Sql Stmt :
SELECT
A.PersonId1,
(Select PersonName from tblPerson P where P.PersonId = A.PersonId1)AS Person_Name1,
A.PersonId2,
(Select PersonName from tblPerson P where P.PersonId = A.PersonId2)AS Person_Name2
FROM tblActivity A
Regards
John
|
|
|
|
|
in the database i have a table for complains and to solve the complain 24hrs are given.if the time is expired i want to db to generate an E-mail and send it to manager .
i'm planning to do this by using a trigger. if it is possible to do how to impliment this other wise could you please suggest how to do it ,
|
|
|
|
|
Trigger's are probably used against a database operation like Insert, Update, Delete. Not when a job is failed.
Why not try with Sql Server Agent and the extended stored procedure xp_sendmail.
Sql server has the ability to send mail without being triggered from the application. you can set up a job through Sql Server agent that wakes up and check's at proper intervals whether any job is failed and if yes then send's email.
Regards
John
|
|
|
|
|
i have a dedicated table "Emails" with columns: "From","To","Subject","Text"
The table has trigger on insert that calls a xp_sendmail
Any time i need to send an email fron anywhere all i have to do is insert a record in that table!
|
|
|
|
|
Hi all,
I have problem to pass a value from one parameter to other parameters on my report.
On my report I have 3 parameters, year as integer, DateStart as datetime, DateEnd as datetime.
Is anyone know how to set the display value of the Datestart as (1/1/selectedyear) and DateEnd (12/31/selectyear) bases on the selection of the year and the calendar control will show next to the DateStart and DateEnd?
btw, I am using SSRS 2005 reporting services.
Thanks for your help.
Sue
|
|
|
|
|
Anybody know of a good way to do this? Basically, I want to take something like the following table:
12/12/2005 10998
12/12/2005 11000
And return something like this:
12/12/2005 10998,11000
I'd love to see an aggregate, though I'm sure nothing like the following exists:
Select
[Date]
,Concat(id, ',')
From
Table1
Group By
[Date]
Kyosa Jamie Nordmeyer - Taekwondo Yi (2nd) Dan
Portland, Oregon, USA
www.defaultn.com
|
|
|
|
|
|
Awesome tip! Thanks a ton. I plugged it in and it works like a charm!
Kyosa Jamie Nordmeyer - Taekwondo Yi (2nd) Dan
Portland, Oregon, USA
www.defaultn.com
|
|
|
|
|
I want to study database from a to z coz i havegot a project any book
SAS
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
