How can I combine two data files (i.e .mdf and .ndf). We had two data file in our old server due to disk limitation. In the new server we don't have such limitation so we like to consolidate the two file in one. What is the best way to accomplish that?
ThanksFollow this:
http://groups.google.com.au/group/microsoft.public.sqlserver.server/browse_thread/thread/d7fa8af9c5ca5ca/71636c29fdf2666c%2371636c29fdf2666csqlsql
Showing posts with label limitation. Show all posts
Showing posts with label limitation. Show all posts
Thursday, March 29, 2012
Sunday, March 11, 2012
connection.exec
Does any body know if the connection.exec has a size limitation. I am sendin
g
30k of text through connection.exec and I get rusults but if I send 50k it
does not work. It's almost as if the connection.exec can't handle the extra
20k. Any help would be great I have a production app down.I figured it out, I was using the datashape and that is what was breaking it
.
I removed it and it works great.
"DAVID S" wrote:
> Does any body know if the connection.exec has a size limitation. I am send
ing
> 30k of text through connection.exec and I get rusults but if I send 50k it
> does not work. It's almost as if the connection.exec can't handle the extr
a
> 20k. Any help would be great I have a production app down.
g
30k of text through connection.exec and I get rusults but if I send 50k it
does not work. It's almost as if the connection.exec can't handle the extra
20k. Any help would be great I have a production app down.I figured it out, I was using the datashape and that is what was breaking it
.
I removed it and it works great.
"DAVID S" wrote:
> Does any body know if the connection.exec has a size limitation. I am send
ing
> 30k of text through connection.exec and I get rusults but if I send 50k it
> does not work. It's almost as if the connection.exec can't handle the extr
a
> 20k. Any help would be great I have a production app down.
Subscribe to:
Posts (Atom)