The number of output characters displayed in the SSMS results window (grid or text) is configurable (see attached image).

Max is 64K for row data, and unlimited for XML. If...

Bumping this thread.

The error message listed below seems to suggest the target database is not available.

You could check to see whether the default database assigned to 'appvbdba' is still available.

If...

Here you go...

Select ((DATEDIFF(day,b.startDate,b.Endadate) +1) - (DATEDIFF(wk,b.StartDate,b.Endadate)*2)

- (CASE WHen DATENAME(dw,b.startdate)='SUNDAY' THen 1 else 0 end)

- (CASE when DATENAME(dw,b.endadate)='SATURDAY' then 1 else 0 end)) * 24

from Balla b where Proj_ID=123;

What is the error you are receiving?

When I run the query against the data set provided, the result is 61, and I'm able to multiply it by 24 without any...

It depends on the features used within the DB you are moving. If EE only features are in use, you won't be able to migrate the database to SE...

This is possible a couple of different ways, but a couple of quick questions first...

Is it possible to have more than one appid equal to the max or min...

Hello,

To determine growth rate of a single table, you'd have to setup a process to collect some history about the space used by the table. The rate would depend...

Traffic to the session database has been averaging 300 simultaneous connections, but has gotten as high as 1500.

Piggy backing off of the original note...

Are there capacity planning guides available for the ASP.Net Session database?

I'm specifically looking at how to size the data and transaction log files for...

Thanks Jack and Adam! I'll keep my eyes opened for the next event, and if all is well at the office, I'll be sure to make it.

For the last two years I was fortunate enough to attend TechEd, but I think these types of events / trips are going to be few and far between for...

There should'nt be any additional steps, just make sure you change the name of the destination database before you perform the restore.

Rusty

Try this...  This what we have done in the past to fix this issue.

1. Uninstall NMSQL V3.1 using NMSQL V3.1

2. Install NMSQL V3.0.1.

What patch level has been applied to SQL Server?