Home
Welcome to SQL-Articles
This website is totally dedicated to SQL SERVER, a specific implementation of a relational database server from MICROSOFT.SQL server has been in the industry for the past three decades and has come a long way from SQL 1.0, SQL 7.0 through to SQL SERVER 2012 aka SQL Server Denali. Number of voluntary and involuntary DBAs , developers working on SQL databases keep ticking every day and the main intent of this website is to help and educate each of those out in the field and new database professionals starting their venture with the SQL server.
SQL-ARTICLES host’s number of good articles related to various SQL server features and helpful T-SQL scripts. Apart from this, the readers and users can ask us anything about SQL server in our FORUMS column. We would like to maintain this website as a SQL server knowledge base and a technical information exchange point. Come in, have a look and drench yourself in the rain of SQL SERVER.
VidhyaSagar
| #
Thanks Ashish, I’ve updated the script.
Ashish
| #
I was just searching some trace related articles and gone through your article. Found one incorrect information,
to disable the trace, the command should be
dbcc traceoff (….)
you might have by mistake mentioned it as traceon for disabling as well.
Ben
| #
I remember having to write a complicated procedure to do the same thing recently. This will be nice to use with a web app to only return a small subset. I think this will improve the speed especially when the entire result set is very large.
namanthakral
| #
got errors after executing this trigger
“SQL SERVER – Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to ‘master’.”
and was really stucked in this mess but DAC saved my life
C:\Users\Administrator>sqlcmd -S LocalHost -d master -A
1> DROP TRIGGER block_ipaddress ON ALL SERVER
2> go
SQL NET » New Feature in SQL Server 2012
| #
[...] CLICK HERE TO READ THE ARTICLE [...]