Hi,

Thank you. Below one worked for me.

$QueryResults[0].Table.Columns.Count

Apologies. I tried to post but I was unable to post somehow. Once again Thankyou

It gives only the number of rows but what I want is number of columns

System.Object[]

I tried it already does not work

$QueryResults.Columns.Count

or

$QueryResults.Items.Count

is not working

Hi Prem,

From SQL 2005 and above versions there is no need for you to restart the SQL Services when you want to move...

Hi,

Did you make any changes in the server. Did you check the event viewer for any errors.

Hi Mahesh,

SP4 is not yet released for SQL 2005. Can you confirm whether it is 2005 or 2000.

Hi,

You can use bcp with xp_cmdshell or openrowset. Please refer to the following links. I recommend you to use open rowset. Please refer the following links.

bcp...

What is your recovery model. What is your backup plan. Without this I think its difficult to answer this. But if you are using full recovery model then you can...

Here is an excellent article which shows you to how to implement sql clustering on windows 2003 on your pc

http://blogs.msdn.com/blakhani/archive/2007/12/31/how-to-create-sql-20005-cluster-on-virtual-server.aspx

Hi,

Are you using native backup or litespeed backup. If you are using litespeed check out this

http://www.sqlservercentral.com/Forums/Topic566942-146-1.aspx

Hi,

Just checked the logshipping. Restore process is failing with the following error.

2009-08-08 01:15:02.06*** Error: Could not apply log backup file '\\chandu\d$\sss\mydb_20090807191502.trn' to secondary database 'mydb_logshipping'.(Microsoft.SqlServer.Management.LogShipping) ***

2009-08-08...

Hi,

Jamie thanks for the info. I agree with you. Backup of secondary database whether in standby or norecovery mode fails. Only alternate option is database snapshot....

Hi,

I think this may help you.

select dp.NAME AS principal_name,dp.type_desc AS principal_type_desc,

o.NAME AS object_name,p.permission_name,p.state_desc AS permission_state_desc

from sys.database_permissions p left OUTER JOIN sys.all_objects o

on p.major_id = o.OBJECT_ID...

Checkout this http://technet.microsoft.com/en-us/library/cc917680.aspx