if you know the table and its related records for that specific one school then you can create one blank database and export the data with table definition to desitnation...

just tested this wonderful scripts and definately one of the must in job schedules.

One thing I would like to know that as soon the script completed it created the job....

USE tempdb

GO

-- Get Backup History for required database

SELECT

s.database_name,

m.physical_device_name,

CAST(CAST(s.backup_size / 1000000 AS INT) AS VARCHAR(14)) + ' ' + 'MB' AS bkSize,

CAST(DATEDIFF(second, s.backup_start_date,

s.backup_finish_date) AS VARCHAR(4)) + ' ' + 'Seconds'...

to check your current usage of a table, run this :-

SELECT alloc_unit_type_desc,page_count,avg_page_space_used_in_percent,record_count FROM

sys.dm_db_index_physical_stats(DB_ID(),OBJECT_ID(N'dbo.Test'),NULL,NULL,'Detailed')

** make note of avg_page_space_used_in_percent

now run

dbcc cleantable('databasename', 'tablename')

once it...

sqlserveragent is a service and a service always configured only on one specific...

1) insert into is helpful when destination table have similar columns as of source table.

As well you have to make sure that column's datatype are matching while inserting records.

So...

there are 2 things which I would like to ask :-

1) Is your sql agent service running? go in services and check the account which is configured for agent...

yes it will work if primary on 2005 and...

most of the timing is being used at index scan. Check how up-to-date your index is?

What I mean is fragmentation of index. Seems like your index is highly fragmented.

open SSMS -- right click on your database-- reports-- standard reports -- schema change history

if you just looking that what were the modification at schema level, like alter/delete or create then in SSMS 2008 you can use the inbuilt report named as 'schema change...

Its because of your in operator. Which means if its in the list then ok else...

http://decipherinfosys.wordpress.com/2008/01/02/finding-the-port-number-for-a-particular-sql-server-instance/

instead of exporting from sql, you can connect your excel to database directly by selecting correct provider and correct connection setting.

Once your connection is authenticated, you can provide your query...

i think the language is defined at the server level not the user specific level.