to go that deep, you'd need to execute the procedure, capture the execution plan, and parse the xml out to get it down to the column level;

the queries in the...

nope.

in 2005, i believe only actual objects that...

take a look at this DMV, and run this in the database you think has external references:

i think this view is supposed to populate with values, even if the object...

the screenshot i provided is an example of where the only people using the linked server are explicitly defined in a list; my sa example int he first like is...

for non clustered instances, these two techniques are working great for me, as long as i have RDP to the machine:

without stopping and starting the services, byusing sysinternals psexec to...

are you sure?

based on the error, i'd think thatthe columns for

dbo.postcodes.Latitude and dbo.postcodes.Longitude

are being converted to match the data type for @Radians(float)

are they possible decimals or varchars?

I have a couple of examples saved in my snippets.

here's an example of finding points that are within 5 US Miles; you can change the constants to be in kilometers...

check each of your linked servers, and make sure the option for this part is "not be made" or "be made using the logins current security context" if you are...

i can't say which is a best practice, but i'll throw out what strategy we use.

for startup services, we create a domain account mydomain\SQLMaster, and that is the user used...

yes you can, but you'll have to use dynamic SQL to hold the command for creating the functions/procedures.

IF EXISTS(SELECT 1 FROM sys.columns WHERE object_Name(object_id) = 'CriticalTable' and name = 'SpecificColumn')

...

probably we'll need more information.

creating server roles is available in 2012 and above, you probably mean "if i add a login, i want to add him to a server role(or...

the other question i'd like to see thrown into the mix is what do you REALLY need to track?

do you really need to know that Lowell modified these x rows,...

SQLHeap (2/24/2014)

---

SQLRNNR (2/24/2014)

---

The best method for that is to have the prod database servers segmented away from the dev servers via firewall/router. Then have firewall rules preventing access between...

SQLHeap (2/24/2014)

---

So, I have this developer that created a job on a dev server that executes a number of ssis packages that I handed over and he/she didn't change any...

yocki (2/23/2014)

---

Dear masters,

I have a stored procedure (SP) that contains "EXEC xp_cmdshell eror msg >>D:\logfile.txt, no_output"

Whenever i call/run the SP, via .NET App and SSMS directly, using user that...