well adding a user and granting permissions are a three part process.

first you really needed to already have a ROLE in your specific database that has the permissions you want...

yes, there is a built in stored procedure that will give the hierarchy of the schema based on foreign keys and dependencies.

this is what i typically use:

...

your if statement stuff would work, absolutely;

what i was implying, is you could possibly rebuild the synonym every time, something like this:

--Usage EXEC GetData 'SERVERNAME'

Create Procedure GetData(@WhichServer varchar(30))

AS

BEGIN --PROC

...

whole (3/25/2011)

---

hi,

i would like to create a synonym for all my sq server instances. which i can use them in my procedure to reference.

but my question is...

I'm sure dan is right...you can only test for a single value in the IIF condition, so you need nested IIf's to do the OR:

=iif(Parameters!PUBLICATION.value = 304,round(Fields!LASTWEEK.Value/5),IIF(Parameters!PUBLICATION.value = 305,round(Fields!LASTWEEK.Value/5),round(Fields!LASTWEEK.Value)

very similar to your other thread; not sure why you want to dynamically delete stuff, but here's an ugly example.

right ow, this is only printing the commands it might execute;...

diboy79 (3/25/2011)

---

my bank has change their account from 5 digit to 8 digit.

every account has been changed by adding '212' in the end of account number.ex:

11111 ----> 11111212

22222 ---->...

i thought avoiding the use of 1433 was to avoid brute force attacks to discover passwords....script kiddies or worse.

it looks like your procedure is recursively calling itself, correct? you might be hitting the max number of nesting levels or something;

I'm not sure what the proc is doing exactly...

dioscoredes (3/25/2011)

---

==>>what is the proc doing?

inserting a single row into a small table repeated

maybe 100 times. The proc quits silently after say 20

inserts. Tinkering shows any DML causes the premature...

what is the proc doing? if the proc is accessing anything outside of the database, it might be stopping/erroring due to permissions..you mentiond something about sqlcmd to fix stuff;

maybe when...

ok, here's a crappy example schema i slapped together, just as an example.

if you step thru to the end, you'll see that the view at the end will always have...

SQL handles concurrency very well and automatically; it automatically locks a row of data for the milliseconds it takes to update the row, releasing the row as soon as the...

And if the database is read only, you'll have to change it, change the collation, then change it back to read only again

Right click Dtabase....Properties

Select "Options" and scroll to the...

malleswarareddy_m (3/24/2011)

---

You guessed correct .I need a recursive cte but am getting dependencies using dynamic management function.

but it is not supporting to write the code for recursive ctes .

for example...