dudekula.kareemulla (5/19/2016)

---

Is there any possibility to give select privilege permission with out creating same user in another database??

Problem is i do not want create same user in another database in...

i think synonyms don't magically solve cross database chaining.

if User [Bob] has access to [db1], but a synonym in there points to [db2], you need to add [bob] to...

I like the direction Joie Andrews was going;

look at the job history, andn see how long it takes.(the duration column)

if you set it for every 15 minutes, but it takes...

kruezer had it right; without data and substantially more information, it's just a guess.

if i said 700 gig is required, and kruezer said 80 gig , who has the better...

Nope, John Mitchell is right; Registered Servers or Central...

forget about hiding the linked server...just make sure only specific users are mapped to use credentials that are valid on the linked server, so everyone ELSE is "not be made",

the...

becuase you want the total inline with details, you need your same data twice...once grouped by TransacitonId, and the original data.

here's your data as an example: the CTE at the...

since you compiled to an executable, you need to process the command line arguments in the c# app; did you configure it to do that yet?

what i'm thinking is that...

you should still review the indexes.

a classic...

not sure what you are using the results for, but with so many values, i'd consider creatign a table with the permutations of the parameters you are filtering for.

maybe something...

etl2016 (5/18/2016)

---

Hi,

Am new to MS environment, coming from a diff programming background.

I am setting up my home computer for a collection of MS development tools. Could you please let...

if you right click on SQL server Agent, and choose properties, what are the values you see here?

for me, with more than 60 jobs, some of them log backups ever...

Sean Lange (5/17/2016)

---

You will become familiar with both the backup and...

In my neck of the woods in South Florida, On Jun 18, 2016 I'll be at the SQLSaturday #524 - South Florida 2016

This event is ridiculously close to my house,...

I've seen this before due to connection pooling where the database context becomes the default database, instead of the one in the connection string;

ie the connection to the database...