Server Configuration

Where to run script to create database including tables and storeprocedures?
You can use the SQLCMD utility: http://msdn.microsoft.com/en-us/library/ms180944.aspx -- Plamen Ratchev http://www.SQLStudio.com ... 6 Apr 2010 10:49

Where to run script to create database including tables and store procedures?
I downloaded SQL 2008 express and install database without management studiio. Where to run script to create database including tables and store procedures? -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/201004/1 ... 7 Apr 2010 04:37

What is File = 1
Hi, In my SQL Server 2008, I tried to restore some db. I searfed the internet and found some command like Restore MyDB FROM DISK = 'C:\BackUp\.bak' WITH file=1, RECOVERY I am wondering what the 'file = 1 is. Thanks for help. Jason ... 6 Apr 2010 05:19

Changing compatibility
When you change the compatibility level of a database, does it check to see if all the objects are compatible at that point or only when you start using it. For example, if you have a non-ansi join, which is not compatible in 2008, will it tell you automatically that you have a problem or will it wait until ... 6 Apr 2010 02:06

SQL Azure Forum on MSDN
Check out the SQL Azure ? Getting Started forum at http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/threads. (SSDS is an abbreviation for SQL Server Data Services, an earlier Entity-Attribute-Value version of SQL Azure.) Lilian wrote: SQL Azure discussion group? 01-Apr-10 Hi, I cannot seem... 26 Apr 2010 06:58

Primary Key names. (with random ?? numbers in them).
Dear reader, For primairy key names I was (and still am) used to names like : 1. PK_<table_name> Now I have a database which has primairy keys with double underscores and names like : 2. PK__<table_name>__<number> There are two underscores and a large number. When scripting (database or table): The na... 8 Apr 2010 09:30

SQL 2008 - What happened to the "Show ... Pane"
I installed SQL 2008 and couldn't find the Show Diagram pane, Show Criteria pane, etc. Is that not available in 2008? If not, why would something like that be taken away? It makes it much more time consuming to throw together ad hoc queries. ... 3 Apr 2010 05:02

Issues related to scripting a SQL Server job
Hi, I recently created a SQL Server (2008) job "X" and scheduled to run everyday 10:00 AM. The following week I created another SQL Server job "Y" by scripting out job "X" and scheduled it to run one time only on Friday 11:00 PM. On Monday I happened to look at the Job Activity monitor and was suprised to s... 1 Apr 2010 21:22

Security Update KB970895 for SLQ Server 2005 SP2 fails to install
Hi, I am having trouble installing Security Update KB970895 for SLQ Server 2005 SP2. It fails to install and out an error core 1603 in the application log from source MsiInstaller. It also gives an error 10005 saying that the previous upgrade did not complete. I followed the instructions to complete the p... 2 Apr 2010 06:02

SQL Server 2005 - Can Not See Server/Service Status in SSMS
We recently moved an existing server which runs a SQL Server 2005 instance to a network located behind a firewall. Prior to moving the server behind the new firewall, I was able to Start/Stop/Pause/etc the SQL Server engine and Agent from my local machine using SQL Server Management Studio. Since the move though, t... 1 Apr 2010 12:24