Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 38968

SQL Server 2012 (major build version 11.00.xxxx). Please also tag sql-server.

0
votes
You can create SQL login through TSQL statement and also set your default database as well as default language. CREATE LOGIN Dilshad WITH PASSWORD=N'pass@word1' MUST_CHANGE, CHECK_EXPIRATION=ON, …
answered Jan 16 '17 by Md Haidar Ali Khan
0
votes
There is so many ways you can do it. But as simple way you can do it Using INFORMATION_SCHEMA.TABLES view. We can write a query like below to check if a Customers Table exists in the current database …
answered Jan 10 '17 by Md Haidar Ali Khan
2
votes
No need to buy individual licence for each machine. you just install your licence SQL server 2012 in server PC and install SQL server management studio to all your client PC and through (IP,Port ) abl …
answered Sep 15 '15 by Md Haidar Ali Khan
-1
votes
1answer
During import of excel data into SQL Server 2012 Express for User only i am getting the error. The Error is as mention below Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'User …
asked Nov 16 '16 by Md Haidar Ali Khan
1
vote
First of all you know the SQL Server Express database limitation.As you said tempdb which has 50 GB. As per MSDN BOL Here SQL Sever Express supports Maximum database size is 10 GB. And also you can f …
answered Jan 1 '18 by Md Haidar Ali Khan
0
votes
As per MSDN BOL http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx The message is kept fairly nondescript to prevent information disclosure to unauthenticated clients. In particula …
answered Nov 18 '15 by Md Haidar Ali Khan
1
vote
I have to create a new database for a company wide printing application.Since there is not much overhead, we are planning to use an existing SQL Setup for the same. Can someone suggest when can …
answered Sep 19 '16 by Md Haidar Ali Khan
0
votes
0answers
I would like to say that as one of my production database (.ldf) log file is growing larger than databse size. The size of database file (.mdf) and their log file (.ldf) is as follows:- 1)database …
asked Dec 6 '15 by Md Haidar Ali Khan
1
vote
2answers
As I would like to say that we are going to downgrade the SQL Server Standard 2012 SP1 edition with SQL Server Express 2012 SP4 in one Production Server. For the time being I want to keep the SQL Ser …
asked Oct 15 '18 by Md Haidar Ali Khan
1
vote
@Nissanna, As you said, you are getting the error during cmd installation of sql server express 2012. The syntax of argument "/HIDECONSOLE" is incorrect;Either the delimiter '=' is missing or th …
answered Jan 25 '16 by Md Haidar Ali Khan
0
votes
2answers
As I would like to say that by mistake the SQL Server 2012 backup file (.bak) open with wordpad. Due to this reason all backup files of SQL Server (.bak) file change with wordpad icon in entire the Wi …
asked Oct 14 '18 by Md Haidar Ali Khan
5
votes
1answer
I would like to say that i have gone through some of the sql blog and MSDN BOL, but still there is some confusion in mind like. The limitation of SQL Server 2012 Express is 10 GB. It is the limitati …
asked Dec 23 '15 by Md Haidar Ali Khan
0
votes
@zapcon, there is DMV master.sys.dm_exec_requests; USE Master GO SELECT * FROM sys.dm_exec_requests WHERE blocking_session_id <> 0; GO The master.sys.dm_exec_requests; DMV provides details on all …
answered Jun 19 '17 by Md Haidar Ali Khan
1
vote
0answers
I would like to say as per my network system administrative security of windows Server 2012 R2. I am unable to start SQL Server agent. As per in MS SQL Server 2012 , i have "sysadmin" & "public" priv …
asked Mar 24 '15 by Md Haidar Ali Khan
1
vote
0answers
I am trying to insert explicit values in one of my Real time Audit Production database. There are more than 80 columns, I have just taken here 5 columns. I am writing syntax is as below: use MyDataba …
asked Aug 11 '15 by Md Haidar Ali Khan

15 30 50 per page