|
Kasic Slobodan wrote: Like I said, when I run a application and go back to MS Server Manager and refresh, the stored procedure is gone (any other procedures is still present), like I have roll back transaction (for that procedure) or something like that.
Just a wee thought - Stored procedures with names starting with "sp" are reserved by SQL Server to refer to system stored procedures. This may or may not be part of the problem (I've never used the convention of starting stored procedure names with an "sp" so I don't know the results)
|
|
|
|
|
I've tried removing sp prefix, but no luck. Same error, same stored procedure.
|
|
|
|
|
Just a thought - save the SP, and then verify that it is present. Stop the database engine and start it again, then verify that it is still present. If it isn't then it looks as though it is being rolled back.
Once you have done this, you can then run your application. What I would do as well, is to check your code to make sure that you don't have anything in your code that executes a DROP PROCEDURE command.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
I did what you told me.
After stopping MSSql Server and running it again, sp wasn't beign deleted, but when I was run my application, error raise again, and sp was removed from database.
Iam not aware of any code/command that I have put in any part of my application that should delete sp.
Only drop procedure is in procedure decralation.
Iam trully confused...
|
|
|
|
|
That wouldn't do it. When SQL Server sees SPs starting with sp_ the engine looks in Master first before looking for yours.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
You should be able to use the SQL Profiler[^] to figure out what is deleting the stored procedure.
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
Unfortunatly, I don't know how to use it  .
|
|
|
|
|
Slobodane nisam video da li si dodelio ko je owner sp
|
|
|
|
|
Ako mislis na [dbo].[proc_name], to nisam, ali sam probao i tako i opet nece.
Ne verujem da bi to bio problem, jer ostale procedure rade :?.
|
|
|
|
|
Svaki problem koji je resen nije vise problem...
Ja na 2000 nemam takvih problema a na 2005 jos nisam presao
Pozdrav
|
|
|
|
|
Nisam ni ja imao problema sa MSSQL05 do sada...
Ma, sigurno je neka glupost u pitanju. Obicno bude tako.
Pozdrav.
|
|
|
|
|
Solved!
My colleague has noticed that Iam missing GO statement after each stored procedure, so every procedure that is last, will not work.
And, yeah, thanks everyone for your time...
|
|
|
|
|
Hi,
I want to Fetch all user table's name and imformation from my MS Access DataBase using ASP.net 2.0 and C#...
I tried with msysobjects but it shows error retraiving problem form database in ASP.NET 2.0
Is there Any Idea or Other Way
Thanks in advance...
Viral
|
|
|
|
|
|
Is there any way to update a table columns automatically. For example:
We have a table(tblFirm) which columns are: FirmName,IsOpen
And another table(tblTime) which stores time information: OpenTime,CloseTime
What i want to do ; between the time intervals of OpenTime&CloseTime , DB will automatically set IsOpen's value to true, otherwise false. Is there anyway to do this?
Happy Coding...
.:: Something is Wrong ::.
|
|
|
|
|
This is better handled with a VIEW. I very rarely store duplicated or calculated data in a table. I only violate this rule when a frequently run query would be greatly enhanced. In psuedo-code on SQL Server it would look something like this:
CREATE VIEW FirmOpen
AS
SELECT
FirmName,
CASE
GETDATE() BETWEEN OpenTime AND CloseTime THEN 1
ELSE 0
END AS IsOpen
FROM
tblFirm
INNER JOIN
tblTime
ON (tblFirm.FirmName = tblTime.FirmName)
You will need to modify the INNER JOIN to reflect your foreign keys and handle the Date/Time calculations correctly. Once complete, you can use the FirmOpen like any other table (except in the case of UPDATE/INSERT).
If you still want to field to update automatically, you will need tocreate a SQL Job that does the UPDATE and schedule it to run every minute (poor choice in my opinion).
|
|
|
|
|
query for retrieving duplicate rows in a table?
|
|
|
|
|
select * from <tablename> where <columnname> in(select <columnname> from <tablename> group by <columnname> having count(<columnname>)>1)
G.Praveen Kumar.
|
|
|
|
|
select * from gopi6 where ename in(select ename from gopi6 group by ename having count(ename)>1)
Hi
|
|
|
|
|
I want to get only one row(first one) when multiple rows are present in a table.....
e.g
Prof ID -- Item -- Date
1 -- Mango -- 1-1-2005
1 -- Orange -- 2-1-2005
1 -- Apple -- 3-1-2005
2 -- Orange -- 2-1-2005
2 -- Apple -- 3-1-2005
I want this result:
Prof ID -- Item -- Date
1 -- Mango -- 1-1-2005
2 -- Orange -- 2-1-2005
Do good and have good.
|
|
|
|
|
That depends on your idea of what is first. Strictly speaking the rows in a database have no order although the underlying database software will put the data in a certain order it should always be thought of as unordered because the software may change and the previously implied order with it.
So, given that a database is an unordered set of data, how do you define first? What do you want to put in the ORDER BY clause? Then we can figure out how to get the first of each series.
|
|
|
|
|
infact i want to get just one record against "Prof ID". Order is not necessary here....
Waiting for reply
Do good and have good.
|
|
|
|
|
Use simplest way that is GROUP BY option
Regards
R.Arockiapathinathan
|
|
|
|
|
I have 3 tables with period history field. the Period will be replaced with each end of the month in current year.
so: Period01 = January 31, 2006 and Period12 = December 31, 2006
Here are the fields of each of them:
Vendors (Vendor_ID, Purchase_Period01, Purchase_Period02 , ... , Purchase_Period12,
Payments_Period01, Payments_Period02 , ... , Payments_Period12
)
Items (Item_ID, UnitSold_Period01 , ... , UnitSold_Period12 ,
Sales_Period01 , ... , Sales_Period12 ,
UnitReceived_Period01 , ... , UnitReceived_Period12 ,
Cost_Period01 , ... , Cost_Period12 ,
UnitDamaged_Period01 , ... , UnitDamaged_Period12 ,
Loss_Period01, ... , Loss_Period12
)
Accounts (CoA_ID, Debits_Period01, ... , Debits_Period12 ,
Credits_Period01, ... , Credits_Period12 ,
Activity_Period01, ... , Activity_Period12 ,
Balance_Period01, ... , Balance_Period12
)
My Question is: Do all Tables above is in Normal Form?
If not, can you help me make those Tables in Normal Form?
I would like to compact those Tables' Field design so that those tables consist of as little as possible of Period Fields..?
Thanks for the help..
Dogma: I :am goD
|
|
|
|
|
Tomy1402 wrote: Do all Tables above is in Normal Form?
Which particular normal form are you looking for? There are 7 (if I remember correctly) in total.
It appears to conform to the first normal form - All pieces of data are separated into their own column. (e.g. Name="Colin Mackay" does not conform, FirstName="Colin", Surname="Mackay" does conform)
It appears to conform to the second normal form - All tables have a primary key
It appears to conform to the third normal form - All non-key columns depend on the primary key.
It does not conform to the fourth normal form - The table should not contain repeating columns.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
