N.B.

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 18 total)

RE: Triggering SSIS from ASP.NET Webform

DoolinDalton - Friday, January 4, 2019 7:35 AM
Phil Parkin - Friday, January 4, 2019 5:34 AM

February 8, 2019 at 1:59 pm

#2021555
RE: Phone Number Validation

Sergiy - Wednesday, July 4, 2018 2:41 PM
A meaningful validation must implement all constraints like these:https://en.m.wikipedia.org/wiki/Telephone_numbers_in_AustraliaThat's for Australia.Nothing to do with...

July 4, 2018 at 2:49 pm

#1996336
RE: Phone Number Validation

Jeff Moden - Wednesday, July 4, 2018 7:10 AM
Jeff Moden - Tuesday, July 3, 2018 11:49 AM

July 4, 2018 at 2:46 pm

#1996335
RE: Phone Number Validation

Ok, so this blew up... In any event, the overall answer is that there really isn't a way to write rules that would help scrub out invalid phone numbers.

July 2, 2018 at 1:48 pm

#1996064
RE: Complicated INT Conversion to DECIMAL - No, Really

HanShi (12/16/2016)
N.B. (12/16/2016)
First I want to apologize - this entire situation is the vendor's fault, and not something we can change.
I have a table where, depending on the value in...

December 16, 2016 at 3:07 pm

#1918510
RE: Complicated INT Conversion to DECIMAL - No, Really

I swear I tried this at one point, and was getting a stored value of 90 returned as 90.00 - but I just tried it again, and the results are...

December 16, 2016 at 3:05 pm

#1918506
RE: Partition Help

Jeff Moden (7/30/2016)
Don't partition, then. It's doing nothing for you. It's not going to help performance and it's not going to help with your night maintenance. All...

July 30, 2016 at 11:50 am

#1892760
RE: SSIS 2012: Concurrent Package Execution w Different Parameters?

Alvin Ramard (1/12/2016)
I believe you should be able to run multiple instances of the same package concurrently, as long as they don't interfere with each other trying to use/connect to...

January 12, 2016 at 1:28 pm

#1851413
RE: Granting Select On The Sys Schema

Patti Johnson (1/7/2016)
did you ever resolve this? I need to know the answer myself.
Thank you.
Hi Patti - no I didn't. I finally gave up and just reversed...

January 7, 2016 at 10:09 am

#1850262
RE: NetBackup & MSDB's Backupset Table

WilburBud (11/24/2015)
I suspect NetBackup actually is storing its backup history in msdb
In our environment we use SQL Server Agent jobs to perform the SQL Server native backups to disk and...

November 24, 2015 at 9:59 am

#1842119
RE: sp_executesql with Parameters and CREATE INDEX

Luis Cazares (10/12/2015)
I assume that you were asked to change the old sql to prevent sql injection.
Yes and no - the stored procedure gets the values from all variables from...

October 12, 2015 at 9:50 am

#1832833
RE: sp_executesql with Parameters and CREATE INDEX

GilaMonster (10/12/2015)
Most DDL can't be parameterised. The way to do this is your original statement.
That figures. And if I had thought to Google for "DDL" and "parameterised" I probably...

October 12, 2015 at 9:46 am

#1832832
RE: Jasper Smith's SSRS Scripter

avalpandya (7/15/2015)
RS Scripter doesn't work on 2012.
However, here is another method via microsoft
What do you mean? I just migrated over 500 SSRS reports from 2008 R2 to 2012 SP2...

July 16, 2015 at 8:29 pm

#1813158
RE: Source Control for Mixed RDMS/Dev Environment

Side note: Yes, I realized I screwed up the subject - but it won't let me edit it, so I'm a bit SOL...

July 29, 2013 at 12:21 pm

#1636733
RE: SQL Server 2008 R2 to SQL Server 2008 R2 Linked Server Issues

HanShi (7/17/2013)
It sounds to me you have a "double-hop" issue at hand. Most of the time it's related to KERBEROS authentication and Active Directory. Your credentials are passed on from...

July 19, 2013 at 4:32 pm

#1634219

Viewing 15 posts - 1 through 15 (of 18 total)