Dear Jeff,

Looks like you have found the problem, But how are you planing to remove the server from domain and add it back.

It would require downtime...!!!

Why not make a local...

Thank you Grant and GilaMonster. I guess i have to be more Conscious from now.

Regards

Shafat Husain

Hi,

Found a wonderful article on this topic.

# http://blogs.msdn.com/b/repltalk/archive/2010/11/17/how-to-cleanup-replication-bits.aspx

Hope it helps..!!

Regards

Shafat Husain

Dear Tsinelas,

Yes it is possible to change the collation on the server level, however it is a complex process and requires a lot of preparation.

You will have a rebuild the...

Dear Jeff,

Could you please share the screen shot of configuration manager and uninstall screen where you are facing the actual issue.

Regards

Shafat Husain

Dear Vijay,

If you only have a default instance then the name of the SQL Server Instance would be your machine name. You can check with the listed query.

select @@servername

Copy the...

Hi,

NULL takes up the size of underlying data type Plus one bit for the null flag.

If you have a lot of NULL columns in your table then defining your column...

Dear Vijay,

There is no need to rename the machine as your SSIS packages would be connecting to the instance name of your SQL Server.

As you have not mentioned if you...

Dear Jeff,

Are you able to see the named instance under you SQL server configuration manager?

From what you are describing it seems that the instance is either not available on the...

Hi,

Checksum and verifyonly essentially performs the same function, But still a healthy combination of both would go a long way.

I take all the backups with checksum and regularly keeps on...

Hi,

Consider using OPENROWSET.

SELECT * INTO LocalDb.LocalSchema.LocalTable FROM OPENROWSET('SQLNCLI', 'Server=localhost;Trusted_Connection=yes;',

'EXEC [11.169.101.05].MyDB.MySchema.MySproc')

Hope it Helps...!!

Regards

Shafat Husain

Hi,

Under SQL Server configuration manager check if the reporting services is turned ON if not turn it on and then check.

Under reporting services configuration manger check the Report Manager URL,...

Hard Luck...!! :ermm:

Hi,

From what i can find on the internet, I think it is ok to Skip tempdb from the Audit.

Still i would prefer that you take advise from some of the...

Dear Bugg,

Check the windows event viewer. Under application check SQL Server.

You will definitely find something useful

Hope it helps..!!

Regards

Shafat Husain