for profiler, only users who have ALTER TRACE permission...

yeah, encryption can be confusing; I didn't know SSL was an added layer; so I learned something today; (as usual here on SSC) Thanks Eduard!

river by changing that flag...

SSL is an https connection for a web page, using port 443 by default. in theory, i can go to your web page via https, but your web server goes...

1.your trigger doesn't have SET NOCOUNT ON at the beginning, which is good practice and may avert other issues receiving "1 row(s) affected" and thinking it's a result set.

2.you are...

it sounds like you are developing in C# becasue of the error on the escape;, i think you need to use double slash to escape the string in that case:

Data...

river1 (2/6/2010)

---

But there is no problem with encrypting a connection because it uses SQL Server authentication instead of windowns authentication, correct?

Or i can only encrypt connection if they use windows...

just wrap the servername in brackets, the same way you do with TSQL reserved words:

Data Source=SQLSRVDEVNSMAIN;Database=pubs;Trusted_Connection=True;";

string connectionString =

"Data Source=[HENRY-PC\SQLSRVDEVNSMAIN];Database=pubs;Trusted_Connection=True;";

you could also switch to an ip\instance, or an ip port, which...

i think something like this might help you build what you are after?:

results:

Years Months Days ...

as i understand it, you should do this in two places;

you can make your server require encryption from everything connecting,a dnt he native client will handle it automatically:

SQL Server Configuration...

maybe something like this will help you model your calculation?

SELECT

SUM(

CASE WHEN property = 'prop1' THEN 1 ELSE 0 END

+ CASE WHEN property =...

i think this is what you are after;

the "description" field must be like the NAME, and the NAME must be like your search parameter:

so the "description" must be like '%WASH...

Tammy from what you describe, the CASE statement is working as it is supposed to, but not the way you want it to.

a case statement executes the first TRUE condition...

ha; Ramesh and i came up with identical solutions;

jordan i think this example might help;

i'm using the power of set based operations and the row_nubmer() function to generate the needed values;

check out the SELECT statem3ent...if you run it...

here you go;

this is using the FOR XML trick to concat your values together:

create table #temp

(

offerid int

, Catg varchar(100)

)

insert into #temp( offerid, Catg )

select 1, 'health' union all

select 1, 'fitness'...