Hi Azzam,

The given query does not give any records.

Please check the query

Will DBCC Reindex update system tables? If not why?

Anyone could explain on this...

Once you executed Sp_dropserver 'oldservername'

and sp_addserver 'newservername','local'

you can verify the server name by

Select @@servername.

Now the servername should reflect the new server name.

Otherwise stop and start the SQL Server service...

Colin,

This is my understanding from your reply.

DBCC Reindex would update statistics of Indexed columns only.

If there are manually / auto created statistics exists on non-indexed column those statistics are unaffected....

Ian Scarlett,

Do you mean to say that when there is space constraint to take full backup it would be useful?

But this make SQL Server to believe that full backup being...

When this stament would be useful? for what?

Please explain..

Hi rudy;

Database data size is 10 GB and log sizes 4 GB.

Yes, I am using maintaing plan to take full backup of the database.

No transaction log backup being schedulled currently.

Have...

Also try  with sp_password. More on sp_password can be found on BOL.

1. To Check the version:

  On Registry check the following for SQL Server version

   \\HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSSQLServer\CurrentVerion

    From the version number, you can drive it's Service pack and hotfix...

Kishore,

"

 You could modify your SQL Backup Maintainence Plan to delete the file.

I mean if you are taking a backup at 10:00 am, you could ask the plan to delete the...

what's reason of file not get deleted?

I would add /Q /F in del command.

Like "master..xp_cmdshell 'DEL /Q /F D:\SQLBackup\*.bak "

Though the file not being deleted by...

Actually in my case when the fail over happened to the Node 2, the backup job for the user database was running.

What happened was the databse backed up during...

Hey,

I checked and found the SQL Service accounts have "Log on" previleges on the both nodes.

- Sivaprasad S

Hey, It is as simple that.

Just add "Builtin\Administrators" on Security --> New Logins on type Windows

That's it.

Rudy,

Have you checked active directory ? Specifically the 'Account' tab, 'Log On To' button ?

 Can you elobrate on what do I need to check on 'Active Directory"...