Any clue as why SSMS Intellisence did not catch that and underline them?

If there is an error up there, it will throw out an odd message like the one that...

Sorry about the color formatting. I am trying it again.

Andrew

SELECT

a.GRGR_CK

, a.GRGR_ID

, a.GRGR_NAME

, s.SBSB_ID

, s.SBSB_LAST_NAME

, s.SBSB_FIRST_NAME

, e.CLCL_ID

, e.CLCL_CUR_STS

, e.CLST_MCTR_REAS

, e.CLCL_CL_TYPE

, e.CLCL_RECD_DT

, GETDATE() AS today

, e.Age

,CASE

WHEN e.Age <= 15 THEN...

One thing that I see is that you are using an alias that does not exist, as far as I can find "s"

SELECT

a.GRGR_CK

, a.GRGR_ID

, a.GRGR_NAME

, s.SBSB_ID

, s.SBSB_LAST_NAME

, s.SBSB_FIRST_NAME

, e.CLCL_ID

,...

No, I try to never use a View unless absolutely necessary.

Andrew SQLDBA

That is one reason that I never use that Directory. I always use a directory on different drives.

Like "SQL 2008 Databases\[DatabaseName]"

I have never liked that directory of Program Files....

Thanks Gila

That is exactly what I resorted too. I was hoping there was a simple way 😀

I created the table manually on the other file group, and now inserting rows...

I just went the old slow route and created the table manually and now filling it via insert into statements.

Thanks Any way

Andrew SQLDBA

Hello Everyone

I found out that one Must use BIDS 2012, or what ever name it has now, to convert the 2008 package(s) before they can be used in SSIS 2012....

I think that what you have on your website is not really what I need. I am looking for a command line for pulling the package from a SQL store,...

Thank You Earland, that was it!! Mine had gotten set to "True".

Greatly appreciate that.

Have a nice weekend

Andrew SQLDBA

Does anyone have a clue how to turn this off in SSMS? I want to see only the content of the stored procedure, not all the dependent objects that the...

Why would I not want too? They are taking up memory and cpu

Andrew

There are some users that connect using SSMS that leave it open after not logging out of the remote session correctly. That is the biggest thing I want to kill

Andrew...

It will not affect the app at all.

Andrew

Hey Gila

The application is not closing them. I need to kill them if they are a couple days old. Also, there are some users that connect using SSMS that leave...