Viewing 15 posts - 826 through 840 (of 1,583 total)
Have you tried to set the "Use 32-bit runtime" under the job step's Execution Options?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 22, 2013 at 9:15 pm
This article may help
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 22, 2013 at 9:11 pm
Crude, but this will work, just loop through a directory (if you are able to execute xp_cmdshell, if not I'm sure there's a powershell script lingering around)DECLARE
...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 22, 2013 at 9:05 pm
IMHO it's used mostly to save time when writing the code. It's like saying INSERT this set of data...and also this, oh wait, here's a few more rows to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 22, 2013 at 8:53 pm
I know this is an assumption, but the 'sa' account you are using to connect via the credentials...it is the actual "sa" account and it is a member of the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 22, 2013 at 8:43 pm
When you right click and view the DB size it includes the log file and is a rounded number (which you know). The space shown in the properties tab...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 22, 2013 at 12:40 pm
It's a good rule of thumb to place it on multiple drives (especially in RAID configuration). Have you taken steps to monitor your tempdb usage and do you have...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 22, 2013 at 9:31 am
You are absolutely correct (my bad) :w00t:
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 21, 2013 at 7:56 am
SQLRNNR (1/18/2013)
If the drive where the first log file was created is out of space, I would...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 20, 2013 at 5:21 pm
Here is some code to determine which file group your tables exist on:
SELECT o. [name], o .[type], f .[name],f.data_space_id
FROM sys.indexes i
INNER JOIN sys.filegroups f
ON i. data_space_id = f .data_space_id
INNER JOIN...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 20, 2013 at 5:18 pm
Jeff Moden (1/18/2013)
INSERT INTO #BreakDownByCategoriesEXEC dbo.exec spGetCategoriesByDocIDAsTable @DocID
I believe an accidental typo?
INSERT INTO #BreakDownByCategories
EXEC dbo.spGetCategoriesByDocIDAsTable @DocID
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 18, 2013 at 2:45 pm
Index Id 2 should relate to a non-clustered index, simply drop and recreate the index and you should resolve the issue. After that run a DBCC CHECKTABLE('YouTable') WITH...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 18, 2013 at 2:17 pm
There's probably a much better/efficient way to do this but here's a simple example you can modify to suit your needs - FYI the U NION ALL is on purpose...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 18, 2013 at 9:39 am
I'm going through a similar situation - check out my thread - http://www.sqlservercentral.com/Forums/Topic1407363-1550-1.aspx#bm1408963
In your situation, what do you mean by "root" directory? if there's just user DBs on the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 18, 2013 at 9:13 am
Gail, new piece of information here: turns out the SQL Server binaries are not installed on this drive, but some of the typical folders are there:
D:\SQL\MSSQL10.MSSQLSERVER\MSSQL
>>...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 18, 2013 at 9:08 am
Viewing 15 posts - 826 through 840 (of 1,583 total)