SQL Server 2000 || Disable sa login
Question : How to disable sa user in SQL Server 2000?
Reason : Due to Security requirement of audit, We have to disable...
2014-04-15
1,951 reads
Question : How to disable sa user in SQL Server 2000?
Reason : Due to Security requirement of audit, We have to disable...
2014-04-15
1,951 reads
Anti-virus & SQL Server on one system together are friends not enemies, if configured properly.
Anti-virus are very useful programs from security,...
2014-04-08
13,005 reads
Here, You have steps with screenshot to install 2 Nodes windows cluster on Windows Server 2008.
Step 1: Validate Cluster Configuration
a)...
2014-03-17
1,168 reads
2014-03-17
598 reads
Table with clustered index is totally depended on index accessibility.
ERROR : The query processor is unable to produce a plan because...
2014-02-25
5,098 reads
Question : Can we do system configuration check with starting SQL Server installation? One of my friend need to submit it...
2014-02-13
3,349 reads
The 15th cumulative update release for SQL Server 2008 Service Pack 3 is now available for download at the Microsoft...
2014-02-03
740 reads
The 8th cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 8 contains all...
2014-02-03
1,207 reads
The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.
Here’s an excerpt:
The concert hall at the Sydney...
2014-01-30
1,121 reads
Database snapshot is really a useful feature. As we know, Snapshot database file will keep increasing parallel to the DML...
2013-12-11
1,079 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
I'm tracing activity on one database and would like to include the client_app_name in...
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...
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