Forum Replies Created
Viewing 15 posts - 5,431 through 5,445 (of 13,460 total)
-
RE: Database mail configuration
My new problem now is that I am not getting any e-mails out through database mail to external e-mail addresses.
That issue is caused by the Mail server not allowing...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Having issues using BCP command to create file
and here's a code example of 7zip and xp_cmdShell:
--http://www.7-zip.org/download.html
--http://downloads.sourceforge.net/sevenzip/7za920.zip
--xp_cmdshell is limited to ONE set of double quotes.
--one of the paths needs to not contain spaces!
--see 2003 MS KB http://support.microsoft.com/kb/266224
DECLARE @results...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: How to copy tables from one server to another server?
don't try to move the entire table in one pass;
change it to do a few rows at a time instead, and confirm it's working that way.
tweak the number of rows...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: How we can re-fresh a view
...some sql statement working slow...
that's going to require an analysis of the specific queries themselves. If you post the actual execution plan of a query that is slow, we...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: How to convert a string into datetime, if fails return null
Nice Article Gianluca!
I added your CLR to my collection; very much appreciated.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: How we can re-fresh a view
it the other server a different SQL server version? When moving a database to another version, changes int he SQL engine make rebuilding the statistics manditory,as they are used differently,a...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Is this a network speed Issue?
doing a SELECT from a large table's going to take time, so yeah, that's a factor. the size of the data, whether there are varchar(max) or image type columns affects...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Issue while reading .DAT file in SSIS 2005
quoted and coded to make it more obvious.
so what is the issue? the whitespace is changing from the source? is this a fixed width file, or could you consider it...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Need help with finding a string in a database
Sean's refering to my procedure sp_UglySearch;
mine is a parameterized version as a procedure.
for me, i wanted a proc that returned some drill down queries so i could get/find the...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Generate DDL of all objects to filr
Also look at this other forum post by genehunter on scripting everything out via powershell:
this was one of my first powershells cripts when i was playing wiht powershell; with some...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: long running sp
In addition to Jared's sharp analysis, you are updating every row, even if the values are the same.
if there was an index on lnhist_acct_nbr,lnhist_appl_code,Other_Flag_50 my sample code below might...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: get the actual password from aspnet_memberships
to continue on what Steve is saying, a hashed password is never unencrypted to it's original value.
what happens is a potential password is hashed,and the two hashes can then be...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Script Tables does not include IF EXISTS, Indexes, Contraints, etc
scripting options is what you skimmed over; there are lots of stuff you can turn on and off:
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Database mail configuration
I read your question completely wrong. Manie; Anthony read it correctly.
offhand, getting it in might be difficult; it's just like sending a mail from home versus sending it at work;...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Making password case insensitive
don't believe so; the hash(encrypted binary actually, i think?) of the password is compared to the hash that is stored in credential for the login associated in the sys.server_principals view,...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 15 posts - 5,431 through 5,445 (of 13,460 total)