Viewing 15 posts - 17,311 through 17,325 (of 59,067 total)
ffarouqi (7/4/2016)
It should be a simple HTML format...same as what they have shown in one of the examples in books online. Can you provide me with that formatting?Regards,
Feivel.
Formatting table output...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2016 at 6:44 am
kevaburg (7/5/2016)
The Problem is resolved.
The SQL Agent User had a different language Setting to that in the database. It was resolved by inserting SET LANGUAGE ENGLISH at the start...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2016 at 5:55 am
Here's my take on the problem. First, you need a Tally function. Here's my permutation of Itzik Ben-Gan's work. The "zero" thing needs a little work but...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2016 at 11:39 pm
Sergiy (7/4/2016)
rajemessage 14195 (7/3/2016)
please tel me some key words , show that i will search in my stored prcedureTRY -- CATCH ?
Or just BEGIN TRANSACTION?
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2016 at 8:10 pm
Duran (7/4/2016)
Hi Jeff,If it was just that on its own Id agree, but this is a small cog in a much larger automation scenario.
Regards,
D
What is the "much larger automation scenario"?...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2016 at 6:54 pm
jayoub (7/4/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2016 at 6:48 pm
leehbi (7/4/2016)
The bigger problem is that in the BI domain we're quite far from the App domain, hence...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2016 at 6:39 pm
Why anyone would use Posh to do such a trivial thing even across multiple databases is totally beyond me. My recommendation would be to go back to the simplicity...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2016 at 12:30 pm
p.s. The latter option sounds most likely... Your bloody CIO should already know what a bad idea you not having privs on the prod box is. He shouldn't...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2016 at 12:27 pm
Patience is a virtue here. When people ask me what I do as a DBA, I frequently tell them that it's too long to explain but they'll know for...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2016 at 12:24 pm
jeffe_verde (7/4/2016)
For those that...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2016 at 11:46 am
Phil Parkin (6/28/2016)
Jeff Moden (6/27/2016)
jeffe_verde (6/26/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2016 at 11:43 am
rkrpat (6/29/2016)
This is general question and not any Technical one.
Our SQL Server environment is stable and we are being chased for Service Improvements.
Could you please suggest any improvements that...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2016 at 11:05 pm
mario17 (6/27/2016)
I need to make global change in source code for sp for 200+ procedures, I did some python script for this, but now we decided that we need to...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2016 at 11:02 pm
ramana3327 (6/21/2016)
We are receiving continuous alerts about the alers. One of the insert statement is the main blockger.
I didn't get the permission to kill that spid
Do I need to...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2016 at 10:58 pm
Viewing 15 posts - 17,311 through 17,325 (of 59,067 total)