| 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 |