Viewing 15 posts - 1,426 through 1,440 (of 1,583 total)
Sorry Sean, you had posted your reply while I was typing in mine, didn't mean to duplicate the effort! 😉
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 23, 2011 at 12:47 pm
Can you do something simple like this or am I missing the boat on this one?
CREATE TABLE #temp (OrderBy varchar(1), OrderDate datetime, OrderCity varchar(15))
GO
INSERT INTO #temp (OrderBy ,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 23, 2011 at 12:45 pm
That's a great point...I've come across this many times in our environment. Quite often we'll have an index that was created ages ago for a report that's no longer...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 22, 2011 at 6:58 am
I still receive the same error. From my research it would appear that by design MSSQL doesn't allow nested transactions across servers. Not 100% certain that's what I...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 20, 2011 at 3:30 pm
Yes, they are all set up exactly the same (only differences are hardware).
I checked out the artilcle and will see if that helps, appreciate the input...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 20, 2011 at 11:13 am
Are you running 32 or 64 bit?
We create a system-level ODBC on the server (using the appropriate driver of course - in our case it's the DATADIRECT 4.0 32-bit...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 20, 2011 at 8:46 am
If you have space available on the server you're performing this on, sometimes it's easier to simply create a new table, select the data that you want to keep into...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 19, 2011 at 2:26 pm
Well said Masakatsu!!!
The first line of code starts with coffee. The last line ends with alcohol...
😉
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 19, 2011 at 11:30 am
?
It will accomplish exactly what you're asking for:
1. send yourself an alert as to how much is free and (how much is used on each drive - Max space -...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 14, 2011 at 5:12 pm
Thanks, I'll have to check that...
I found an article on an MSDN blog that said something along the lines of the mySQL DLL receives a PAGE ACCESS VIOLATION and craps...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 14, 2011 at 5:06 pm
Check with your IT / Tech Services department to make sure there's been no recent changes to the Exchange Server (assuming your company uses that), there's this nifty little setting...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 13, 2011 at 10:21 am
Did you ever get a reply on this or find a solution?
I am experiencing a similar problem. We have a report that selects from an OPENQUERY to a mySQL...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 13, 2011 at 7:47 am
This is kind of crude code but works well and will email you every few minutes depending on how you schedule the Agent job. Create a job with this...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 12, 2011 at 3:19 pm
DECLARE @Param1 varchar(50)
SET @Param1 = (SELECT ReportName from #MyTable WHERE This = That)
EXEC MyStoredProc @Param1
?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 8, 2011 at 10:01 am
Did you ever get a fix for this? When attempting to do a similar thing I get the exact same error (on a 32-bit system)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 6, 2011 at 10:39 am
Viewing 15 posts - 1,426 through 1,440 (of 1,583 total)