Category Archives: SQL 2005

Import tab delimited data files directly into SQL Server via SSMS

Recently, I wanted to bring data into a SQL Server table, and I wanted to do so w/o SSIS. I know that I had done this before, but, of course, I had forgotten the details. I found the best answer … Continue reading

Posted in SQL 2000, SQL 2005, SQL 2008, SQL 2012, SQL Administration, SSIS | Tagged , , | Leave a comment

SSRS Data Source Lister

Hello, Sometimes, you’re in the middle of doing something, and you need an answer.  You google it and find such a great solution, you want to keep it handy for … whenever!  Here is such a post.  As the title … Continue reading

Posted in SQL 2005, SQL 2008, SSRS | 1 Comment

List out all the database users and the roles they are members of…

Needing to figure out which users in which database are members of roles? You’ve come to the right spot! Try this code…

Posted in SQL 2005, SQL 2008, SQL Administration | Leave a comment

Script version of SSMS “Sql Server Agent” Job Activity Monitor

Are you tired of “right-click” “refresh” on the job monitor?  Want a single, simple script to tell you what step a job is at?  Try this script:

Posted in SQL 2000, SQL 2005, SQL 2008, SQL Administration | Leave a comment

Sql Binaries location, SessionTimeout, Sql Version

OK…this is a ‘strange’ post… That is because the script i have for you today is a real ‘utility’ script… it does three things that occasionally come in REAL handy! It tells you the location of your SQL binaries. It … Continue reading

Posted in SQL 2005, SQL 2008, SQL Administration | Leave a comment

Sql Server Status

What’s the first thing you do when you get a report of a problem on one of your servers? In my case… i run this following script that gives me a quick overview of all the top counters of interest.

Posted in SQL 2005, SQL 2008, SQL Administration | Leave a comment

Backup Script to replace xp_sqlmaint

Need a backup script because xp_sqlMaint is not running on 2008? Try this one. You need only fill in the database name and directory name in the appropriate places below:

Posted in SQL 2005, SQL 2008, SQL Administration | 1 Comment

Out of disk space…Log file grown too big?

It’s early in the morning, and you’ve got disk space problems… log file, right?  Yep.   OK, we need a script that will tell us what we need to know ASAP.  Since i experienced this issue multiple times…and since they always … Continue reading

Posted in SQL 2005, SQL 2008, SQL Administration, Uncategorized | Leave a comment

Find the users and their roles in a Database

Do you need to know all the users for a single database…and also to know what roles they have? (The key is to look for the string “mscs” in the code and replace it with what your databases beginning strings … Continue reading

Posted in SQL 2005, SQL 2008, SQL Administration | Leave a comment

When were your statistics last updated?

Introduced in sql 2005 the following query will tell you the date your statistics were last update for each of indexes of a table…

Posted in Performance Tuning, SQL 2005, SQL 2008 | Leave a comment