Server Configuration

Assembly Re-distribution
I have an app that currently relies on a number of SQL Server assemblies. These are currently referenced and included in the bin folder of the app when shipped. I understand that there are some limits on the SQL Server assemblies that may be shipped vs ones that are installed via a re-distributable installe... 2 Feb 2010 17:35

Date
Hi. I want to to know the date of the day Monday of the current weak. Suppose if today is 31 Jan 2010. It return the date of Monday as 25 Jan 2010. Regards, Muhammad Bilal ... 2 Feb 2010 17:35

Smo and SQLCMD commands
Hello, I want to run a script with the ExecuteNonQuery method of a Microsoft.SqlServer.Management.Common.ServerConnection instance It seems that this method doesn't accept the SQLCMD commands like :SetVar How can I run this kind of scripts from within a .NET program ? Thanks for your suggestions. -- ... 2 Feb 2010 17:35

Resultset Format
Hi. I have a table with column. Erpno Monday Tuesday 10001 01,101,66 055,109,303 I want the upper table values in the following format. Erpno Code Weakday Date 10001 1 Monday 25/01/2010 10001 101 Monday 25/01/2010 10001 66 Monday 25/01/2010 10001 055 Tuesday 26/01/2010 10001 10... 2 Feb 2010 17:35

Can't connect with Report Builder 3.0
I can't connect to local reporting service on SQL Express 2008 (Microsoft SQL Server 2008 (RTM) - 10.0.1600.22) with ReportBuilder 3. Works fine with version 2. Am I missing something? Pete --- frmsrcurl: http://msgroups.net/microsoft.public.sqlserver.server/ ... 2 Feb 2010 17:35

Viso and mapping SQL Servers
I've been asked by a manager to create a "visio of our sql environment." I don't exactly understand what is meant, and I can't ask for anymore clarification as of right now. Can someone point me into a direction to get started? We have 5 MSSQL servers running on different machines. ... 2 Feb 2010 17:35

SQL2008 Color Connections property
Hi, We have a solitary SQL2008 Enterprise Server and we thought that changing the connection color would help to distinguish between production and other levels of servers would help. The server is running SP1 CU6 build 2757 and this is what we see. If we define an SQL2005 server under the Local Server Gro... 2 Feb 2010 17:35

Can't Restore Database to New Server
Thanks 4 the Nice Work! From http://www.developmentnow.com/g/118_2009_7_0_0_627483/Cant-Restore-Database-to-New-Server.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com/g/ ... 2 Feb 2010 17:35

Percentage query
tblid name ordered_bit 1 A 1 2 A 0 3 A 1 4 A 0 desired result: name ordered_bit A 50 /*50 is the percentage (2/4)*/ ... 2 Feb 2010 17:35

Upgrade MS SQL 2000 Cluster to SP4
I'm having trouble making sense out of the ReadMe documentation for Applying SP4 to a failover cluster. Are all of the sql and cluster services to remain up when applying the patch? Does it install to both nodes? ... 28 Jan 2010 04:15