Search results for query: *

fastmatt , You may ommit WITH keyword in many cases. However , you'll get a error message, if you do it in an INSERT Statement as below: INSERT INTO Table WITH ( LockHint ) VALUES ( ColumnList ) The messages is: Server: Msg 110, Level 15, State 2, Line 1 There are fewer columns in the...

Hey all, I have a table and two following transactions: Table11 ( DD int , CC int ) -- with no PK or index ... BEGIN TRAN 1 INSERT INTO Table11 VALUES ( 6 , 6 ) -- ROLLBACK TRAN 1 -- COMMIT TRAN 1 BEGIN TRAN 1 SELECT * FROM Table11 WHERE DD = 1 -- ROLLBACK TRAN 1 -- COMMIT TRAN 1 I...

Robert , I checked it. It starts manually with no problem. The user name and password is correct and the same as sqlserver itself. There's also nothing in the sql log. However, ther's two errors in the NT's Event Log. In the system 7022 and in the application sectio 103 are the error IDs...

I use MSSQL Server. I let SQL Server Agent to "Autostart when OS starts". The problem is that when I have to restart the server , the agent doesn't start and I get the famous message "At least on of your services ..." :) Subsequently, Once I check NT's event log , I see the...

You can pick one of the following: 1. add a constant number as a column to your SELECT which indicates the order of executed statement. Then, sort the whole results by it. SELECT 1 AS SortNo , YourFieldList1 ... UNION SELECT 2 AS SortNo , YourFieldList2 ... ORDER BY SortNo ... 2. Create a...

=> All Accepting and admiring your tips, since many people may answer a question in a thread or reply one of the answers, as a new member , I suggest that anybody who's going to reply , points to the "main" receiver's name. Like What I did in this post or something! That way we'll...