Forum Replies Created
Viewing 15 posts - 9,166 through 9,180 (of 13,460 total)
-
RE: sp_msforeachdb not working as expected
suresh kumar Sulakh (6/28/2010)
Thanks for the reply..it makes me wonder why at times we dont have to supply a placeholder and it still worksthat's because the command is repeating over...
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: SMTP and Email Subscriptions
i think it needs to be smtp.googlemail.com, and port 465:
you need an account to send with(outgoing smtp);
the imap is to pickup/receive email.
i set up an account to confirm, registered "sqlnotifications@gmail.com":
this...
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: SMTP and Email Subscriptions
it's very easy to set u, and you don't need your own SMTP server...just a valid email box somewhere that has SMTP/POP3 access...you can set up with a gmail account...
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: ASK SQLServerCentral
what site are you guys going to?
http://ask.sqlservercentral.com/ seems to be jsut fine, but i did not find a site named http://www.asksqlservercentral.com
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: Determining what was created
the default trace captures all the DDL commands, including who dunnit info, but it rolls over if you have a lot of cahnges.
if not too much time has past, you...
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: replace ment for query analyzer
LinqPad is free and a very light footprint with no dependencies other than requiring .net, but has all the things you need; an object explorer, and multiple query windows for...
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: drop production database
this kind of request ranks up there with a request that was once heard at Enron:
Run everything in these filing cabinets through the shredder...boss said it was ok, and those...
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: SQL SERVER 2005 Users cloning
blocking is not affected by users...it's affected by two connections selecting and updating the same row of at nearly the same time.
...whether it is two connections with the same...
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: drop production database
i'd think it through first...what happens if the database goes missing? does the company shut down? is the database being used? maybe they mean they want you to move 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: Error on BCP export into .CSV file via xp_cmdShell
the switches we are talking about are for the program bcp.exe, not xp_cmdShell...easy to confuse
i would reckon books online has a complete description of each delimiter, but the command line...
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: Error on BCP export into .CSV file via xp_cmdShell
when i did bcp /? from a command window, i saw one if the switches is a lower case t:
[-t field terminator]
changing my command to this gave me comma delimited...
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: Error on BCP export into .CSV file via xp_cmdShell
keyun this example works for me... outputs 3 rows to my file:
no quotes or spaces for the username or password bvariables being passed...your way may work, but it's not how...
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: Problem with forumulating case statement
wierd i got the same error, not sure if it is because of the reserved word SITE or not;
this passes the syntax check:
select cust_num,slsman,
SUM(CASE WHEN [site] = '11199' THEN...
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: Interesting INSERT-EXEC issue
edited because now i'm not so sure......
Trusted_Connection=yes = I thought was not possible...unless you change the login used for the SQL Service account.
I know SQL does not use YOUR credentials...
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: Interesting INSERT-EXEC issue
instances use the other slash...dunno if it is a typo:
my server is LOWELL\SQLEXPRESS, or LOWELL\SQL2008 for my other instance....could that be the issue?
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 - 9,166 through 9,180 (of 13,460 total)