|
I have tried MSSQL 2000 server error handling part but I still have Error Message in SQL Analyzer. I called the procedure from the application and it failes because of Error Message. Is it possible to eliminate error message ?
|
|
|
|
|
Yes, fix the cause of the error!
You haven't given anyone much information to help, have you?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
hi all, this is a problem in SqlExpress when i insert a row by using ado.net in windows application .ado.net tell me that this row is inserted successfully but in sqlexpress table is not inserted why?
essampro
|
|
|
|
|
you could:
- make sure you commit the work if in a transaction
- try to isolate the error by trying to copying the command in the application right before you send to the database (in debug mode) and trying to execute directly on the database.
- make sure you're not using some kind of try-catch that could illude you of being sucessfully in the application
but anyway, how did ado.net told you the row was inserted?
Intelligence is almost useless for those who have nothing else!
Email: caiokf@gmail.com
|
|
|
|
|
hi caiokf,thanks for your attention.i would like to you that when i insert a row in sqlexpress by hand(without using ado.net) , a row is insert successfully .but when i use ado.net row is not inserted without giving any errors.i invite you to try this by yourself
EssamPro
|
|
|
|
|
can you post your code + the error you're getting?
and...are you using a stored procedure? or insert statement directly?
if it was the case, put your stored procedure
Regards
Intelligence is almost useless for those who have nothing else!
Email: caiokf@gmail.com
|
|
|
|
|
Check the Connection String, is UserInstance set to True ?
This may be the problem.
Google for an explanation.
I don't speak Idiot - please talk slowly and clearly
|
|
|
|
|
Hi all ,i want that sqlserver 2005 send to my applicationin c#.net notification or message after insertion a row
thanks
essampro
|
|
|
|
|
Can you be more specific on your question?
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
my database is having huge data and log files.
i want to know is if i shrink both data and log file then is there any data loss or harm to database?
can i shrink the master, tempdb database..??
Thank you
jayesh
|
|
|
|
|
Jes Talsaniya wrote: shrink both data and log file then is there any data loss or harm to database?
No and No
Jes Talsaniya wrote: can i shrink the master, tempdb database..??
Don't think so, and yes
Bob
Ashfield Consultants Ltd
|
|
|
|
|
This could be a very silly question, but here goes:
Our server is going to be down all weekend because of certain reasons.
Is there a way to move a sql server database onto a local machine?
thanks
The answers posted by me are suggestions only and cannot be used in anyway against me.
|
|
|
|
|
Detach/Attach. That'll be the least of your problems however. The real part is to migrate your applications/users to point to the local server until the main one is up.
|
|
|
|
|
As the previous post
Detach database
Copy DB files to your local machine
Atach those files
And change the connectionstring to point to the sqlserver instance in your local machine. I hope you are using connectionstrings from a web.config file (for web app) or saved the connectionstrings as a resource (for win app), Otherwise...too bad
Alexei Rodriguez
|
|
|
|
|
hi All,
how can i exclude the month of Auguest in sql server 2000?
this is what i did:
date < '2008-08-01' and date > '2008-08-31'
thanks all
|
|
|
|
|
Should be fine.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Thanks Bob, i worked out myslef, it should use or instead of and like this:
date < '2008-08-01' or date > '2008-08-31'
but still thanks
Andie
|
|
|
|
|
Sorry, misread. I thought your post already had OR , not AND
Bob
Ashfield Consultants Ltd
|
|
|
|
|
or
<br />
date <= '2008-08-01' and date >= '2008-08-31'
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Thanks i worked out myslef, it should use or instead of and like this:
date < '2008-08-01' or date > '2008-08-31'
but still thanks
Andie
|
|
|
|
|
listen, use this way instead
use function month()
declare @mydate smalldatetime
set @mydate = '1-6-2005'
select month(@mymonth)
if you run that you get 1
So, code like this:
if month(mydate) <> 8
begin
...
end
easyer
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
I am developing a software with SQL 2005 Express backend and i want to know how can i protect my databse from being viewed or modified by any DBMS?
|
|
|
|
|
Authorisation and authentication
Unless the app/dbms has the right credentials access is denied.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
By default, you can't do anything in the database unless you have the permissions to do so.
May be you need to get some introductory knowledge on SQL Server, in which case, get a book.
|
|
|
|