AFAIK, varchars under (8000) chars are handled the same; no performance difference when they are included with the rest of the data you are selecting...unless you are SEARCHING tha...

the default Express does not include SSMS; you need the "2008 with Advanced Services"

http://www.microsoft.com/downloads/en/details.aspx?FamilyId=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en

install that, and you'll have the "Express" version of SSMS; it doesn't allow you to open anything...

it depends on what you mean.

access and rights to objects are tied to a login.

if you give me a login, i can use any application i want to...

you forgot how the proc works! the question mark is substituted with the dbname!

db_name() function will keep returning master or whatever db...

the OBJECT_NAME function has a second , optional parameter for the db_id for exactly this reason;

this works in 2005 and above;

sp_msforeachdb '

select

object_name(s.object_id,db_id(''?'')),

s.*, p.*

from ?.sys.sql_modules s

...

As long as you are working with real date or datetime variables, SQL has a suite of built in functions to get the pieces you are after:

/*--results

MO ...

Megistal (12/9/2010)

---

Is it possible in SSRS r2 to pass a table parameter to a stored procedure having a UDDT in it's parameter list?

can SSRS r2 calling a procedure like this?:

CREATE...

that's the database you want to connect to.

The name "Initial Catalog" implies that you can switch to other databases after the connection, and your SQL commands could use use 3...

avoid using varchar(max) unless you need it...since you are doing substrings, you know you can use something smaller.

if there is more than one row in the table, you cannot guarantee...

i believe the IN statements can bail out as soon as a single value is found in V_LOAD_COMBINATION ;

when you join the tables, the join would perform better if there...

still digesting the question, but i took the time to apply a macro on your sample data for anyone who needs it:

SELECT '1' AS ID,'1' AS Priority,'1' AS Active,'Small Storage'...

As Gsquared implied, it is perfectly normal to encounter a situation where you have to insert both Parent and then Child information into two different tables...since this is the whole...

here's a prototype to start testing with; i don't know what happens when people connect with named pipes; i assume the ip address is null, but you'll want to check...

i think the problem is when you are comparing @email. it is looking for an exact match...no wildcards.

i think it should be this:

IF @Email LIKE '%@xxxyx'

are you REALLy testing for...

the windows firewall is the best place to do the blocking; it's also possible that you could create a logon trigger and block by Ip/hostname inside that trigger, if you...