Sachin Vaidya (10/9/2009)

---

Hi All,

I have a script written for SQL 2000 database which gets the information about objects like, tables, stored procedures, user defined data types etc. I am looking...

Chi Chi Cabron (10/8/2009)

---

We have SQL Server 2000 and we run Blowfish as an extended procedure to encrypt/decrypt certain fields in the DB. That works fine, no issues there.

My...

Each new query window that you open from client (SSMS) would also add an entry there. I dont think there is any problem with that!.Thanks.

Did you debug your clr proc, is it working fine? could be that there is some problem inside that?

ihd doubt in line i copy & past below

(tbl_LeaveStatistics.Granted - isnull(tbl_LeaveStatistics.AlreadyUsed,0) - @Leavedetails)...

Most of your effort while doing an upgrade would go in testing! Get a dev/test environment (ss2k5) run upgrade advisor, test your application extensively, identify the problematic/pain areas(code), come up...

sql server console meaning sql server management studio?

Can you copy paste the code that you are running which is giving you the error here?

Yeah, thats true! As per BOL,

varchar [...

@hitendra, providing data like below would get you answers quickly,

Drop table #A

Drop table #B

Create table #A(Aid int, ProductID int, ProdQty int, ProdBalanceQty int)

Create table #B(BdetID int, Bid int, ...

Ian Scarlett (10/7/2009)

---

If I'm right in what I think you are trying to do, then either you are testing against the wrong table or you don't have the correct concept...

Is it throwing any error? which part of the code is not working? you are saying 'you can not insert the records into the second table' but I see you...

Just to add to what Elliott is saying, I guess you will have to convert the image file into bytes array and put it in memory stream and then update...

Just FYI, there was a discussion around similar problem I guess,

http://www.sqlservercentral.com/Forums/Topic795852-1291-1.aspx

Sorry it could sound bit obvious but still, is employee and driver different entities? If not I would keep it in one table and put check constraint.

Yes, I agree with Elliott. Dynamic sql should be the last resort for you. Thanks.