if you use profiler, filter it heavily so it impacts the server as little as possible (and takes up as little space as possible). and if you can, run it...

are you looking to do this on ALL stored procs or just certain ones? if all, then you'd probably be best off running a profiler trace against the server looking...

the best way to find out if the firewall is blocking you somehow is to turn it off entirely. if you're able to connect after you turn it off, then...

are you able to connect from any other machine (besides the server and the remote you're trying to connect from right now)? if you're using windows xp on the remote...

do you have tcp/ip enabled on the machine you're trying to connect from? do you have the right drivers available on the machine you're trying to connect from (have you...

are either (or both) tcp/ip and/or named pipes enabled on both the server and remote?

i apologize... i gave an incomplete connection string (i was on the phone getting some bad news). the complete string should be:

Provider=SQLNCLI.1;Password=*password*;Persist Security Info=True;User ID=*username*;Initial Catalog=*databasename*;Data Source=*servername*

here are a couple of options:

1. create a new data source, select OLE DB and use a connection string similar to the following:

Provider=SQLNCLI.1;Password=

2. click ok

3. if you get an...

can you supply the connection string?

there are always 1,001 ways to do it; here are 3:

1. capture the return value from sp2 and return it when sp1 finishes (but then you lose the return from...

are both BIDS and SSMS on the same machine? if so, i'd look at the connection you're using in BIDS... are you connecting as efficiently as possible (api used, user...

i don't think you can directly (but i could be wrong), but more importantly, why would you want to? in other words, if you pass the parameters from sp1 into...

Enable Named Pipes and/or TCP/IP

are you looking to track ANY query that's being executed, or are they stored procedures/functions?

one thing that comes to my mind right away is if it's a stored proc/function, you...

going forward, you can write an INSERT trigger that copies the ID from your table into another table that has a createdate field. this won't help you find the last...