Viewing 15 posts - 1,096 through 1,110 (of 5,111 total)
I'd start by asking why he needs it. In an ideal world, developers wouldn't have any access to live systems, and certainly not elevated permissions like he's asking for....
April 18, 2019 at 11:55 am
Are you talking from experience here, or in the event of? If the latter your developer shouldn't have access to be able to DROP a production database; they are developers...
April 18, 2019 at 11:49 am
The normal (non-dynamic) way you would achieve this would be with a something called a Cross-Pivot. Like the below (note I have changed the objects to persisted objects, due to...
April 18, 2019 at 11:23 am
Thanks for the updates Steve. We all appreciate the ongoing work and it's nice to hear the state of play. I assume that things will slow down a little bit...
April 17, 2019 at 10:04 pm
4.I still don't see mine. And I don't see the picture/icon of the person.
Do you mean this page? I got there by clicking your username in the left,...
April 17, 2019 at 5:45 pm
Hi Thom, The database which I am currently working is not supporting the ROW_NUMBER() OVER (PARTITION BY schema_id ORDER BY [name]) clause. so I am checking any alternatives to these...
April 17, 2019 at 11:18 am
Are there any other errors as well? SSIS often produces multiple errors, especially with an error like that. An error like that is normally accompanied by another.
April 17, 2019 at 11:03 am
Could you elaborate here? Why does ROW_NUMBER not serve the requirement? You could use COUNT with a ROWS BETWEEN clause, but why reinvent the wheel?
SELECT [name],
...
April 17, 2019 at 11:00 am
As long as it's not Section 31 masquerading as the Obsidian Order masquerading as the Tal Shiar masquerading as the Ghost of Captain Cutler, we should be fine....
April 16, 2019 at 10:53 am
Latest Topics is latest topic, not latest replies (what I have posted here is a reply, not a topic). That actually makes sense. For the most recently active topics (aka...
April 15, 2019 at 3:18 pm
solved the problem
What was the solution, out of interest?
April 15, 2019 at 3:11 pm
This is the first I heard of the 'website issues' forum. I'll see if I can copy and paste it there.
It's been there for as long as I can...
April 15, 2019 at 2:40 pm
Ha Ha, look at that post, you can't tell my original from Sean's to my reply to Sean's. Horrible.
Put them the bugs in the Website Issues forum, then...
April 15, 2019 at 2:26 pm
I'm heartbroken here. The Corgi Completion Contest "discussion" hyperlink leads to the article on data compression (https://www.sqlservercentral.com/editorials/data-compression-double-take). <sniff><sniff>WAAAAAGGHHHH! @=(
I think something must be broken then, as I've had several...
April 15, 2019 at 1:22 pm
Viewing 15 posts - 1,096 through 1,110 (of 5,111 total)