Mits

Yap you can only debug stored procs in vs enterprise edition only, but you can also use query analyser to debug stored procs.

in QA right click on the stored proc...

hope this helps and make sure to put it to your briefcase.

http://www.sqlservercentral.com/columnists/dasanka/changemanagementinyourdatabase.asp

i also suggest that you should use table aliasing to make the code look neater.

you have to be running the sql server under a user defined user and not the local system account to be able to debug your stored procs.try to run the...

a bit of advice: if you will be writing the sql 2000 exam, there is a question with something along this principle, but using a different domain.

i will agree with lowell's suggestion. imagine when your boss calls and then says i want a report of all the printers or i want a report of all the...

thanks for the reply but i don't think that, that is where the problem is.

because when i changed

EE pen_Money,

AVC pen_Money

in the openxml part to

EE Money,

AVC Money

or

EE decimal(20,4),

AVC decimal(20,4)

the problem...

let me define the problem so that maybe you can be of greater help.

i have an sql db 2000 with a stored proc that reads an xml file.the file contains...

create another vehicle table. and as said above create the foreign keys.

and colleges do not have first and last name 🙂

why dont you use sql diagrams to help you with...

i also think encryption is one of the ways to solve this problem.also consider encrypting the stored procedures that are used to access the licenses db.

But why don't you use...

i used the date you provided as below

select convert(datetime,convert(varchar(50),'08/06/2005 15:44:52',126))

and i got this

2005-08-06 15:44:52.000

isn't this what you want

if it is then you can use the format i posted earlier.but put...

i have the same setup.

check for the connection dialog box, mine sometimes goes behind the query engine windows

what about setting the username and password on the dsn.

go to the dsn setup and click on the advanced button, put in the usrname & password.

try this one

SELECT *

FROM CallLogRevenuesBACKUP20050802 A

WHERE @PassedDate BETWEEN

convert(datetime,convert(varchar(12),A.dateOnlyStart,126))

AND

convert(datetime,convert(varchar(12),A.dateOnlyEnd,126))

You do not need to install iis for this.

you can just pass your xml file as a parameter of type ntext and then query it.

using the example in BOL on...