Viewing 15 posts - 6,001 through 6,015 (of 19,564 total)
Well, did you integrate the FILEPROPERTY function like Jack Corbett recommended on the other thread?
http://www.sqlservercentral.com/Forums/Topic1327652-391-1.aspx
July 10, 2012 at 3:44 pm
Once again, starting a new thread does not help much at all.
Please redirect replies to the initial thread
http://www.sqlservercentral.com/Forums/Topic1327819-391-1.aspx
July 10, 2012 at 3:41 pm
Jeff Moden (7/10/2012)
SQLRNNR (7/10/2012)
Jeff Moden (7/10/2012)
XMLSQLNinja (7/10/2012)
To get the number in MB:value * 8 / 1024
Example:
Selectname,
size*8/1024
from sys.master_files
Just divide by 124.
Should be 128
Wow... talk about phat phingering. Thanks...
July 10, 2012 at 3:40 pm
Danzz (7/10/2012)
I dont get any info from ' Select * from sys.master_files '.Help please!
Do you get an error?
July 10, 2012 at 3:40 pm
Danzz (7/10/2012)
I need Available Free Space on of .mdf, .ndf, .ldf on whole instance addinf to existing script.
You have been given enough info to find that info now. This...
July 10, 2012 at 3:31 pm
Jeff Moden (7/10/2012)
XMLSQLNinja (7/10/2012)
To get the number in MB:value * 8 / 1024
Example:
Selectname,
size*8/1024
from sys.master_files
Just divide by 124.
Should be 128
July 10, 2012 at 3:30 pm
Here's a query to show column level collations
Select t.name as TableName, c.name as ColumnName, ty.name as DataType, c.max_length
,'('+ convert(varchar,c.precision) +','+ convert(varchar,c.scale)+')' as Precision_Scale
,d.definition as DefaultConstraint
,c.collation_name
From sys.tables t
Inner Join sys.columns c
on...
July 10, 2012 at 3:19 pm
SSIS
bulk copy
redgate data compare
July 10, 2012 at 3:17 pm
XMLSQLNinja (7/10/2012)
July 10, 2012 at 2:52 pm
I'm with Jack. If most of the reports are going to be 2008 R2 based, use BIDS from 2008 R2 and develop your SSRS reports from there.
July 10, 2012 at 1:46 pm
You can have 1 connection manager and have a variable to overwrite the server expression for that connection manager. But only 1 at a time.
A better description of what...
July 10, 2012 at 1:41 pm
Lynn Pettis (7/10/2012)
July 10, 2012 at 1:31 pm
responses are being fragmented
Post further responses here
http://www.sqlservercentral.com/Forums/Topic1327652-391-1.aspx
July 10, 2012 at 1:30 pm
Viewing 15 posts - 6,001 through 6,015 (of 19,564 total)