Viewing 15 posts - 526 through 540 (of 1,292 total)
Have you tried retrieving the error logs from the \LOG directory using a text exitor?
What does it shows in the current error log?
December 15, 2009 at 8:03 am
CirquedeSQLeil (12/14/2009)
The issue must have resolved itself
I guess so.
December 14, 2009 at 9:30 pm
dinu14 (12/14/2009)
I need details... wat transformations do i need to make dis pkg successful
Transformation? You have not mentioned anything about transformations until now and what transformations to use depends on...
December 14, 2009 at 8:46 pm
dinu14 (12/14/2009)
i have a peoplesoft date column ..in that date column i need the recent date compared with SQL date column.
Unless someone who wants to help is already aware of...
December 14, 2009 at 7:43 pm
This is not a complete solution since there is no table DDL, and column details and I am not advanced level developer ( I am a DBA)
Construct a Temp Table...
December 14, 2009 at 6:43 pm
George is right. In what way is it Hot Standby Server.
If it is a Hot Standby Server why are you planning to detach and delete the databases?
Have you got...
December 14, 2009 at 6:15 pm
Under TSQL
Choose the 2 events SQL:BatchCompleted and SQL:BatchStarting
December 14, 2009 at 3:17 pm
The error seems to be with variable also, not just the security permissions.
Check the variable name reported in the error msg and see if that variable is out of that...
December 14, 2009 at 3:13 pm
hydbadrose (12/14/2009)
Does the sql services needs to be restarted in order to take the effect?
NO! SQL Server does not need to restart.
December 14, 2009 at 3:09 pm
rahulsony111 (12/14/2009)
How can i edit those .bat files.
You can edit a .bat file (batch file) from any text editor, including notepad.
December 14, 2009 at 1:29 pm
jayoub1 (12/14/2009)
First: What does Buffer Cache hit...
December 14, 2009 at 1:22 pm
MAK-1128556 (12/14/2009)
server type : SQL Serversecurity: be made using the login's current security context
server option: Data access -True
Rpc - true
Rpc out -true
use remorte collation -true
When you use that security setting,...
December 14, 2009 at 9:17 am
Stefaans (12/14/2009)
Bru..Thanks a million, that was the problem. very much appreciated.
regards Steve
You are welcome !
December 14, 2009 at 9:13 am
What abt server details you are using when creating Linked Server.
December 14, 2009 at 9:07 am
Viewing 15 posts - 526 through 540 (of 1,292 total)