Check out:

http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx

http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx

Check out:

http://msdn.microsoft.com/en-us/library/ms146927.aspx%5B/url%5D

Views wont fail.........

Views are a useful tool to have in your database tool arsenal. More portable than functions, more flexible than stored procedures, view can give your database more secure,...

Shrink the file.

--

--Backup log

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

--If needed issue...

You have taken the right step by joining SQLSERVERCENTRAL.COM

Now that you are in the right hands stick with us.

Find the attached you might find it useful.

Check out:

http://www.sqlservercentral.com/Forums/Topic429161-291-1.aspx

http://www.sqlservercentral.com/Forums/Topic429161-291-2.aspx

http://social.msdn.microsoft.com/forums/en-US/sqlreplication/thread/ffcfa9d2-d295-404c-be78-02a0138798e3/[/url]

http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/e0fbaec7-fcb1-4860-9377-34dcd8e3db9f/[/url]

Check out:

http://msdn.microsoft.com/en-us/library/aa238420(SQL.80).aspx

http://msdn.microsoft.com/en-us/library/aa238405(SQL.80).aspx

If there are 2 data file and 2 log file its not an issue

The extra files will be created when you restore the database.

You can give permissions as you would on a normal SP, IE use GRANT EXECUTE (look up http://msdn.microsoft.com/en-us/library/aa260689(SQL.80).aspx).

xp_cmdshell is a touchy subject. You do need to be very careful when...

why give "CLUSTERED" in your alter command .

when you add a primary key it always creates clustered index.

To...

Please give the table structure and the query that is used to get the detail of the tenant and product.

Check weather named pipes are enabled.

when you script out the jobs see to it that your tsql job steps dont have "GO" batch breaker.

If its there the script will give error while executing.

It...

i think the ans is varchar(1).

Thanks a lot for the script........

Is "sys.sql_modules" the alternative for "sysdepends" .

When ever I perform dbcc shrinkfile after transactional log backup in full recovery it didnt shrink my log file.

When i started issuing checkpoint after performing transactional log backup in...