Viewing 15 posts - 31 through 45 (of 125 total)
Sean Lange (2/25/2011)
Carlton Leach (2/25/2011)
My 5 cents is always use a temp table. It behaves more like a real table than a table variable does.Carlton.
There are perfectly valid reasons to...
February 25, 2011 at 9:45 am
Personally: In your shoes I would be more concerned about the raid levels of your disk pools than whether it's 'lunned'.
Carlton.
February 25, 2011 at 9:30 am
My 5 cents is always use a temp table. It behaves more like a real table than a table variable does.
Carlton.
February 25, 2011 at 9:18 am
It depends, there are I guess pro's and con's either way. Let the storage guys and girls worry about it 😀
Carlton.
February 25, 2011 at 8:40 am
Failed login for TNHost on the cxmain database. That's the error.
Either grant access to the cxmain database for the TNHost login. Or change your datasource to connect using another account...
February 25, 2011 at 7:07 am
Kari Suresh (2/25/2011)
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data...
February 25, 2011 at 6:22 am
Depending on how you've gutted the old solution: Could be trying to insert into NewCol that doesn't exist as yet (hasn't been initialised).
Carlton.
February 25, 2011 at 5:34 am
Do all reports fail or just one? check the datasource the report is using.
Carlton.
February 25, 2011 at 5:12 am
rajasekhar.bollareddy (2/25/2011)
so no difference both are same
An empty string an NULL are the same? Nope.
As stated NULL is an unknown value not an empty string (we know it's a string,...
February 25, 2011 at 4:43 am
Tell your manager that you've checked with all of us and: it's not possible to shrink tempDB 😀
Carlton.
February 25, 2011 at 4:26 am
Is all your security configured the same? same users/service accounts etc?
Are there any failed logins on your SQL box?
Can you create an odbc connection from your rs box to SQL?...
February 25, 2011 at 4:20 am
Instead of changing the isolation level: look at your delete code, in particular: execution plans.
Does the delete query hit appropriate indexes?
Are your statistics up to date?
Carlton.
February 25, 2011 at 4:15 am
What happens if you provide the missing value?
Carlton.
February 24, 2011 at 10:07 am
Only grant them access to the schema with the table in it - nothing else. At DB level they only need to be a member of the public role and...
February 24, 2011 at 5:28 am
sdffdfad faadffad (2/22/2011)
February 22, 2011 at 10:54 am
Viewing 15 posts - 31 through 45 (of 125 total)