Viewing 15 posts - 316 through 330 (of 7,631 total)
Sorry, I can't figure out what your question is?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 24, 2012 at 5:39 pm
chetanr.jain (5/24/2012)
...Somehow, it is logging below error :
MSI (s) (40:C0) [16:01:06:705]: SOURCEMGMT: Trying source \\lhrdbs0106\d$\SQLMedia\SQL2005\Setup\.
...
That sure doesn't look like an error..?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 24, 2012 at 5:36 pm
I suspect that this has more to do with the client settings than the server's.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 24, 2012 at 5:27 pm
Try it like this:
WITH XMLNAMESPACES (DEFAULT 'http://schemas.microsoft.com/sqlserver/2004/07/showplan')
SELECT
DB_NAME(qp.dbid) as 'database_name'
,REPLACE(SUBSTRING(st.text, PATINDEX('%CREATE %PROCEDURE%', st.text), 100), CHAR(13) + CHAR(10), ' ') 'Stored Procedure Name'
,REPLACE(
SUBSTRING(
st.text
,(qs.statement_start_offset/2) + 1
,((case qs.statement_end_offset when -1 then datalength(text)...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 24, 2012 at 5:24 pm
I am not sure that we can help you very much without more details or a more concrete example/question.
I can say however that in general, SQL Server does not push...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 24, 2012 at 4:56 pm
My guess would be that it has to do with security issues and configuration.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 24, 2012 at 4:44 pm
What industry are you coming from? Did they have DW templates there? I ask only because I have seen very few DW templates and I would be very...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 24, 2012 at 4:41 pm
Really?
"Here's 120+ lines of SQL. What happens if there's an error on Line #45?"
Brutal. Seriously.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 22, 2012 at 9:46 pm
Methew (5/21/2012)
.DAT files can only be opened by the application that created them. There is no indication which application created the file and there is no need to open .DAT...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 22, 2012 at 8:29 pm
I'm not sure, but I think that that message is complaining about not being able to load the driver/provider required by the connection string and/or the source file. Since...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 21, 2012 at 9:51 pm
Are there any other SQL Server instances on these two servers? Is it possible that you are actually connecting (or trying) to one of them and that SQL instance...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 21, 2012 at 9:39 pm
It's in the Client Tools SDK. This link explains how to install it: HERE
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 21, 2012 at 9:16 am
Formatting:
declare @Sectionid int=1984
DECLARE @Assessments nvarchar(max), @Total nvarchar(max)
SELECT @Assessments =
STUFF(
(
...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 21, 2012 at 9:12 am
swint002 (5/21/2012)
Just to make it a bit different and extend game play 🙂
Not my point. My point is that you should include the rules to your game with the...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 21, 2012 at 8:44 am
RBarryYoung (5/21/2012)
rstringer (5/21/2012)
No firewalls in this environment.
Windows has a software firewall built into the OS. You need to check that on the Server that is running your SQL Server...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 21, 2012 at 8:40 am
Viewing 15 posts - 316 through 330 (of 7,631 total)