Ahhh Haaa

That is it!! Thank You.

I was going crazy trying to find that.

Andrew SQLDBA

That is it, for the one database.

I was looking for the table that stored the size for each database on the particular box.

Unless I am mistaken, and I had to...

I am a SQL DBA at a pretty large company. I just asked one of the Oracle DBA's about the cost of a single license. There is no set amount....

Thanks Paul

I was trying to use a Table Variable, and it was not working. Using a temp table worked perfect

Thanks

Andrew SQLDBA

I finally figured that out the hard way. LOL

Thanks

Andrew SQLDBA

You know, I think the version that I am using here in the office does not have the Breakpoint , Locals and Watch windows.

I am using MS Visual Studio 2008...

Very nice, I will try both. I do like the Watch window. But I will keep the Message box code handy as well

Thanks everyone

Andrew SQLDBA

I was just readying about how to set a Breakpoint and see the variable in the Watch window.

I used to have to do this in DTS. I am getting used...

Perfect

Thank you so much.

For some things, DTS was much easier. But I love SSIS so much better.

Andrew SQLDBA

Thanks Phil

I never even thought of that. How silly of me

Andrew SQLDBA

I have no problem in doing that, actually looking at the XML. What I was wondering, is there a way to turn the XML code, into the Solution or project,...

Yes, that is what I am after.

One is allowed to to store multiple values in the database?

We have a single SSIS server, and that is all that is on that...

That is not true, with SQL Server, I am able to store as many different connection strings in a single table, in a single database.

I am just not sure how...

It really depends on what the client wants to see. How the database is designed, and how you are writing the query.

Sounds as if there was no planning on the...

Why would you want to store them twice, they are already being stored in a table.

SELECT

p.name

,c.Text

FROM

syscomments c

JOIN

sys.procedures p

ON

c.id = p.object_id

Andrew SQLDBA