Atlanta Custom Software Development 

 
   Search        Code/Page
 

User Login
Email

Password

 

Forgot the Password?
Services
» Web Development
» Maintenance
» Data Integration/BI
» Information Management
Programming
VB VB (1648)
VB.net VB.net (736)
C# C# (15)
ASP.net ASP.net (779)
ASP ASP (41)
VC++ VC++ (25)
PHP PHP (0)
JAVA JAVA (4)
JScript JScript (5)
  Database
» SQL Server (708)
» ORACLE (5)
» MySQL (0)
» DB2 (0)
Automation
» C/C++/ASM (11)
» Microcontroller (1)
» Circuit Design (0)
OS/Networking
» Networking (5)
» Unix/Linux (1)
» WinNT/2k/2003 (8)
Graphics
» Flash (0)
» Maya (0)
» 3D max (0)
» Photoshop (0)
Links
» ASP.net (2)
» PC Interfacing (1)
» Networking (4)
» SQL Server (4)
» VB (23)
» VB.net (4)
» VC (3)
» HTML/CSS/JavaScript (10)
Tools
» Regular Expr Tester
» Free Tools

(Page 1 of 3) 69 Result(s) found 

 

How to restore a SQL Server database marked as "suspect"
Total Hit (9379) At times a database appears to be marked as "suspect" in the Enterprise Manager. SQL Server marks a database as suspect with it can't access the database. What happens at a low level is that SQL Server sets one of the bits in the status field in the sysdatabases table. In general, this problem ha ....Read More
Rating
Make several SQL Server connections partecipate to the same transaction
Total Hit (2766) You can reuse resources from other connections by resorting to two little known SQL Server's stored procedures, which allow several connections to share the same transactional space: sp_bindsession and sp_getbindtoken. In particular the sp_getbindtoken stored procedure lets you retrieve the current ....Read More
Rating
mark the stored procedure to automatic execution
Total Hit (2211) You can use the sp_procoption system stored procedure to mark the stored procedure to automatic execution when the SQL Server will start. Note. Only objects in the master database owned by dbo can have the startup setting changed and this option is restricted to objects that have no parameters. ....Read More
Rating
Scripts to automatically get notified if a database grew due to the autogrowth option being turned on.
Total Hit (2298)
Rating
How to create new tempDB is tempDB is currepted or marked as suspect
Total Hit (2412) The following steps explain how you can create a new tempdb database. With this workaround, you are able to successfully start the SQL Server service. If they exist, rename the current Tempdb.mdf and Templog.ldf files. If the files do not exist, that is one possible reason for the suspect status, ....Read More
Rating
Viewing information about blocked processes is slightly uncomfortable process in SQL Server. Here are three SPs that make it a little easier.
Total Hit (2199)
Rating
How to forcefully disconnect users from a DB? This script also contains some timing features so that it doesn't run forever.
Total Hit (2314)
Rating
How to get NT Accounts from DOMAIN.
Total Hit (2971) Get NT account names of the server or domain using NT commands from T-SQL.
Rating
Get SQL Server Details ( Edition , License ... etc ).
Total Hit (2312) How to obtain details about the server using the new SERVERPROPERTY system function? «code LangId=6»SELECT CAST( SERVERPROPERTY( 'MachineName' ) AS varchar( 30 ) ) AS MachineName , CAST( SERVERPROPERTY( 'InstanceName' ) AS varchar( 30 ) ) AS Instance , CAST( SERVERPROPERTY( 'P ....Read More
Rating
Examples that show how to use the COLLATION features in SQL Server 2000.
Total Hit (10096)
Rating
How to get the data, tools & SQL path when there are several instances on the same server?
Total Hit (2683) The system SP used in this script is undocumented & needs to be used with care.
Rating
Handling database file growth
Total Hit (2163) Scripts to automatically get notified if a database grew due to the autogrowth option being turned on.
Rating
I can change the login audit levels in Enterprise Manager. But how can I do the same programmatically?
Total Hit (2262) To change the Audit levels, Enterprise Manager is calling an undocumented extended registry stored procedure that alters the registry entries. You can see that using Profiler. On a default instance of SQL Server 2000, the following commands can be used to control the audit levels. To audit bot ....Read More
Rating
How to check file size of all databases on the server.
Total Hit (2085)
Rating
Read current sql server error log.
Total Hit (2644) This procedure reads the current SQL Error Log. Optionally it can read any log (or text file) specified by @LogFilename
Rating
Monitoring Hard Drive Space
Total Hit (2295) This script monitors available disk space for the specified drive. If a drive name is not specified in @drivename parameter the usp_dba_diskspace_monitor stored procedure will check all drives against a space limit (MB) passed through @spacelimit parameter. If available disk space is less then @spac ....Read More
Rating
Network Attached Storage: An Overview
Total Hit (2012)
Rating
HOW TO: Identify Your SQL Server Service Pack Version and Edition
Total Hit (3083)
Rating
How can I use Transact-SQL to programmatically determine the number of processors that my SQL Server computer has?
Total Hit (2438)
Rating
How to find version and Service Pack applied on the SQL Server 2000/7.0/6.5
Total Hit (2058) Sometimes you need to find out which service pack version you are running on SQL Server. First, run this command in ISQL/W or Query Analyzer: SELECT @@Version Once you have the version number, then match it to the list below to find which SQL Server service pack you are using. 2000.8.00.76 ....Read More
Rating
Stored procedure which displays current or archived SQL Server Log
Total Hit (2412)
Rating
Selective Defrag/Reindex and Log
Total Hit (2536) SQL 2000 Only This script will create a stored procedure and a table in the master database. Simply run the stored procedure and supply a database name as a parameter. It will do the following: 1. Gather/Log DBCC SHOWCONTIG statistics (pre defrag) 2. Defragment all user indexes in the dat ....Read More
Rating
Monitoring Disk Space and Sending Alerts with TSQL
Total Hit (4018) Monitoring disk space is one important task for SQL Server DBAs. To proactively monitor disk space, we want to be notified when disk space is below certain level. We also want to collect database file size information over time for trend analysis, for which Gregory Larsen has an excellent article "A ....Read More
Rating
Avoid Auto Close and Auto Shrink.
Total Hit (2373) I was on-site with a client, whose had a server which performing very sluggishly. It was a beefy brute with heaps of memory and processing power, so clearly something was just not what it should have been. For me step 1 in doing any sort of trouble-shooting is to look at the logs. Yup, always a ....Read More
Rating
This is a link to a different site Shrinking Databases and Logs - SQL 7 and Higher
Total Hit (1429) SQL 7 and SQL 2000 allow automatic file growth. Therefore, the files can grow large. It is important to understand how to reduce the database and log files sizes. There are two DBCC commands to help shrink databases and files. Both are needed to reduce and maintain file sizes. ....Read More
Rating
This is a link to a different site Why won't my transaction log shrink?
Total Hit (1551) Even though you have run DBCC SHRINKFILE and similar steps you may find that the log file will not shrink.
Rating
This is a link to a different site Can anyone tell me how to enable¦disable the display of the Master, Model, and Tempdb databases in Enterprise Manager?
Total Hit (840)
Rating
This is a link to a different site How do I set up and configure SQL Mail?
Total Hit (917) SQL Mail provides a way to send EMail from Micosoft SQL Server. The focus of this FAQ is configuration of SQL Mail. There are other ways to send Email from SQL Server. Links to articles about these alternatives to SQLMail are listed at the end of this FAQ. ....Read More
Rating
This is a link to a different site Determining Table sizes, Index size, Total Rows
Total Hit (816) Ever wanted to find out the amount of space a table is taking up (in Kilobytes, not record size... although you will be able to get the record size too this way).
Rating
This is a link to a different site How to setup cluster with SQL Server
Total Hit (920)
Rating


(Page 1 of 3) 69 Result(s) found  1 2 3

Recommanded Links

 

Home   |  Comment   |  Contact Us   |  Privacy Policy   |  Terms & Conditions   |  BlogsZappySys

© 2008 BinaryWorld LLC. All rights reserved.