Monitoring Disk Space and Sending Alerts with TSQL

Haidong Ji from SQLServerCentral.com

Haidong discusses the importance of monitoring disk usage over a period of time and has some great TSQL code to help you do the monitoring! More »

String Functions: The .Properties Function

Additional Articles from Database Journal

Business Intelligence Architect Bill Pearson introduces the basic .Properties function, within the first of a two-part article surrounding this important member of our MDX toolsets.More »

Celko's 'Can't Be Your Own Supervisor' SQL Puzzle

Additional Articles from Intelligent Enterprise

A SQL puzzle from the SQL guru.More »

One Year Ago - SQL Server Spotlight on Steve Schmidt

Steve Jones from SQLServerCentral.com ( published: 09/14/2006)

I caught this quote from Microsoft Watch, and thought it was very interesting. It definitely addresses an issue I've wondered about for some time. It talks about the WGA server issues and had this great quote from the WGA Product Manager:

"It's important to clarify that this event was not an outage. Our system is designed to default to genuine if the service is disrupted or unavailable. In other words, we designed WGA to give the benefit of the doubt to our customers. If our servers are down, your system will pass validation every time. This event was not the same as an outage because in this case the trusted source of validations itself responded incorrectly"

The individual writing the article questioned how this could not be an outage. After all, there was nearly a day where people could not validate their copy of Windows. So I'm asking this question today and with a few thoughts afterwards.

What's an Outage?

To me it's a client side issue. If the client's can't use the service/app/server, then it's down. If my SQL Server is running and I can connect, but no one outside the data center can, it's an outage.

The question does get tricky. If I can get to SQLServerCentral.com, but people in Canada can't, then is it an outage? In some sense it is, and people have a legitimate gripe about the service not working. It might not be the fault of the service vendor, as it could be a network cut, an ISP issue, etc. However for the client it's down.

Measuring uptime is a hard process these days. Most people would still consider their services up when a server fails if there are redundant servers, like a load balanced farm of web servers, that continue to work. For all I know there's always a few servers down at Google.com or Microsoft.com.

So maybe it's a question of measuring your uptime at the edge of your network, outside your firewall. As long as things are working from there, you can claim uptime is still there. Just be sure you have a couple providers in case your one line goes down.

Steve Jones

» Join the debate, and respond to today's editorial on the forums

» To submit a tip, rant or editorial, email articles@sqlservercentral.com.

Today's Question:

What does this return?

select ceiling( 53.5)

Think you know the answer? Click Here, and find out if you are right.

This Question is worth 1 Point(s) in this category : T-SQL. We keep track of your score to give you bragging rights against your peers. If you have problems with submitting you can go to the QOD section inside the Test Center directly at http://www.sqlservercentral.com/testcenter/QOD.asp. We'd love to give you credit for your own question and answer. To submit a QOD, simply send the question, answers and explanation to articles@sqlservercentral.com

Today's Question is sponsored by:
 

The language used to write data mining queries in SQL Server Analysis Services is called what? Sponsored by Apress and Lynn Langit, author of Foundations of SQL Server 2005 Business Intelligence

Answer: DMX

Explanation: The correct answer is DMX, Data Mining Extensions

Ref: Page 274 of Foundations of SQL Server 2005 Business Intelligence
Data Mining Extensions - http://msdn2.microsoft.com/en-us/library/ms132058.aspx

Here's a few of the new posts today on the forums. To see more, select Discussion Forums in the Community menu on the site:

   Moving text/LOB data to different filegroup - I'm working on an general purpose script to move all DB objects from one filegroup to another.  Am almost done, now have a script that will reliably move tables and all indexes from one filegroup to another.&nb....(more online)

   Replication error, please help ! - Hi,Anyone can help with this error ?INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns an....(more online)

   Installation best practices - Hi all,After much research I have not found any information on the following subject...What are the best folders to install SQL Server in?Is it better to you the default C:\Program Files\MS SQL Server ?Would it be better on a....(more online)

   Limit number of active processors - In sql 2000 there was a property to force sql server to use only a single processor on a server with more than 1 cpu.  How is this done in sql 2005?....(more online)

   sql error - Error try to connect sql2000 A user instance was requsted in the connection string but the server specified not sapport this option Changed the database context to 'master',Changed the language settings to Us-Englishhow to s....(more online)

   2005 Problems with Database Users after Restore to Different Server - Ok, using SQL 2000 for moving a server, I use to create the users on the new server and then just create a dummy database in preperation for the move of a database.  I would then just restore over the top of the dummy da....(more online)

   How to Set Recovered DB back to restoring mode - Hi, I am in the middle of restoring a DB.  I restored the full backup and started restoring TRN files.  I made a mistake and selected WITH RECOVERY option when restoring a transaction log, but I still have more tran....(more online)

   SQL 2005 backup maintenance plans failing - I have created maintenance plans that have one subplan to backup the database including steps to remove history and maintenance to remove old backups and another subplan to backup the transaction log also including steps to r....(more online)

   Backup to Multiple Directories? - Has anyone ever had a need to split backups to files in multiple directories? I am building a general purpose stored procedure to do various types of backups, and I was wondering if the need to do this is common enough t....(more online)

   Removing column headers in CSV export file - Hiwhen I export report to CSV file through sql reporting, header row is included, but there is no header row in my report, how to suppress the header row when i export using CSV file format.Please let me know if any body know....(more online)

   page fileds in business intelligence - Hi GuysI am developing some charts using 'Business Intelligence' in Sql server 2005. I need to include an additional 'page' filed in the chart the same way we do it in pivot table graphs in excel where there is a page field r....(more online)

   Importing a web service XML document into SQL stored procedure - Hi I am trying to import XML data from a web service. I need to pass variables to the webpage which produces a new XML document which then needs to be imported. So in  a stored procedure I would cycle through types,....(more online)

   errors with DBCC CHECKCONSTRAINTS WITH ALL_CONSTRAINTS, ALL_ERRORMSGS, NO_INFOMSGS - When I run DBCC CHECKCONSTRAINTS WITH ALL_CONSTRAINTS, ALL_ERRORMSGS, NO_INFOMSGSI get Server: Msg 8170, Level 16, State 2, Line 1 Insufficient result space to convert uniqueidentifier value to char.Server: Msg 8170, Level 16....(more online)

   Error File BugCheck Dump - The SQL server I generate this dump and after this, when I conduct some operations, like cursors, it consumes all the memory to me of the server :===================================================================== &nbs....(more online)

   MSDB in suspect mode. - Hi,I have mssql 2005 installed and i see that MSDB database is marked as suspect. I almost tried all the steps which are submitted in the forums.1) I shut down the server, navigating to the directory 'd:\Program Files\Microso....(more online)

   selecting from a view error - Hi All,I am running a simple select query from a view which has worked for ages and now i get the following message..Msg 0, Level 11, State 0, Line 0A severe error occurred on the current command. The results, if any, should....(more online)

   database corrupted - Hi, I having serious database corruption issue. I tried dbcc checkdb ('dbname', [REPAIR_REBUILD]), but still no repair. I would really appreciate if anybody could help me to recover my data.DBCC CHECKDB gives the following er....(more online)

   using bulk insert - Hi friends,I have a text file having three columns with values. Using Bulk Insert i need to skip the 2nd column values while doing the bulk insert and work with the 1st and 3rd column. This is my project requirement. Pls help....(more online)

   Views and base tables - If you create a view (as an administrator), and only the SELECT permission on that view to some user say BOB, then login as B, how can BOB modify the base tables that the view is based on, I know this can be done I just don't....(more online)

   Environments - I'm interested as to what sort of permission rights you guys assign developers to your development database server.What does everyone do? I thought there might have been a thread on this already but appears not to be.....(more online)

   Possible SQL Server 2005 bug..... - .... has to do with collations. I just found this behavior while looking for a bug in my code.Basically, LIKE operator returns TRUE when 'aaa' compared to '[A-Z]%' in case-sensitive fashion. It should be returning FALSE.....(more online)

   very slow insert statement initially then fast execution subsequentially - i've got a site that's timing out when inserting a record (approximately 5 columns of data). at first, i suspected it might be something to do with the asp code, but have since tried running the statement directly against sql....(more online)

   Job Execution - I have a sql agent job scheduled to run every 15 minutes. (SQL 2005) This particular job does an import routine, but occasionally we have a need to run the job between schedules. I am thinking of adding a button to my ap....(more online)

   SSIS equivalent to Informatica''s Update Strategy - I'm new to SSIS and am trying to figure out how to update a row.  I've read a lot of logic regarding lookup transformations, merge joins, etc.  No problem and it generally makes sense.  However, the b....(more online)

   Connection to Pull Data From AS400 to SQL Server using SSIS - Hi All,I have created a Dataflow in which I use Script Component as a Destination to write data into AS400 reading from my SQL Server Table.The "Connection Manager" Tab in by Script Destination is set up to connect to AS400 U....(more online)

   Sometimes it works, sometimes not... - I have an VB app that loads 9 text files for 8 different products, one product at a time. The user must select the product to import. For each product the application:1. Copies the 9 text files from the source directory to ....(more online)

   Lookup transformation unspecified error in Column tab. HELP!!! - Hi guys,  I am running an "unspecified error" during configuration of the lookup transformation.  In lookup transformation, I specify the reference table with a table in "XYZserver", for example.  Clicking prev....(more online)

   A Conditional Component when true & then execute a Task - Hi,I am looking for A Conditional Component when true & then execute a Task eg. IF = Y then execute task else not I'm not to sure. Something like a A Record in a queryDTS Task DTS ParameterRegards....(more online)

   Cluster SQL 2005 - Hello,Does anyone inplement a SQl cluster server?What is the technology based you will recommend to use? Windows cluster or SQL 2005 failover clustering?  ....(more online)

   10% Fill Factor - Hi,Currently checking the indexing at a new company I've started at, and in one DB half the indexes are set to a fill factor of 10. I understand the advantage of reducing it from a 100 but not sure that 10% is ever useful - ....(more online)

   SQL Server Performance Dashboard on SP 2 - Does anybody knows or found out of any information relating to Performance Dashboard on SP 2 of SQL Server 2005?  besides that of the download site from microsoft.  I don't seem to find much of an info on this tool.....(more online)

   Reduce Aggravating Aggregation - I've just read the article from my latest sqlservercentral newsletter called "Reduce Aggravating Aggregation: Improve the Performance of History or Status Tables" by Merrill Aldrich. I use the kind of historical status tables....(more online)

   Another RAID Questions... - Hi,I know I am going to open another can of worms with this but here it goes...Scenario:3 to 14 Transactional database. Total Data less than 60GB. Heavy transaction load with ordering system style data (no blobs, images, or b....(more online)

   Problems with Database user after Restore to Different Server - Ok, using SQL 2000 for moving a server, I use to create the users on the new server and then just create a dummy database in preperation for the move of a database.  I would then just restore over the top of the dummy da....(more online)

   Granular Permissions Below Schema Level Permissions - I currently have a schema "DBA" to hold Database Administrative stored procedures/tables etc..  I need to deny access to this schema to all users.  This is not a problem of course...just deny all actions in the sche....(more online)

   error 70 permission denied - Guys/Gals,My problem is this.... i have a db on sql server 2000 works fine, just created it in 2005 and it no longer works fine.The problem being... my asp page calls a storedprocedure and when it does it falls in a heap with....(more online)

   how do you secure SQL against everyone? - we have a problem. our developers love to write code, not test it and implement it and have applications access sql servers they didn't access previously for new features. problem is that things like blocking comes up along w....(more online)

   creation of userid with rights equal to sa login - Hi can anyone help me with the script for creation a new userid similar to sarights . all the rights should be similar to sa. just to have two userid's for with sa rights.Thanks  ....(more online)

   SQL Server 2005 Express Collation and VS .NET Crystal Report Error - Hi all.I'm sort of newbie in sql server, so this messege could be complicated. I installed SQL Server Express edition with Advanced Services in order to use Reporting Services. Server Collation is GENERAL_CI_AS. During instal....(more online)

   SP to get Server Users - I am looking for the stored proceedure to get all of the users and their rights on a server. I have tried sp_helpuser and this isn't giving me all of the users on the server, just per database, it doesn't tell me the usernam....(more online)

   Converting a cookie to XML - HiCan anyone propose an efficient way to convert a cookie string such as:id=37&pos=down&sess=12345to XML such as:<Root>    <cookie name="id">37</cookie>    <cookie na....(more online)

   Exec SP to all the database in a server - Hi allI want to execute an SP to all the databases. But i don't have the SP in all of them. Please help me.Nithyapriya....(more online)

   How to get a variable resultset - I have this tableCREATE table1Proc VARCHAR(10),PrevProc VARCHAR(10)Both fields are mandatory. In this table sequences are stored of jobs to run. PrevProc will hold the name of the job which has to finish before the job in Pro....(more online)

   tallying values in columns of each row -  I have a table where each row has 20 columns col1, col2, col3 etc...., 16 of which contain numeric indicators ( such as 1=REd, 2=yellow, 3=green)I need to loop through the 16 indicator columns and count how many per typ....(more online)

   Find out if recovery model was changed - Greetings all,Is there a way to find out when and by whom the recovery model for a specific database was changed in SQL 2000?thxTim....(more online)

   Exec(@SQL) - I created stored procedure with in which sql statements are created like this:declare @sql varchar(1000)set @SQL = ----(which is created using the inputs from stored proc parameters)Exec (@SQL)My question is what is this kind....(more online)

   SQL 2000 SP4 DTS Wizzard jobs to Dynamic SQL jobs - We have a number of jobs (backup and data transfer) that were created by my predecessor using the DTS Wizard.  The problem is that if anything changes (i.e., a referenced table is no longer needed and thus deleted) the j....(more online)

   Tempdb is growing bigger - Hi,My Tempdb grows bigger everyweek.Is there any way to find out the cause? How can I avoid this problem?Thanks, R.Prakash....(more online)

   Emergency! Help needed. - Hello,I just have my disk re-imaged, before that, I back up all the data files for SQL 2000, now I am trying to bring them back, however, I got error saying:The file you specified is not a valid sql server database.What I did....(more online)

   NO_TRUNCATE - Hi Guys,Just need some advice. When is it appropriate to use the NO_TRUNCATE in a backup statement. Can I use it if my database is in simple recovery mode?Please advise.IC....(more online)

   Can''t expand Databases node - Hi everyone,I am experiencing a really weird problem. I am running EPM on my local machine attempting to access a remote server. When I try to expand the databases node for that server, I just get an hourglass and it hangs fo....(more online)

   Help identifying errors in DBCC command results - Hi all, i hope you can help here.I am seeing a number of issues when running DBCC command against a DB of ours, the upshot is the following error messages, could someone help in deciphering the results please, and I have very....(more online)

   Restoration Error - Dear All,   I have a problem in restoring the databases onto a standby server with the recent full backup and diff backup as the recovery model is simple. The error message i get is 1. "Cannot associate file with di....(more online)

   SUSPECT database -  Hi, My laptop hanged as I was running a large table update and when I restarted my database was marked as 'SUSPECT'.Running sp_resetstatus @dbname = "mydb" says that the flag has allready been reset but does not make an....(more online)

   SQL SERVER RECOVERY TOOLS - Can anyone recommend any SQL SERVER Recovery Tools?  Server crashed with bad drive, no external SQL Server backups and the dump on the databases was made after the Drive went bad.  There are hundreds of errors when ....(more online)

   insert into multiple tables... help - Now how do I get this query to loop through all the records in the Commercial table? The following only does the first property declare @pic1 as varchar(255)declare @pic2 as varchar(255)declare @pic3 as varchar(255)declare @p....(more online)

   How do I learn? - Hey Guys,I know the basics of SQL server 2000 - installing and all the jobs etc. However, I want to now increase my knowledge further as I want to be a DBA. I would like to know about details of system tables, concepts o....(more online)

   Field name search - Is there way to do a field name search in a particular D.B. for example plug in a field name and SQL Server 2000 returns all tables which have this specified field name?....(more online)

   Large file LOCKINFO - Hello,I see a 17 GB file named LOCKINFO in our MSSQL\LOG directory. I'm not referring to a table (although it may somehow be related to a table in SQL somewhere) but a file listed in the filesystem.Does anyone know what that ....(more online)

   SQL Server 2000 Client Tools - Hi all.I've just got myself a rather nice new desktop machine, and need to install SQL Server client side tools. But someone can't find the SQL Server CD! We have CDs for 2005 but I presume the client tools are different fo....(more online)

   Korean Language displays boxes, Chinese, Thai are OK - Hi everyone, Using query analyzer, when i retrieve data under Korean Language, it displays boxes rather than the actual data.  I have no problems with Traditional Chinese, Simplified Chinese and Thai languages ....(more online)

   Error While Processing the Cube. - Hi,I am facing some error while Processing  the cubes in Sqlserver 2000 Standard Edition.The error message are as below.Step Error Source: DSOStep Error Description:Cannot open connection to Analysis server 'xxxxxxx....(more online)

   High CPU, Multiple Apps - Which Profiler settings ? - We're running several different third party applications in support of our website, and they each have their own database all on the same SQL Server. The applications themselves are on other servers.  Are there profiler ....(more online)

   cluster index - what i understood is we can have only one cluster index for a table. by default primary key is set to be a cluster index. but why sql server 2005 allows to create more than one cluster index. it's so confusing. please advice.....(more online)

   Could not find stored procedure .... error 2812 - Hi There,I am running sql server 2000 sp4.  I am trying to do a transactional replication of a large amout of data (40GB). I have created the publication without issue.  However when I generate the the subscrip....(more online)

   SQL job manager VS querry analyser - i'm running this sample script into querry analyser and is take 2 sc to run when i'm put the same script into sql job manager is took 135 seconde ?? is mistake for me somebody have some information  declare @debut as dat....(more online)

   Cross Join - Hi Experts, Can any experts explain me the exact use of cross join and way of working ? Really i am unable to understand the concept of cross join . RegardsKarthik....(more online)

   SQL Script to run same query on multiple databasa with same table schemas - Hi,We have servers where we have 20 databases with exact same schemas. We need to frequently run same queries on all these databases. Currently we run it by going into each database and running the query and insert the result....(more online)

   Trigger Help - Hello,I am a relative newbie, so if this is simple I apologize.I have an update trigger. This trigger is suppose to act on a column value (columnname is called Status). If the Status turns to Complete or Paid, then it deletes....(more online)

   Sql Query Help - Hi Experts, I got a new work from my RM. Requirement is,Table Name : AcctMastRecords : 2-----------------------------------------------Table Structure : NewTransCodeMSC001MSC002-------------------------------------------....(more online)

   dynamic WHERE clause, Performance issue - I have lots of reports in which there are many fields that are used in dynamic WHERE clause with dynamic sort (ORDER BY field with asc or desc). Following are fields defined in user interface to put required criteria: 1-....(more online)

   SQL Server 2008 Express - Is there to be one ? - Has anyone seen whether there will be a free express version of SQL Server 2008 ? I learnt quite a bit from playing with 2005 express.ThanksPaul....(more online)

   70-447 exam? - I just passed the 70-431 exam and am interested in the MCITP cert.Microsoft says MCDBA's need the 431 and 447 exams to get it.I am an MCDBA, but on SQL 7.0.  I'm wondering if that qualifies.Does anyone know?   ....(more online)

   Book & Practice Test reviews - 70-431 - Just thought I'd pass along a brief review of the various study resources I've been using.  Hope this helps someone out.MCTS: Microsoft SQL Server 2005: Implementation and Maintenance Study Guide (Exam 70-431) by Joseph ....(more online)

   FYI: Use multiple studying sources - I haven't actually taken the test yet, but I've finished the MS Press book for 70-431 and am now reading the Sybex text for it.  And I've already found several things in the Sybex book that aren't in the MS Press book an....(more online)

   Suing the Bully Boss - Did anyone else see this on Headline Prime news?  Apparently there's legislation up in some form of the U.S. government (unsure if it's state or federal) to allow employees to sue bully bosses.But who decides the differe....(more online)

   Is it a lie? - My company hired a SQL Server developer, on his resume he put down he had over ten years SQL Server experiences including DBA skills.  He was a contractor and his last assignment was a developer working on a data warehou....(more online)

   Need recommendations for using either C++/C# to SQL 2005 - Does anyone have any book/course materials that would give advanced technique and knowledge of how to tie into SQL Server 2005 via C++/VisualC++/C#?I'm trying to understand why someone would want to do it this way (as opposed....(more online)

   Trigger to evaluate tricky duplicate - Here is my situation:I have a database that tracks mixed-martial-arts fighters, events, and results.I have a table called dbo.Fight that tracks individual fights at events.I have a column in that table to enter the event at w....(more online)

   Eliminating duplicate rows - Hello all, my problem is that I was running update statements and at the bottom of the page there was a nice little insert statement that i didn't see. So every time I was executing my updates I was also inserting new rows in....(more online)

   Recruiters - Do you like recruiters? Do you use them? It's almost impossible not to use them these days when looking for a job. So many of the listings on online job boards are from recruiters and many have deals to place people, so c....(more online)

   What's an Outage? - I caught this quote from Microsoft Watch, and thought it was very interesting. It definitely addresses an issue I've wondered about for some time. It talks about the WGA server issues and had this great quote from the WGA....(more online)

   What Could Go Wrong? - It's the law of unintended consequences: things happening that you don't expect from a seemingly unrelated area. This article talks about a data center having leaks from carpet cleaning above. The concrete floor had aged ....(more online)

   Subscription not setting up in SQL SERVER AGENT - I'm having an issue whereby I can't get a report to create a subscription.  The issue seems to stem from the tbl SysCategories in the msdb does not contain the category_id '100'.  I"ve tried inserting the catID into....(more online)

   Blank first page in a report - Good Morning,I've got an SRS consisting of a report (Benefits confirmation form) that is a subreport in another report. When I run the subreport by itself for one employee it is fine, but when I run the main report (for eithe....(more online)

   View Report on the same form - Hi ThereI have an Windows Application developed in VB.Net 2005 & SQL Server 2005.Question,I have an Form, in which i have an Menu & Report Viewer Control on it. When ever a user selects a report it is currently openin....(more online)

   Cannot connect to ReportServer - Hello All,I am trying to install and run SSRS 2005 on a Windows XP Pro workstation.The installation completes and I have used the configuration tool to configure reporting services. All first six icons on the left are green.&....(more online)

   Moving Reports - Question: Once a report has been deployed in reporting services can its location be changed? I deployed using VS.NET....(more online)

   Missing Reports in VS.NET - I can not locate reports that I have previously deployed into Reporting Services from VS.NET.When I am in VS.NET the report is nowhere to be found, but the subscriber in Reporting Services is still receiving the report via em....(more online)

   Converting from Oracle 9i to SQL 2005: Keys & Triggers - Hello All - Was not sure if this would be the appropriate place to post this thread or not, but wanted to see if anyone might have already gone through this kind of conversion?The main concern that I am being flagged with is ....(more online)

   help with relations.. - hi,maybe you can help me with the following scenario:- there are single parts - there are part-lists that can contain both, single parts and other partlists- there are locations, parts can be at multiple locationsso far so go....(more online)

   design for tracking dates multiple check in check out - I have a table that tracks plan reviews for a project. There are some dates in there that track recieved and returned dates of plans. Based upon the changes that we suggest there will be multiple recieved and returned dates. ....(more online)

   In Recovery Mode - Hello,I have a SQL Server 2005 Enterprise Edition and a big database. My database has been "In recovery mode" status after a big delete operation. My disk size is not enough to finishing recovery. How to cancel or disable In ....(more online)

   Bill of material hierachies - Hi,I'm new to Analysis services, and have searched a lot in books and online for some pointers regarding a problem I have. I'd be very happy if someone could point me in the right direction here.I have a self-referencing tabl....(more online)

   Automating the conversion of DTS packages to .BAS files - We want to automate the conversion of all the packages on a server to .BAS files so that we can extract table, column and stored proc dependencies. There is no need to put them back, we just....(more online)

   SSIS Data Conversion - I'm creating my first SSIS package and I have yet to fully understand the data conversion. I have a table with a single varchar(75) column. And example would look like this 4032555445552215555333 I need to grab some sub....(more online)

   SSIS 2K XML Problem - I have an interesting problem in that I am using SSIS to talk to several SQL servers to extract data from them in XML format this is no problem with 2005 however when I run a query like "select  name from master.dbo.sysd....(more online)

   SPLIT function in VBA - friends,I am working on a MS Access project, where I want to get individual characters of the string. I am trying to use 'split' function for this but was unable.Please help for using split function for continuous 14 char len....(more online)

   The Power of Merge - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/3122.asp....(more online)

   Passing a Table to A Stored Procedure - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/2977.asp....(more online)

   Passing a Table to a Stored Procedure - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/3182.asp....(more online)

   Creating a Script from a Stored Procedure - Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rrandall/creatingascriptfromastoredprocedure.asp....(more online)

   Avoid enclosing Indexed Columns in a Function in the WHERE clause - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/additional/3251.asp....(more online)

   Reverse Engineering Alias Data Types in SQL Server 2000 - Part II - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/yShlafman/3213.asp....(more online)

   Reverse Engineering Alias Data Yypes in SQL Server 2000 - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/yShlafman/3038.asp....(more online)

Backup SQL Server Database with Move/Copy File

By: Anonymous - Posted: 5/16/2007 10:52:42 AM (  (Stored Procedure))

The following script performs log, differential or full backups of a single, or all databases on your SQL Server.  It then copies or moves the file(s) over to a network share drive.  It also removes old backups from both locations if needed.  Don't forget to set the local drive path and network share for each backup in the backupretention table.  Also remember, to set the relocation action of copy or move.  I included the create table script as well