hard to give any good advice, so many details will have to be found out;

the web server is probably in it's own DMZ, on a differnet subnet than the normal...

nope no issue at all;

they get installed in seperate directories, ie inside C:\Windows\Microsoft.NET\Framework64

you'll see V2.0.50727,v3.0,v3.5 and v4.0.30319

when you create a visual studio project, you can target which framework to use.

Sapen (8/7/2012)

---

Mine is setup the same way as shown in the image. But what permissions are you referring to? the user is a sysadmin on SQLServer but should it have...

also are you looking for session time outs,...

it probably depends on how you set up the linked server;

you can use the current login and pass it to the other server, if they have permissions, or you can...

any solution is going to involve some sort of convert text to date , or a hard coded CASE statement int he order by.

can you fix the incoming data to...

I've got 2012, and it looks to me like i can assign or replace keyboard shortcuts no problem.

Tools>> Options>> Keyboard might have a slightly different layout, but it's there for...

ahh, but with column level permissions, you get errors that says user does not have permission to object:column, instead of empty values.

it depends on what the OP wants in that...

that sql server should not be exposed to the internet, but simply accessible to the webserver; only the web server would have an outward facing ip.

without a programming language? i more than just doubt it; i think that will be the only way to do it.

check out this thread over on stackoverflow:

read pdf files programatrically

lots...

i have this saved in my snippets as a DR framework from a post that appeared on SSC fairly recently...I thought Simon provided a pretty good list of things to...

I'd start with slow running queries;

if you cannot change the app code, you might at least add indexes that will help.

here's a query for the top 20 slowest queries

SELECT TOP...

my fault; in 2008 this line raises an error:

I updated the script to correct the issue.

exec sp_trace_setfilter @traceidout,12,0,4, 50 ...

nagkarjun1 (8/6/2012)

---

How to know the ip address of the client application using the sql server?

Example: if an application database is located on a sql server, can we know the ip...

what have you tried so far?

this kind of looks like homework, so I'd prefer to help you learn how, rather than throw an answer out there.

you have more than one...