Viewing 15 posts - 6,496 through 6,510 (of 13,874 total)
SQLHeap (10/18/2016)
October 18, 2016 at 11:59 am
sqlfriends (10/18/2016)
yes, sometimes I use stored procedure to return result.So for those, I give user the public role, and grant execute to the stored procedure.
Is that OK?
Thanks,
Not the best....
October 18, 2016 at 11:07 am
ZZartin (10/18/2016)
The easiest way is probably just to add them to the db_datareader group in the database. Assuming you don't need any more granular permissions.
I'd create an AD group,...
October 18, 2016 at 11:06 am
ChrisM@Work (10/18/2016)
mitzyturbo (10/18/2016)
Sorry Chris, forgot to attach the indexesHappy enough to go with the TOP 1 in a CROSS APPLY
Thanks anyway
Here's the ROW_NUMBER version. I think the index I posted...
October 18, 2016 at 10:12 am
dbaforever (10/18/2016)
In the Integration Services 2014 Project Conversion Wizard, it shows Package Status "Not Loaded", "One or more packages are not ready".
Also "Cannot create a task for XML...
October 18, 2016 at 10:09 am
Misha_SQL (11/17/2014)
Quick question...
October 18, 2016 at 9:23 am
sindhupavani123 (10/18/2016)
I need to write a query for teachers who dont have classes on a particular day.
like ex: name, day, courseid
Mary, MON, Science
Surya, TUE ,Maths
Mary, TUE ,Biology
The teacher teach...
October 18, 2016 at 7:57 am
river1 (10/18/2016)
Hello,The ssis as a loop also. It is a forearm loop container.
A what?
October 18, 2016 at 6:53 am
ChrisM@Work (10/18/2016)
BLOB_EATER (10/18/2016)
Grant Fritchey (10/18/2016)
Evidently stating the obvious when others are stating the opposite is not allowed amongst...
October 18, 2016 at 6:51 am
Wow. It's clear from the amount of detail included in your post that you've tried very hard to make this work. I feel your pain.
If you increase the polling interval,...
October 18, 2016 at 5:56 am
river1 (10/18/2016)
The ssis package was not done by me. But the for loop that exists in the spring should be fast. Faster then cursor, correct?
I have no idea how spring,...
October 18, 2016 at 5:41 am
dbaforever (10/17/2016)
October 17, 2016 at 6:07 pm
river1 (10/17/2016)
October 17, 2016 at 3:42 pm
You should also be aware that it runs against the system databases (master, model etc.)
October 17, 2016 at 3:23 pm
This command runs in its own context. What that means is that you have to put all of the SQL - including the variable declarations - into your variable and...
October 17, 2016 at 3:22 pm
Viewing 15 posts - 6,496 through 6,510 (of 13,874 total)