I wanted to look for all non-standard (i.e. A-Z/a-z/0-9) characters in a field across all records in a table. Therefore, I have adjusted my previous script to do so: Simply change to the required database, and change the select statement in the cursor. Please always test on a development server/database before running on Production.
This category contains general information relating to SQL Server
I was having problems with SSMS (SQL Server Management Studio) which I have been running with administrator permissions, whereby I couldn’t open files on my mapped network drives.
Doing a bit of Google’ing, I came across this article – https://technet.microsoft.com/en-us/library/ee844140(v=WS.10).aspx
Back in June 2014, I discovered a SQL Server Agent job that was failing with the error “Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. The step failed”. It turns out that the person who set up the job did not have sysadmin rights. I changed the owner of the job to a sysadmin user, and now it works 🙂
Would you like to increase the “TOP” limit when selecting or editing rows?? Then this post will help 🙂
When I searching the internet (in March 2013) I came across a useful list of shortcut keys for use within SQL Server when coding.
I wanted to produce a list of the MAX of date fields (DateTime, SmallDateTime, TimeStamp) for all tables within all databases held in an instance of SQL Server.
The script below was written for SQL Server 2000, but should be easily customisable for SQL Server 2005
Earlier today, I discovered that the database maintenance plan on one of our SQL Server machine wasn’t working. When I reviewed the logs, it simply said “sqlmaint.exe failed”.
FREE Level 400 SQL Server Performance Monitoring and Tuning Webcasts at http://www.sqlworkshops.com/webcast This is a great resource for performance monitoring and tuning 🙂
Hi. I have just downloaded Red Gate’s FREE SQL Search tool from http://www.red-gate.com/products/SQL_Search/index.htm Features: Find fragments of SQL text within stored procedures, functions, views and more Quickly navigate to objects wherever they happen to be on your servers Find all references to an object Integrates with SSMS Why use SQL Search? Impact Analysis You want […]
I have just found a very good website that lists the various version numbers for SQL Server. You can see from the list which services packs and updates have been applied. http://www.sqlteam.com/article/sql-server-versions
The Save (Not Permitted) dialog box warns you that saving changes is not permitted because the changes you have made require the listed tables to be dropped and re-created. The following actions might require a table to be re-created: Adding a new column to the middle of the table Dropping a column Changing column nullability […]
When creating non-clustered indexes, you should never include the clustered index key fields (commonly used for the primary key) as part of the non-clustered index. This is because the fields will always be used within queries. There is no need to specify them again. The only exception to this, would be if the clustered index […]