Noticed that in both tables the column "ID" is defined as nvarchar(13) but the example data is "001", "002", "003". Is this column actually a numeric data type or...

Here you are but it does do more than you have requested. Note that RECOVERY is set to SIMPLE.

IF OBJECT_ID('tempdb..#AlterSQL') is not null drop table #AlterSQL

create table #AlterSQL

(AlterSQLnvarchar(4000)

)

insert...

IMOP, using the return code to contain data values is a new Worst Practice !

I do not believe the information on mapping a view column to the dependent table columns is available within SQL Server. There are many situations where a single view...

James Cornell suggestion regarding different accounts is ok and is a simple solution. You could also look in each SQL Server's errorlog file to get the process id and...

BCP.exe does support providing a select statement or the execution of a stored procedure in addition to specifying a table. Suggest that the stored procedure name be fully qualified.

Here is...

A few other suggested books are:

SQL for Smarties: Advanced SQL Programming

Author: Joe Celko

Publisher: Morgan Kaufmann Publishers

ISBN-13: 978-0123693792

http://www.amazon.com/Joe-Celkos-SQL-Smarties-Programming/dp/0123693799/ref=sr_1_1?ie=UTF8&s=books&qid=1211911045&sr=1-1

The Data Modeling Handbook : A Best-Practice Approach to Building Quality Data...

Calendars are a frequently asked question and an answer can be found at

http://classicasp.aspfaq.com/date-time-routines-manipulation/how-do-i-count-the-number-of-business-days-between-two-dates.html

You should only run the sqlservr.exe from a command prompt to isolate a problem with running as a service and you should not perform any other actvities other than stopping...

Or you can convert an existing non-clustered index to clustered using the "DROP_EXISTING" option. Note that you cannot convert a clustered index to a non-clustered index.

I have included all of the maintenance procedure I wrote. These procedure have been tested with SQL Server 7, 2000 and 2005 with both case-sensitive and insensitive collations. ...

Please provide DDL and sample data per http://www.aspfaq.com/etiquette.asp?id=5006

There is also an extended stored procedure that can be used but the resource usage is substantionally higher than a distributed SQL to AD.

exec master.dbo.xp_logininfo 'BUILTIN\Administrators','members'

Please provide DDL and sample data.

For details, please read http://www.aspfaq.com/etiquette.asp?id=5006

"delete the backup chronology made out of external sftw using the same query (re-adapted) contained into msdb.sp_delete_backuphistory"

As the information in the msdb backup tables is not used by the restore...