Viewing 14 posts - 391 through 405 (of 405 total)
Is there an issue with authentication?
What is the authentication you used to test the script.
Check the authentication of SQL Agent
January 19, 2009 at 6:29 am
Try to fine tune the code. Choose proper indexes
Think of enabling row versioning (Pls monitor tempDB growth if you choose to do so)
January 19, 2009 at 6:25 am
what does it say if you execute
sp_dboption Database,'trunc. log on chkpt.'
You can verify LSN info using
Restore headeronly from disk='YourBakFiles'
January 19, 2009 at 6:06 am
1. Backup your log file
2. DBCC SHRINKDATABASE(Databasename)
January 19, 2009 at 5:39 am
Right click the database in Enterprise Manager> all task >Shrink Database
You can also use DBCC command
January 16, 2009 at 6:10 am
Its because purchase Id is different. Omit purchase ID in the second view and try
January 16, 2009 at 5:15 am
set @sql='INSERT INTO dbo.ImportError
(DataElementID, CenterCode, ValueType, ValueDate, [Value], ImportDate, BatchID, ErrorReason)
SELECT
...
January 16, 2009 at 5:05 am
put the whole query to a variable and print it. I think you need to give a space after the where clause
January 16, 2009 at 4:58 am
run the procedure manually. Check howmuch time it takes (It may timeout)
Check remote query timeout setting
sp_configure 'remote query timeout'
default is 600 , ie 10 mins
change it to appropriate value
dont forget...
January 16, 2009 at 4:50 am
Try additional quotes around the variables - two single quote for escape
EXEC('
INSERT INTO dbo.ImportError
(DataElementID,...
January 16, 2009 at 4:44 am
How and when to use them?
Inner join uses a column on first table to match rows in the second table.
eg
Select * from Students,Teachers where Students.TeacherID=Teachers.ID
This is inner join...
January 16, 2009 at 4:00 am
Like Gints / Jeff said, only a veteran in both Oracle and MS SQL can give a defenite (and objective) answer based on their hands own experience. Even then people...
January 16, 2009 at 3:25 am
Recovery models: Log growth/ Shrinking is resource intensive. In full, bulk logged, log growth apparently should be more. However this may depend on your hardware, and the physical design. You...
January 2, 2009 at 12:24 am
Finally it got released on December 15, just one week before I was suppossed to do a risky Patch updation on our production.
:Whistling:
Cheers to the site.
Thanx to all who voted...
December 29, 2008 at 4:43 am
Viewing 14 posts - 391 through 405 (of 405 total)