Viewing 15 posts - 286 through 300 (of 872 total)
yulichka (4/28/2009)
What is statistics, I see there is a folder under the table, what is the purpose of it? Thank you
April 28, 2009 at 7:02 am
Yeah, lots of free space there ... but keep in mind, a data file will grow to it's size for a reason. Shrinking usually only results in the file growing...
April 27, 2009 at 5:38 pm
Steve Jones - Editor (4/27/2009)
Are you sure there's free space in there? Perhaps there are temp objects preventing it from shrinking?
Good call, run this to verify:
USE [tempdb]
SELECT
[name]
,CONVERT(NUMERIC(10,2),ROUND(/128.,2))AS [Size]
,CONVERT(NUMERIC(10,2),ROUND(FILEPROPERTY([name],'SpaceUsed')/128.,2))AS [Used]
,CONVERT(NUMERIC(10,2),ROUND((-FILEPROPERTY([name],'SpaceUsed'))/128.,2))AS [Unused]
FROM...
April 27, 2009 at 2:16 pm
Mad dog, how big is the file? How much activity against tempdb? Sometimes a file won't shrink due to open transactions and will do so once it is idle. You...
April 27, 2009 at 1:58 pm
Never seen it, but peaked my curiosity ... found this on experts exchange:
Looks like thats Kerberos Authentication, you should turn the firewall off on the server.
Or take a look at...
April 16, 2009 at 9:13 am
INSERT INTO msdb.dbo.sysdtspackages
SELECT *
FROM OPENDATASOURCE('SQLNCLI','Data Source=ServerName;Integrated Security=SSPI').msdb.dbo.sysdtspackages
April 15, 2009 at 10:37 am
Yeah I've had to re-apply instacat.sql in the past before for 2005 to 2000 ... Hooray.
Well, no getting to that anytime soon, so I'll let ya know if that ends...
March 31, 2009 at 7:15 am
SQL Native Client is indeed installed. I attempted to download and install the x86 version and was given the error about "not supported for this operating system." Downloaded the x64...
March 31, 2009 at 6:48 am
Gift Peddie (3/26/2009)
You have not posted what you are using the opendatasource to connect to I also need to know what x64 operating system you are running.
I am attempting to...
March 26, 2009 at 8:45 am
Hate to keep bumping this topic, but still haven't found resolution.
March 26, 2009 at 7:19 am
Still haven't had much luck on this one ...
March 23, 2009 at 2:10 pm
MANU (3/20/2009)
Are you running it against sql 2000/2005 server instances?MJ
Yep. I remember having a similar issue with 2005 to 2000 in by where I had to re-apply instacat.sql (from 2000...
March 23, 2009 at 5:51 am
Well, if anyone is interested ... Resolution was that the the Task Scheduler was the problem. Being that a cluster install uses task scheduler to install on the other node(s)...
March 11, 2009 at 6:05 am
Be nice if life were that easy wouldn't it be?
Anyways, while on hold with Microsoft, found that the task scheduler service is not starting on the passive node. Talking to...
March 10, 2009 at 10:09 am
Well, on hold now with M$ ... My money is on something in regards to the 2000 uninstall and more than likely will be a very easy fix.
March 10, 2009 at 9:11 am
Viewing 15 posts - 286 through 300 (of 872 total)