I had not seen that technique, Roger.

Thanks for the link!

your issue is integer division;

in sql server, if you divide an integer by an integer, you get an integer...bot a decimal that you might get in a programming language.

so 99/100...

you can test whether the synonym exists in the proc and bailout if necessary.

Create Procedure DoStuff

AS

BEGIN

IF (SELECT OBJECT_ID('REMOTETABLE','SN')) IS NULL

RAISERROR('Required Synonym [REMOTETABLE] does not exist!',16,1)

--do stuff

END --PROC

how many objects are being accessed via the linked server?

you might consider creating synonyms for the objects. if there is a zillion of them, or dynamic SQL is being used,t...

I'm sorry, i'm completely uninformed on that and i have no idea .

in my 2008 dev version,...

i added your filter to a trace and used my tool to script it back out;

--#################################################################################################

--begin filter definitions

--#################################################################################################

-- WHERE 1 = 1

exec sp_trace_setfilter @traceidout,3,0,1,32767 -- AND...

Ben you can grant that special user like this:

GRANT EXECUTE ON sprocRefresh TO SPECIALUSER

do not grant anything else.

as long as sprocClear or sprocPopulate are owned by the same schema(ie they...

yep, the grant here does it:

--allow the users to see view proc and function definitions

Grant View Definition ON SCHEMA::[dbo] To [MyDevelopers]

you...

checkai (2/29/2012)

---

I want to create a "Developer" role within SQL 2008. The role should be allowed to read anything, and view the definitions of SPs/Functions, etc. I do not want...

look in the powershell forum here on SSC;

there's a large number of posts showing how to script out a whole database; then with powershell you can schedule it to...

i have this saved in my snippets; not interview questions, but dba responsibilities that you should be intimitely familiar with to make it thru an interview unscathed:

I especially like some...

Cadavre (2/29/2012)

---

Lowell (2/29/2012)

---

Cadavre my friend how do you script your clr to be the binary string like that?

what's the trick?

i've only done it manually so far, nd it's a...

Cadavre my friend how do you script your...

that query is selecting everything from the WebProxyLog table, no WHERE statement to tune;

it takes any network time to return 630 meg of data.

do you need to return all...

Gianluca Sartori (2/28/2012)

---

varchar would be a better choice. I highly doubt you will ever need to...