Viewing 15 posts - 901 through 915 (of 49,552 total)
SQL_Hacker - Wednesday, August 16, 2017 12:02 PMYou're missing "AS" in the "CREATE PROCEDURE" statement.
It's there, after the parameter list.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2017 at 12:04 pm
If you're connecting to the instance "SERVER\Instance", then the login error will be in that instance's error log or, if you started SQL from the command line, will be on...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2017 at 11:39 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2017 at 8:38 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2017 at 5:52 am
-S <server> -E should work. What's the error from the SQL Server error log?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2017 at 5:50 am
Did you tell it which server/instance to connect to this time?
Just like any connection, you need to specify the server, the authentication (trusted or username and password) and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2017 at 5:31 am
sqlcmd /?
and look at the options it presents you.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2017 at 5:14 am
A restore recreates the DB as it was at the time of backup. You can't split/merge or change files during a restore.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2017 at 4:57 am
-U on sqlcmd is used along with -P for SQL logins, not windows. Use the parameter for trusted connection and make sure that you're logged into Windows as a local...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2017 at 4:56 am
Have a look at the error log, see what the detailed description is for the login failure is.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2017 at 3:50 am
Also make sure that you don't have something like SQL Agent or other services attempting to log in and taking the only login available.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2017 at 3:41 am
Once you connect via SQLCMD, you can do anything. You're a sysadmin. So the same T-SQL you'd use normally to create a login and make it sysadmin.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2017 at 3:40 am
Unless you have some custom auditing, SQL doesn't track when someone last logged on. If you need that, you'll have to set something up. An extended event session will probably...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2017 at 3:36 am
When the instance is in single user mode, the only accounts that can log on are SQL sysadmins or windows users who are members of the local administrators group. If...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2017 at 3:29 am
If you specified accounts at install, they'll be sysadmin. Log in as one of those and add extra accounts or change the sa password.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2017 at 3:06 am
Viewing 15 posts - 901 through 915 (of 49,552 total)