Revoke the permission on master database. Grant permissions on the requisite database make it the default database for that login

Please check if the file "C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof" exists.

If it does not exist you can copy it from a server which is of the same build. It had...

It is not recommended to run Profiler trace on Production Instances. Instead use Server Side traces. An example here[/url]

1) Check the System Event Log for any related errors

2) Check the SQL Server Error Log (Errorlog)

3) Try starting the SQL Server from the Command Prompt. Details here

These options will...

Agree with Steve. Re-indexing the tables based on the value of avg_fragmentation_in_percent column in the below query is the efficient way of rebuilding indexing in SQL Server 2005 and above.

select...

Here is the Official Documentation.

Here is what mentioned in MSDN

"STATS_DATE Returns the date of the most recent update for statistics on a table or indexed view."

Read more on this here

Please take a FULL database backup before dropping the tables.

You may use the below query to delete USER tables from the database.

DECLARE @TABLENAME VARCHAR(256)

DECLARE @QRY VARCHAR(256)

DECLARE TABCURSOR CURSOR FOR

SELECT...

I was able to find the estimated_completion_time on a SPID which was in SUSPENDED state.

percent_complete estimated_completion_time status

---------------- ------------------------- ------------------------------

99.64832 77066 ...

SQL Server does not have this feature yet. There are couple of request at Connect to incorporate this feature.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=468517

https://connect.microsoft.com/SQLServer/feedback/details/468517/update-statistics-at-the-partition-level

elham_azizi_62 (10/25/2010)

---

hi all.

we want to log changing data such as isert,delete and update that users perform.we can do this.but now we want to khnow

which user do this changes?I want...

I did not understand your question correctly.

STATS_DATE() gives you the date on which the statistics for an index were update (update stats or alter index). Here is an example

SELECT

B.Name,A.Name as IndexName,

STATS_DATE ( a.id ,...

I was referring to "Casing for built-in function names" under that option.

But it seems to control the casing for BUILT-IN Function only

From my earlier reply.

"This query worked fine for me. Please confirm if you are connected to a SQL Server 2005 instance."

Most likely you are executing this query on a SQL...