I thought the CTE would do it. Anyway I have an alternative solution using loops. I am sure this is slower. So see if you could use some indexes to...

Thanks for the replies you guys.

Let me add more here: The application code relies on the order by clause in the view to sort the results. So I cannot eliminate...

I'd say use a decent text editor and delete the extra tabs.

If  there are any active transactions the log file will not shrink. Try DBCC OPENTRAN to see if there any open transactions.

Vivien,

That should cover almost all situations. This is the document I followed after I installed a SQL cluster recently.

Good luck.

Venu

That's interesting!

Thanks.

Venu

Thanks for sharing the info.

I think only one table filtered any time. You may probably know this, but the same functionality can be achieved by querying sys.objects system table.

Hi,

I am just throwing some ideas and not sure they will work. Follow these steps only if your database is not marked suspect.

Idea # 1: If the oldDB is in full...

I did not try this. Instead of using T-SQL to unlock an account, what if we use the SSMS to unlock it? Does it still ask for a new password?

I...

I think I can answer your question. The reason a login is locked is because there were three consecutive invalid login attempts right? Say a hacker is trying to do...

I think you should be a local admin on the SQL 2000 box to run Upgrade Advisor.

Venu

I think you should give read-write access to 'Network Service' for database files at file system level. Right-click on the files, select Security and add 'Network Service' and grant read...

Hi Kristi,

Ask your sysadmin to add R, L and T drives as dependencies to the SQL Server service resource in the SQL cluster group. That should resolve the issue.

Good Luck.

Venu

I am not aware of any tools which can accomplish this. I can give you a suggestion though. Query the syscomments table (view in SQL 2005) like this:

select so.[name]...