Thank you for ur reply

What is sys.fn_get_folder? Is it system Function ? Which version?

Still I am not able to send a mail.Please give me s solution.

Hi My question is i want move data from production server to testing server.I want take transfer the data in source to destination in all the 50 tables.But one condition...

Thank You

HI Still i am not getting answer.One small changes I use only one table,that table i store a values like a

registerno

101

102

103

104

105

106

107

109

110

120

121

122

123

124

125

127

129

130

I want following result like following manner

101-107,109-110,120-125,127,129-130

Please help me

Please give me a example

Thank You

Thank U for reply

My requirement like that.

26*26*26 is enough for me.please help me

Hi thank u for ur reply

How to open the port in sqlconfig manager ? which port i should...

sqlserver services started

how to release named instance firewall block? what are all the ports should be open?

Hi I am getting following result .But Disk space not yet reduced.please help me

DbId FileId CurrentSize MinimumSize ...

whenever i am executing following query i am getting following result.how to reduce the space

select name, type_desc, size/128 'Size(MB)', FILEPROPERTY(name, 'SpaceUsed') / 128 'SpaceUsed(MB)'

from sys.database_files

name ...

Hi Thank u for your reply..

All the threee databases i am using same server only.I am using sqlserver authentication.

Database read...

whenever i am given this query that time i got a result set of table name. but i am searching select * from tablename that time i am facing following...

No i got a result set of this query. But i am not find that original table.