Hi,
You can use the xp_cmdshell to read the contents of a text file.
You can look at the sample at
http://www.kodyaz.com/articles/read-..._cmdshell.aspx
Eralper
http://www.kodyaz.com...
eralper
Last Activity: Nov 16 '11, 07:01 AM
Joined: May 6 '06
Location:
-
Did you check whether the ASPNET user account is not locked.
Because of a some reason this user may be locked.Leave a comment:
-
Hi,
I think all are the same but I wanted to add the below sample
SELECT COUNT(*) FROM Sales WHERE DATEDIFF(m , InsertDate , GETDATE()) > 6Leave a comment:
-
Hi,
Unfortunately KILL command can not be used this way. KILL is an exception in the syntax that you are trying to use.
But you can use KILL like below, declare variables once.
DECLARE @SQLString nvarchar(255)
DECLARE @SPID smallint
Then in the loop each time, you should run the below code statements
SET @SPID = 52
SET @SQLString = N'KILL ' + CAST(@SPID AS CHAR(5))...Leave a comment:
-
Hi,
Check the below page for a list of event key codes.
Also you can check any key by entering it on a textbox and see its key code by a script running on that page.
http://www.kodyaz.com/content/HowToGetKeyCodesList.aspx...Leave a comment:
No activity results to display
Leave a comment: