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,485 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,485 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,054 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
710 reads
To SELECT only top N rows from a table we can use TOP clause in SELECT statement. Using TOP clause...
2013-07-15
846 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,706 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,157 reads
When an account is disable it cannot be used to login to SQL Server. You will receive below error when...
2013-06-24
975 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,139 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,255 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,138 reads
By Kevin3NF
The Two-Layer Model Explained “We added them to the database, but they still can’t...
By Steve Jones
Someone sent me this code. WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER...
Wondering which database to tackle first? I’ve got the lowdown on the top free...
Hi we often use non expiring windows and sql accounts to actually run (credential...
Comments posted to this topic are about the item Changing the Paradigm of Work
Comments posted to this topic are about the item Removing a File
I attempted to use ALTER DATABASE to remove a file from my filegroup in SQL Server 2022. There are 4 files in this filegroup, but I don't need them all. However, I received a message that the file was not empty. How do I empty this file so it can be removed?
See possible answers