Viewing 15 posts - 256 through 270 (of 7,631 total)
mrichardson 57577 (5/28/2012)
but it worked ok before as the same name on sql2000.
I realise now, it might not be good...
[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 28, 2012 at 10:54 am
Symbol assignment statements like this:
select @uweid = id from #temp1
will not work the way that you think they do when there is more than one row returned. Try putting...
[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 28, 2012 at 10:18 am
mrichardson 57577 (5/28/2012)
yeah, I have changed the web.config in 2 places.here is a sample of my web.config:
<add name="SiteMyNamedServer connectionString="Data Source=123.45.67.89;Initial Catalog=NIGEL;user ID=NIGEL;Password=MyPasswd" />
</connectionStrings>
<appSettings>
<add key="SiteMyNamedServer value="Data Source=123.45.67.89;Initial Catalog=NIGEL;user ID=NIGEL;Password=MyPasswd" />
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 28, 2012 at 10:00 am
Andy Hyslop (5/28/2012)
so please spare me the 'Post your SQL' spankings
Not a good way to ask for help or advice!! 😉
...
Yes indeed! Nothing forestalls a good spanking from us...
[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 28, 2012 at 9:18 am
Did you check that your DNN connection strings have been changed to the new server correctly? IIRC, there is more than one place in the .CONFIG file for DNN...
[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 28, 2012 at 9:09 am
You really should consider SQL Server Replication for this. It is tailor-made for just this situation.
[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 28, 2012 at 9:06 am
One thing I'd recommend is not to exclude the system databases from these stats. I guess you could exclude [model], but the other three all have configurations/cases where they...
[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 28, 2012 at 9:00 am
Here's a simple non-Cursor, non-loop way to do it, to save your eyes:
DECLARE @tab TABLE (Reference NVARCHAR(10), ObjectName SYSNAME)
INSERT INTO @tab
SELECT 'Direct',
...
[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 28, 2012 at 8:53 am
MadTester (5/28/2012)
I am appealing 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 28, 2012 at 8:44 am
Stewart:
Actually, the site at your link has another link to this site: (http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/validate-a-url-from-sql-server.aspx) which does demonstrate a way to do it entirely from within SQL using OA Automation objects.
[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 28, 2012 at 8:28 am
Oops, I just noticed a mistake in my code. Try it like this instead:
CREATE TRIGGER InventLow on PurchaseOrder
For update
AS
BEGIN
-- SET NOCOUNT ON...
[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 28, 2012 at 5:46 am
weisen678 (5/28/2012)
SS I also have another concern, because the quantity still < 150, will this trigger keep insert?
This will only INSERT a new row for rows that were just inserted...
[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 28, 2012 at 5:39 am
weisen678 (5/28/2012)
sorry, end of 150 red leggy.
Sorry, just add an "END" statement on to the end. That should get rid of the dreaded "red leggy".
[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 28, 2012 at 5:37 am
Jakub.Janda (5/28/2012)
[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 28, 2012 at 5:31 am
Rock from VbCity (5/27/2012)
I tried my code with Barry's function getting a result 1 versus 6 seconds in favour of Barry's 🙂 I am in the process of fine-tuning...
[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 28, 2012 at 5:21 am
Viewing 15 posts - 256 through 270 (of 7,631 total)