DatabaseJournal.com Staff

This script is designed for SQL Server 7.0 Because of the limited access to xp_cmdshell (only members of the sysadmin role have access to xp_cmdshell using the SQL Server service account, all non-sysadmins use the local account SQLAgentCmdExec which has no access to domain resources), the average end user cannot export data to a UNC […]

These procedures import/export data to/from a single table using the OLE Automation functionality of SQL Server 6.5. The purpose is to give users the ability to work with data without giving them access to xp_cmdshell. The create and run this stored procedure you will need to create the stored procedures listed in the BOL under […]

This script allows you to reset a suspect database so it is usable. For SQL Server 6.5 Author: Vincent McGuire Download Script: sp_resetstatusflag.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. All information on […]

by Aaron Bertrand Browsing a remote SQL database People often ask how to browse or edit a SQL database without actually sitting at the SQL machine. Well, you could use Enterprise Manager installed on a local NT Server / SQL Server. Or you could use remote control software like Carbon Copy or Remotely Possible. However, […]

This script generates a database creation script for a 7.0 database – including files, filegroups, default filegroup and database options. Author: Sharon Dooley Download Script: sp_scriptsql7db.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. […]

Space calculation for SQL Server 7.0 tables. Author: Sharon Dooley Download Script: sp_calcspace7.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. All information on these pages is provided “as -is”, without any warranty, whether […]

This SQL Server 7.0 script will scan through your databases and tables running all the standard maintenance. It places your databases in single user mode (optional) then runs allocation, database and catalog checks. It’s the perfect script if you have developers that are adding tables to your system without telling you. Best to run this […]

This set of scripts can be used to publish any database in publications of 1 to x number of articles. The script will create the script you need to publish your tables. Be sure to initialize the needed variables and execute it in the database you wish to publish. The two included stored procedures must […]

I run a DBCC job that uses a cursor and does all DBCC checks on all databases in a server and writes the output to a txt file. Then I run on a daily basis a simple batch job, after the DBCC is run to check the DBCC output and e-mail me if any error […]

This script drops and adds users within a database so that they are correctly pointing to the correct login. Great for doing restores from one server to another. For SQL Server 6.5 Author: Grant_Scott@infinity.com Download Script: sp_fixlogins.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the […]

by Armand Datema Note: I wrote this article with the help of our DBA, she had some information about this. Unfortunately she didnt know where she got the information from (the internet, a book etc., so if someone recognizes this dont go out shooting me, but let me know and I will give the proper […]

This is a procedure for finding strings in sqlserver views and procedures you can perform seaching for differnt strings in the same seach. For SQL Server 6.5 Sample: SP_FIND_ALL “CUSTOMER+(VENDOR & VENDORID)-(CUSTOMERID) will find all customer or Vendor and VendorId but not customerid For SQL Server 6.5 or any version with modifications to the messages […]