Recently there are serious blocking issues occured in one of our product databases, though I turned ON the 1222&3605 trace flags, there are no useful...
My Original_login() is a windows account. use [master] select orginal_login() Return:TFHGFHG-2005C97Administrator select user_name() Return:dbo But...
Hi all, I wrote a DDL trigger to audit the operations agaist certain product databases. Since there are three databases aduited, so I wanted to...
If I do a full backup for databases configured with log shipping, since this operation will truncate logs, will it make the log shipping failure? If...
Pls help me solve this issue about parition table. You can run the following code on your SQL Server. Thanks for any advice. USE [AdventureWorks] GO...
Hi, I am doing a test: To create a DLL trigger on database level to detect the issue of ALTER TABLE and DROP TABLE statements. I want SQL Server...
Hi all, Could you help me check following query code? It takes 9 seconds to return the result, but rows of it is just 2. If I remove DISTINCT,...
I met a strange problem when defragmenting indexes by re-creating indexes. If I re-create indexes in SQL Server Enterprise Manager and then check...
Hi, I tried to install SQL Serve 2005 Enterprise Edition on my PC of which OS is Windows Server 2003 Enterprise with SP2, but an error message...
Hi all, I did a SELECT statement on a partition view "YMDWK",but there is a problem for get the best excution plan©s One of the base table's...
I found the hostnames which the active window shows me were invalid. For example,after I login SQL Server, I can find my pid in the active window,but...
Hi, this morning i got an odd question©s I ran a stored procedure ,but it was very slowly,but when i copied out the code of this stored...
Hi, I moved all of the databases(include system db and user db) from A server to B server: backup the databases form A,and then restored them to...
To run this code you will see the log : SELECT * FROM ::fn_dblog(null, null). But I still can't see the data which I updated/deleted/inserted. Does...
A disk was failed so the database losed a file which named SubData.ndf.I have a full database backup and the newest of log backup.but I don't know...
How to login a sql server when it's default database was broken? I got this error message: Cannot open user default database'<ID>'.Using master...
Hello, I got a serious error when I used a UPDATE statement to update a table this morning.please help me. I also got a error message from the...
Table "USERDB" stored the information of application 's users ,it's owner is dbo.<br />It has 3 columns :USERNAME ,PASSWORD ,USER_MARK ©s<br />there...
Hi, How to write this select statement ? For exsample,select the dates that between today and 7 days ago. the result must be like...
The OS's edition is professional,The SQL Server is Deskop editon of 7.0+SP4. when I try to connect to the Server ,It's show me a error message like...
Separate names with a comma.
