GilaMonster (10/8/2009)

---

GSquared (10/8/2009)

---

On the other hand, I'd consider it a positive if it started with, "I haven't had to do that, so I'm not sure, but what I'd start with...

OP is

a) an idiot for thinking he can pull it off for any amount of time

b) morally reprehensible

c) in italy

its point c there that has stopped me from being worried...

david.l.mulholland (9/30/2009)

---

I think I'll give slang's suggestion a try. It seems like it will work. I had thought about doing the multiple openqueries, but I'd still have to juggle multiple...

I have a sql 2005 sp2 box right here, I created a sproc and it appeared under programability/stored procedures.. not under system stored procedures..

can you give me an example of...

im with jeff on this.. i dont think they work any better.. cursors are a horrible horrible solution for the most part.. the only plus to oracles over sql that...

ahh i see now.. doh

what PP- said.. you can't USE a variable.. you have to build it into a string and execute the string..

annoying from time to time.. but oh well 🙂

memorizing questions to answers is no substitute for real world experience..

take an entry level position and learn from someone who knows.. devour BOL and any other source you can get...

i dont even see a question here..?

in sql management studio, you can expand your database, then expand views, then expand system_views..

thats where it'll be..

you'll have to query it from a New Query window though..

USE myDB

GO

SELECT *...

Can you list a couple of rows of data that you think it should return?

Also, what parameters are you passing to the stored proc?

a sql trace over x days/weeks/years could be pretty painful though i'd have thought?

theres always the painfully obvious, put an insert into a table at the start of each sproc..

not the most efficient way to do it though 🙂

I believe you can try:

SELECT SERVERPROPERTY ('edition') as [Product Edition]

64 Bit should say Standard Edition (64 Bit)/Enterprise Edition (64 Bit) in the text, 32 bit will just say Standard Edition...

Thanks guys..

I think I've been relying on the maintenance plans a bit too much lately (time constraints more than anything).. i think i'll just bite the bullet, mark off a...