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
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
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
-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
@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
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
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
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
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
6
votes
1answer
I want to start my SQL Server Express instance in single user mode to do some troubleshooting such as restoring the Master database. I am unable to find the "Startup Parameter" options in SQL Server …
asked Jan 5 '16 by Md Haidar Ali Khan
4
votes
1answer
Today by mistake deleted The AlwaysOn Availability Database from live server. Let I am explaining the Details. In AlwaysON Availability Groups, there is 2 Availability Replica. That is Primary …
asked Jun 7 '16 by Md Haidar Ali Khan
1
vote
2answers
I would like to say that as per company policy we are downgrading SQL Server 2012 Enterprise to SQL Server 2012 Express. Any suggestion would be appreciated.
asked Dec 22 '15 by Md Haidar Ali Khan
3
votes
@zadam,I would like to say some bit about media set. I also expect some more details from our expert like Mr. Aaron Bertrand & some other StackExchange DBA Experts. First of all , what is media set. …
answered Mar 17 '16 by Md Haidar Ali Khan
1
vote
2answers
When i am taking the backup in network share drive with mention below TSQL. Use DatabaseName Go Backup Database DatabaseName To Disk=N'H:\DatabaseBackup\DatabaseName.bak'; Go I am getting the follo …
asked Apr 21 '16 by Md Haidar Ali Khan
2
votes
1answer
I have noticed that after migration of SQL Server 2012 Enterprise to SQL Server 2012 Express, every day it shows "spurious" virtual backup after taking manual backup of database. When I execute this …
asked Jan 17 '16 by Md Haidar Ali Khan
-1
votes
Is it mandatory to have SQL Server agent account defined in SQL server logins to run the job? The service startup account defines the Microsoft Windows account in which SQL Server Agent runs an …
answered May 17 '17 by Md Haidar Ali Khan
-1
votes
2answers
I would like to say that after migration of MS SQL server 2012 Enterprise to MS SQL Server 2012 Express. I have seen there is some subtle diffence in DB backupsize as well as in "LSN" of all databases …
asked Jan 3 '16 by Md Haidar Ali Khan
0
votes
0answers
From today onward i am getting the below error in SQL Server 2012 Error: 9602, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. …
asked Mar 21 '17 by Md Haidar Ali Khan
1
vote
1answer
I would like to say that as i want to configure multiple database mail in single account name in sql server 2012. This is SQL-Cluster-DB , so as per direction from head, If any sql job will fail , th …
asked Dec 2 '15 by Md Haidar Ali Khan
0
votes
1answer
I would like to say that as one of POS database when i am try to Restore verifyonly from disk=N'C:\POS Backup File\SLQ.bak'; from TSQL. I am getting the below message like this. Attempting to rest …
asked Nov 6 '16 by Md Haidar Ali Khan
0
votes
1answer
I would like to say that today incident whatever i have faced related to Microosft SQL Server 2012. I had logged in Microsoft SQL Server 2012 at starting working hour of office time ,but at the mid of …
asked Oct 15 '15 by Md Haidar Ali Khan
0
votes
As per MSSQLTIPS documentation Transferring data from SAS to SQL Server and back SQL Server data typing is much richer than SAS, translating SQL Server values for use with SAS can be challenging. Even …
answered Nov 5 '18 by Md Haidar Ali Khan
1
vote
I have gone through MSDN BOL blog How to backup SQL Server databases to a mapped drive and run the below query. Run the following command from a query window EXEC xp_cmdshell ‘net use <drivename> <s …
answered Apr 21 '16 by Md Haidar Ali Khan
9
votes
1answer
I would like to say that as on daily basis i got the message in my log file. First The I/O is frozen on Database (DatabaseName) message appears in log. The message is like I/O is frozen on Datab …
asked Jul 30 '15 by Md Haidar Ali Khan

15 30 50 per page