Forum Replies Created
Viewing 15 posts - 1,966 through 1,980 (of 13,460 total)
-
RE: New SQL Server Express Installation
In that case, if both iis and sql are blocked, its probably te wi dows firewall. Add two differen exceptio s, one for port 1433 and another for port 80...
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: New SQL Server Express Installation
SQL express, by default, does not allow remote connections, you very likely need to change that, and also go to SQL configuration and enable TCP-IP
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: DB Project Publish Empty string inserting a Zero
empty string converts to an int without an error, and it's value is zero. it has to do with the precidence of implicit conversions
you could use the NULLIF function to...
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: function that does spefic conversion
ok technically it's possible, but not practical to consume later.
you can use a sql_variant, which allows individual values to hold their datatype...one field can be an int, and another...
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: Extracting Data From a MySQL Linked Server
in my snippets, where i have some mySQL linked server example,s the database and schema are left blank for a typical user.
Once you have the Linked Server in place I...
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: deploy SP to multiple database
i would custom cursor for specific databases, sicne you wouldn't deploy to model/master/ReportServer etc.
it's actually a specific list, or some sort of pattern right?(all databases with 'APP_' or something like...
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: SSRS unable to backup encryption key
Jason running this specific example on my local machine, as well as on another server, this worked correctly for me:
it has to run locally, since it's effectively calling a command...
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: Download Email Attachment through SSIS
rocky_498 (2/19/2015)
I just want to download only where email is abc@hello.com (as an example) and download the attachment on network drive folder.Is there any third party software doing this ?
from...
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: Extended Events Capture a Specific Proc Parameter
wow neat question.
i head to search this, and this link seems to say if you create an extended event session watching rpc_completed, it';s all available:
http://dba.stackexchange.com/questions/50122/collecting-parameter-values-from-extended-event-session
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: HELP Creating LOGIN
dynamic sql and and a serverprooperty might help, but how do you KNOW the user test already exists ont he local machine? why cna't you just add a domain\test instead...
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: SSRS unable to backup encryption key
jason i only did this once, and it was a two or more years ago, for a 2005 instance.
there's away to backup the key via powershell, and avoid the gui...
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: Download Email Attachment through SSIS
if your email server supports a standard POP3/SMTP interface, it's possible, but complicated code, since it would involve c#/vb.net code in a script task, and of course requires a lot...
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 table encryption
well that's a design issue you have to think about.
in my case, our app user doesn't have access to the certificate.
the sql user we created has db_datareader, db_datawriter, and...
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: EXECUTE SP Permissions for child database
i believe the best solution is to sign the procedure via ADD SIGNATURE . then the certificate permissions are used, instead of the caller, and would perform as expected.
a crappy...
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 2012 - SSMS not connect after change port 1433
SQL Galaxy (2/19/2015)
Thanks Lowell, It is working now..management also not recommend to start the browser service. so in this case need to mention new port number in ODBC connection or...
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 - 1,966 through 1,980 (of 13,460 total)