719 reputation
313
bio website
location New York, NY
age 36
visits member for 2 years, 2 months
seen 1 min ago
stats profile views 43

Sep
25
comment Getting conversion error, for value that doesnt exist in database
could employeename a b be a value in the ea.present column or the em.rscode?
Sep
24
answered SQL Log Shipping Firewall settings
Sep
24
asked SQL Log Shipping Firewall settings
Sep
21
awarded  Custodian
Sep
21
awarded  Popular Question
Sep
20
accepted SSMS login to different domain
Sep
20
comment SSMS login to different domain
hmmm Yeah its defaulting to SQLServer Authentication. I know it can be next to impossible to troubleshoot by internet text. Thank you very much for taking the time Aaron.
Sep
20
comment SSMS login to different domain
When SSMS opens. The servername text box for me contains the IP address for the server. When SSMS opens for him the servername text box contains the name of a local server on our internal network. Is that clearer? Sorry if I'm still being confusing.
Sep
20
comment SSMS login to different domain
Yeah he can ping and he's using the same database name that is working for me. although his does not default too it when the SSMS login comes up. So he inputs that address and switches to windows login. Would this cause SSMS to overwrite the credentials being used in the background?
Sep
20
comment SSMS login to different domain
Ok I got it to work for me by copy and pasting in the password. not sure why but I'm certain I didnt typo all those times. My developer is still having the issue though. When ssms comes up its not defaulting to the db server were looking to connect too.
Sep
20
asked SSMS login to different domain
Sep
18
comment Creating a User to access multiple databases
I see. So could you grant impersonate to the user at the end of the queue then? Or does it not allow that?
Sep
18
answered Creating a User to access multiple databases
Sep
17
accepted Log shipping setup across domains
Sep
17
asked Log shipping setup across domains
Sep
10
comment T-SQL Syntax error copying views dynamically
I test ran it. It's working the way that I want. Thanks for the explenation on the Exec vs sp_executesql part. I upped the comment.
Sep
10
answered T-SQL Syntax error copying views dynamically
Sep
10
comment T-SQL Syntax error copying views dynamically
This solution is returning the error 'CREATE VIEW' must be the first statement in a query batch.
Sep
10
reviewed Approve suggested edit on T-SQL Syntax error copying views dynamically
Sep
10
asked T-SQL Syntax error copying views dynamically