Viewing 15 posts - 5,926 through 5,940 (of 9,715 total)
The reason I'm requesting business cases is because the example I have has the potential of violating business NDA. I'm looking for an example I can use publicly, which is...
May 25, 2011 at 7:45 am
Peter Trast (5/24/2011)
Tornados...Kansas City is under a watch. I hate when my SQL skills have no bearing on the current problem...
Apparently a lot of states were under watches and warnings...
May 25, 2011 at 4:25 am
jcrawf02 (5/24/2011)
Brandie Tarvin (5/24/2011)
I'm probably going to get lynched for this one, but ... It is a valid scenario. Honest.Thoughts?
http://www.sqlservercentral.com/Forums/Topic1114315-149-1.aspx
Not entirely sure, but I may have just provided the...
May 25, 2011 at 4:25 am
I'm probably going to get lynched for this one, but ... It is a valid scenario. Honest.
Thoughts?
http://www.sqlservercentral.com/Forums/Topic1114315-149-1.aspx
May 24, 2011 at 12:31 pm
Encryption is a huge subject. The easiest way is to encrypt the media the data is stored on, as opposed to encrypting the data itself. I'm not even sure you...
May 24, 2011 at 10:56 am
Okay. I recommend you encrypt the data, though, before you transport it. If there's private information on that data, and someone steals it, you have a serious problem on your...
May 24, 2011 at 10:30 am
BCP is definitely the easiest option, given Steve's note on compatability.
But now I'm curious. If the servers are in different cities, and there's no internet / network connectivity, how do...
May 24, 2011 at 10:20 am
How often is this data exchange going to be taking place?
Are both servers SQL Server (or will they both be SQL 2005)?
How far away, physically, from each other are both...
May 24, 2011 at 9:04 am
Oh, Howard, that's good info. Thanks for the link! (not the OP @=)
May 24, 2011 at 9:02 am
Try running the text of the proc separately (creating the input variable as a "inline" variable and doing a SELECT on @retValue before the RETURN clause).
Here's the code from sp_helptext:
--...
May 24, 2011 at 8:59 am
I would agree with Suresh. I have never seen a place where you can track the changes made to a job over time.
However, you could set up logging that tracks...
May 24, 2011 at 8:55 am
DTS doesn't exist in SQL 2005 except as a legacy hook up. I do not recommend using this.
I'm not quite understanding your comment about no internet access. I'm not sure...
May 24, 2011 at 8:51 am
WayneS (5/24/2011)
What's up with all the old threads being resurrected lately? I've seen several this week already... 🙁
Are they "Did you ever find a solution" resurrections, spam resurrections, or "hey,...
May 24, 2011 at 8:48 am
I may be misunderstanding the CONTAINS predicate, but it seems to me that it searches for a whole word, not part of a word.
BOL
A word or...
May 24, 2011 at 8:26 am
Viewing 15 posts - 5,926 through 5,940 (of 9,715 total)