Viewing 15 posts - 16 through 30 (of 58 total)
namrata.dhanawade-1143388 (2/23/2011)
Set @Footer = 'echo RECORD COUNT: >> D:\Work\Test.txt'
exec xp_cmdshell @Footer
This works fine.
But this command also inserts a default <CRLF> at the end of 'RECORD COUNT:' when written...
February 23, 2011 at 10:46 pm
The error indicates an earlier log backup needs to be restored first. Is there any other tlog backup happending on the server before your last tlog backup? Have a look...
February 23, 2011 at 10:23 pm
amirs-717937 (2/21/2011)
your script i have already execute. i have already db_owner right to this user.
i have check login status to execute following query...
February 22, 2011 at 8:34 am
Bungholio (2/22/2011)
Running connectivity tests...
Attempting connection
Connection established
Verifying option settings
Disconnecting from server
TESTS COMPLETED SUCCESSFULLY!
But not working from...
February 22, 2011 at 8:16 am
Bungholio (2/22/2011)
That's all I can see in the log: 18456 severity 14 state 5
The NT team is saying the...
February 22, 2011 at 8:05 am
You will need the agent if you want to run scheduled job under a particular instance. If there is no need for any scheduled jobs, such as maintenance jobs, to...
February 22, 2011 at 7:27 am
kasi5a (2/11/2011)
I AM HAVING SOME PROBLEM AND DOUBT..
EXEC SP_EXECUTESQL @BUILDTABLESTR IS THERE ANY PERMISSION TO OTHERS??? TO EXEC...
February 21, 2011 at 9:27 pm
Have you actually test login as that user? Maybe password has been changed?
February 21, 2011 at 9:23 pm
If I understand your requirement correctly, you are trying to give that user the dbo permission. DBO is a database role. To grant someone dbo permission, simply add them into...
February 21, 2011 at 9:19 pm
PaulB-TheOneAndOnly (2/20/2011)
I usually use syntax below...
if exists (select * from sys.tables where name like '#mytemptable%')
temp table is created in TEMPDB, unless you already in the TEMPDB, you have to fully...
February 21, 2011 at 5:35 am
Try drop it just before the insert and see if that helps.
IF OBJECT_ID('TEMPDB..#TEMP') > 0 DROP TABLE #TEMP
February 20, 2011 at 9:52 am
Try this:
declare @a1 as char(1),
@a2 as char(1),
@a3 as char(1),
...
February 20, 2011 at 9:22 am
The instruction looks OK. I assumed you received table #TEMP already exist error message. Any chance you can post your actual code?
February 20, 2011 at 8:59 am
SQL2005 can be installed side by side with SQL2008. Can you post the actual error when trying to install?
February 20, 2011 at 8:30 am
Even if the record id is not primary key, as long as it's unique on the exist data and in a increment trend when they were entered (or it will...
February 19, 2011 at 7:40 am
Viewing 15 posts - 16 through 30 (of 58 total)