SQL Server – Get SQL Server Service Account using T-SQL
SQL Server service account information is stored in Windows Registry database. You can get this information from Services Console or...
2013-08-20
2,477 reads
SQL Server service account information is stored in Windows Registry database. You can get this information from Services Console or...
2013-08-20
2,477 reads
There are several options available to import data from external sources to SQL Server. Such as Import & Export Wizard, BULK...
2013-07-29
1,040 reads
This is a follow-up post on SQL Server – Check SQL Agent Job History using T-SQL.
SQL Server Agent stores SQL jobs...
2013-07-22
703 reads
To SELECT only top N rows from a table we can use TOP clause in SELECT statement. Using TOP clause...
2013-07-15
840 reads
By default SQL Server ERRORLOG is stored in "C:\Program Files\Microsoft SQL Server\InstanceFolder\MSSQL\Log" folder. The ERRORLOG location is configured as a...
2013-07-12 (first published: 2013-07-08)
5,698 reads
If you have lost the password for sa account or does not have any administrative account and you are locked...
2013-07-03 (first published: 2013-07-01)
4,152 reads
When an account is disable it cannot be used to login to SQL Server. You will receive below error when...
2013-06-24
969 reads
Often we may need to update a column in a table based of another column in another table.
In SQL Server...
2013-06-18
1,133 reads
To get database size information we can use sys.master_files catalog view. This view contains a row per file of a...
2013-06-10
1,248 reads
To move a database from one location to other you fist need to detach the database from server. In this...
2013-06-03
1,135 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers