This might intrest you

http://msdn.microsoft.com/en-us/library/ms190664(SQL.90).aspx

SQL Server doesn't immediately shrink log files when you issue the DBCC Shrinkfile command. The DBCC Shrinkfile operation occurs only at...

Use DB_TEST

BACKUP LOG [DB_TEST] TO DISK = N'C:\BackupLOG\DB_TEST_log.trn' WITH NOFORMAT, NOINIT, NAME = N'DB_TEST-Transaction Log Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

checkpoint

dbcc shrinkfile (DB_TEST_log,target_size)

For executing dbcc...

Thanks a lot.......

But this script is again showing me all the procedures and also trigger and chk constraints when i run

EXEC uspShowDependency 'P'

I think you can use this as a starting stone.

CREATE FUNCTION dbo.fn_MaxInt(@Num1 INT, @Num2 INT)

RETURNS INT

AS

--Helper function

--Return the larger of two integers

BEGIN

RETURN CASE WHEN @Num1 > @Num2 THEN @Num1 ELSE...

No i have stored procedures in my database that are not depending on any tables......

How to get that also along with the once that depend on tables......

I heard that "SYS.SYSDEPENDS"...

Thanks a lot........

Hai will it also give the stored procedures that doesn't depend on any table......

Check out:

http://www.databasejournal.com/features/mssql/article.php/1439731/Using-SQL-Server-Cursors.htm

http://www.sql-server-performance.com/tips/cursors_p1.aspx

http://www.sqlservercentral.com/articles/Advanced+Querying/2785/[/url]

http://www.sqlservercentral.com/Forums/Topic466467-149-1.aspx

http://support.microsoft.com/kb/837957

Hi Santhappan

When i exec the script you gave im also getting the constraints and triggers in the database.........

Can u please share the script

Thanks a lot guyz

Check out:

http://blog.sqlauthority.com/2007/08/10/sql-server-2005-find-stored-procedure-create-date-and-modified-date/[/url]

http://blog.sqlauthority.com/2006/12/10/sql-server-find-stored-procedure-related-to-table-in-database-search-in-all-stored-procedure/[/url]

http://www.sql-server-performance.com/articles/dba/sp_dependencies_p1.aspx

You can use high availability options.

I think mirroring will do.

Yes i think you can add 2005 as a linked server to 2000 if u have given the proper credentials..........

You can generate the script of the whole database including the objects using "Generate SQl Script Wizard".