You can check a result set of the last time all statistics in a database by querying sys.stats with the STATS_DATE() function. And instead of using sp_msforeachtable why not just...

For what it's worth, at least for me, the light bulb really comes on with XML and it's much easier to understand when you actually practice with it. Just my...

One way would be to just create a view and union the sum total to the bottom. Unfortunately I don't think you can utilize ROLLUP, as you aren't really...

Fun question, definitely have to read ALL of the answers. Thanks! 🙂

If I'm understanding your question correctly, you can do this directly within SSMS:

1. Right-click on your database in Object Explorer

2. Click on Tasks -> Generate Scripts...

3. Keep "Script entire database...

🙂 I figured as much. Glad you got it all worked out. In the future, to see if the necessary ports...

That list in the KB article opens...

Sounds like it could possibly be a DNS issue. What happens when you try to connect using the IP address as opposed to the server name?

Is port 1434 (UDP) open on the firewall? That's the port that the SQL Server...

dbalorenzini (6/12/2012)

---

OH and one more thing. When you are in studio manager and you are going to connect to the server by using the Server drop down list and if...

There are a few things to check. Have you enabled the TCP/IP protocol for the instance? For a thorough walkthrough of possible issues, check out this blog post...

If you want the database user to be able to have SELECT permissions, then they will still need to be a member of the db_datareader role. db_datawriter is not...

Is that port (5024) blocked?

It sounds like this could be a good usage of SQLCLR[/url].

And you are sure that your design is solid with having the data-layer call a web service?

Out of curiousity, what does the following return?

select @@max_connections as max_connections;

And you say CPU isn't high. Is that the overall "_Total" CPU? If so, you could be skewing...