happening for me too

think this just maybe one of them things with RC0

do you want to run the full string including the CREATE PROC, or just the contents of the proc

EG EXEC ProcName or CREATE PROC ProcName.....

Also you have only provided one...

I'll agree with all of the above, you cannot do this via the SSMS GUI, the options you have are to create the procedures from the scripts, put them in...

please provide your DDL scripts so that we can assit you better.

how do you mean you want to do this through SSMS?

the scripts Gianluca provided can be compiled and run through SSMS or set in a job to run on a...

From the documentation

How to Calculate Processor Licenses for a Single VM

If your Virtual host IS NOT hyperthreaded

# of Virtual Processors assigned to the VM / # Cores in the...

do a full backup on a weekend, differentials every day except your full backup day, tx logs every X mins/hours

E.G

Sat, Sun, Mon, Tue, Wed, Thurs, Fri

Full, Diff, Diff, Diff, Diff,...

Roy, can you detail why you would put your SQL servers in the DMZ, as I too, would consider this as a massive security issue.

Typically the DMZ is outside of...

you could try this to find out whats still on the filegroup

SELECT

o.[name] AS ObjectName,

o.[type] AS ObjectType,

s.[name] AS SchemaName,

f.[name] AS [Filename],

i.[name] AS PrimaryKey,

i.[index_id] AS IndexID

FROM

sys.indexes i

INNER JOIN...

is the data in the table encrypted so when you do

SELECT col FROM table

Col is returned in an encrypted state?

If so it looks like the insert done by the...

It would seem that your connection pool isn't clearing out dead/idle connections, or something spawned to many concurrent connections and the limit was reached.

Wasn't any changes to the app yesterday...

can you post your full error log

also MS say they have resolved the bug in this hot fix http://support.microsoft.com/kb/2543687 after a did a google search.

only other time i have seen this is when the server was rebooting due to automatic updates.

did your server reboot last night?

have you checked the SQL Server Configuration Manager on the server?

under SQL Server Network Configuration, Protocols for ~INSTANCENAME~ (named instance), or Protocols for MSSQLSERVER (default instance), check that Named Pipes...

If its running on a server I would always run a server OS, if your running it on a desktop for DEV reasons then either or.

If its a production server,...