I have a bunch of servers on a different subnet. All of them connect within a second or so except one. A 64 bit 2008 enterprise version. Takes about...

Chuck

09-06-2011 06:36 AM
Alexey K

Great news for SQL Server people! Starting from today, SQL Complete add-in joins Devart’s High Five program. This means that each of you can get a...

óÅÒÇÅÊ ìÁÚÕÒÅÎËÏ

08-08-2011 10:19 AM
óÅÒÇÅÊ ìÁÚÕÒÅÎËÏ

Hi, Recently I was asked to reindex on one large database tables - there was a performance issue and we hope rebuild the indexes will help. I ran...

Bob

04-24-2011 09:25 AM
Erland Sommarskog

I need have SMTP or Microsoft Exchange server install on the same server to make SQL Email works. Am I right? If not, is it possible to configure to...

iccsi

04-20-2011 11:22 PM
iccsi

Hello all. Just wanted to let everyone know that our free stored proc generator Procgen.O has a new temporary home page. There have been several...

NumbLock

04-19-2011 05:45 PM
NumbLock

Hello all. Just wanted let you know about a new program I wrote to help with creating stored procedures. I had a table with lots of columns that I...

NumbLock

04-03-2011 06:49 AM
NumbLock

Hi all, we are in progress to configure a gateway terminal server for system managers RDP connection. On this host we want to install SQL 2008 R2...

marco_b_

03-02-2011 07:28 AM
marco_b_

How do you copy a table from one database to another database using SQL Server Management Studio Express for SQL Server 2005? I was able to do...

Parrot

02-21-2011 12:24 PM
mary jo lenzing

I don't know where to post this. But, can intermitent IP conflicts with the IP address of the SQL Server cause SQL Server Agent to corrupt the SQL...

Andy

11-21-2010 05:59 PM
Erland Sommarskog

Hi, is there a possibility to install just the management tools of SQL 2008 or 2008R2 on Windows7 32bit? My installation fails with both...

Herbert

09-16-2010 03:26 AM
Erland Sommarskog

What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft...

nntp@microsoft.com

09-11-2010 10:56 AM
nntp@microsoft.com

Hi frnds I want to know whether following thing is possible through query Parent Table ---------------- Pid | PField1 | PField2 | PField3 |...

chintu4uin@gmail.com

09-08-2010 11:05 AM
chintu4uin@gmail.com

i have windows 7 starter. i installesd to instances of SQL Server. I created in instance1 database DbA, filled by some data, made full backup and...

Aleks Kleyn

09-06-2010 08:18 PM
Aleks Kleyn

Hi! SQL Maestro Group announces the release of MS SQL PHP Generator 10.8, a GUI frontend that allows you to generate high-quality PHP scripts for...

SQL Maestro Team

08-26-2010 09:52 AM
SQL Maestro Team

Hi all, I have a problem scaling the y axis. I have a value axis and secondary axis and trying to compare two data. Now the thing I want the same...

Sam

08-19-2010 09:20 PM
Sam

When in SQL Server Management Studio, I can open Log file viewer to see the SQL Server Errorlog, SQL Agent Log, etc. This applies to the 2005, 2008...

Toni

08-18-2010 05:01 AM
Toni

Hi, I'm fairly new to SQL Server, but using version 2005 and I have SQL Server Management Studio. When I run a query, I can right click to display...

laredotornado@zipmail.com

08-07-2010 12:17 AM
Tom Cooper

Hello frnds need a help for the query where in I want to add / subtract QtyMfg or QtyUsed as as per TrnType "R" or "I" starting with OpnBal which is...

chintu4uin@gmail.com

08-03-2010 03:22 PM
Tom Cooper

I have a query that runs against a linked server (tables are in dBase). When I run a simple select statement against one of the tables, I get an...

Jerry Haynes

07-28-2010 10:41 PM
Gene Wirchenko

I have been tasked to manage a non-critical SQL Server 2005, which is a backend for multiple SharePoint instances. Using a free monitoring tool,...

J Justin

07-27-2010 12:57 PM
L Nifong

Does anyone know a free program that will repair coruppted sql databases (mdf files)? All I see on the net is paid ones. Thanks Dave

DCR

07-19-2010 11:37 PM
DCR

Hi, I'm running Windows 2003 R2 sp2 x64 Standard with SQL Server 2005 installed. I want to defrag the data volume but I'm getting the following...

Linn Kubler

07-19-2010 04:31 AM
Erland Sommarskog

I want to synchronize local version of SQL Server Database 2005 with that of remote version of SQL Server database 2005. Are there any tools...

S N

07-17-2010 09:10 AM
Erland Sommarskog

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: " Database Workbench 4.0.3...

Martijn Tonies

07-13-2010 10:03 AM
Martijn Tonies

In the windows perfmon I have created new counters. I did right mouse clicked on the graph and did save log results as to a network drive folder I...

SQL

07-08-2010 04:17 PM
SQL

Hello friends I need help for the below query. My table structure is as...

chintu4uin@gmail.com

07-07-2010 04:01 AM
chintu4uin@gmail.com

Trying to import a trace create with the sample TraceSampleDef script, and getting a bunch of the following errors: 07/02/10 10:58:22.138 ...

M Bourgon

07-02-2010 11:59 AM
M Bourgon

I have SQL Server 2005 Developer Edition running locally. I hope this is the right group for these questions because I now need SSMS2008 to connect...

Hillbilly

07-01-2010 08:58 PM
Hillbilly

I am trying to find a way to prgrammatically determine if Microsoft.AnalysisServices.Deployment.exe has been installed on a server. I need to first...

tko

07-01-2010 08:35 PM
tko

I have 2 reporting services servers. 1 with SSRS 2005 and another with SSRS 2008. When I go to IE 7 or IE 8 and try to print a report from SSRS 2005...

Rodrigo Marques

06-29-2010 12:49 PM
Rodrigo Marques

how to change the name of default schema from dbo to say test1, or else create another schema say test2 and assign all the user tables to...

S N

06-27-2010 04:30 PM
Erland Sommarskog

Hi, I have a SQL Server 2008 cluster showing the Activity Monitor "% Processor Time" chart under Overview grayed out, the other graphs are ok. Do...

piopicles

06-23-2010 10:13 PM
Jeffrey Williams

I'm creating a SQL Script to distribute to multiple clients. The script will contain Template Parameters for Database Name, log in, etc... The...

jreddy

06-22-2010 02:47 PM
jreddy

Hi, is there any way to control html from BIDS?

LuisP

06-21-2010 03:40 PM
LuisP

Windows 7 Home Premium SQL Server 2008 R2 Express I am trying to use the 32-bit wizard to transfer my Access data to a new SQL Server database. On...

Philip Mark Hunt

06-20-2010 08:42 AM
Paul Shapiro

Hi What good, but simple solutions are there for implementing version controll of all my SQL scripts? I currently use SSMS do handle all...

MRWildiac

06-16-2010 10:23 PM
Dan Guzman

A company I am consulting with has a Small Business subscription that includes SQL2008 Standard Small Business Edition. I have install the SQL Engine...

Thom

06-16-2010 05:08 PM
Erland Sommarskog

Hallo zusammen, haben einen SQL-Server 2005 Std SP2 auf einer W2K3-Server-Umgebung im Einsatz... Die Arbeitsplatzkomponenten mit dem SQL-Server...

H. Haas

06-16-2010 03:08 AM
H. Haas

I am using SQL Server 2005 Express and want to upsize large tables from MS Access to SQL Server. The upsizing wizard is skipping the large tables...

S N

06-15-2010 10:23 AM
Mary Chipman [MSFT]

With SQL 2000 our backup provider (EMC Legato) told each database to truncate the logs after a successfull backup. SQL 2008 doesn't seem to have...

sgrigg

06-10-2010 04:23 PM
Erland Sommarskog

I am trying to import data from Oracle using the Import/Export wizard (DTSwizard.exe). I can connect to the oracle database fine, but when I choose...

Jason Wilson

06-10-2010 11:59 AM
Jason Wilson

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: " Database Workbench 4.0.2...

Martijn Tonies

06-09-2010 07:47 AM
Martijn Tonies

are there a way to conver Crystal Report for vs 2008 reports to Microsoft reports 2010

Robertohh

06-07-2010 12:15 PM
Robertohh

We are trying to use BCP to import data from flat files into tables in a SQL 2008 database. Even though BCP is erroring out, it is still putting...

DanH

06-04-2010 05:48 PM
Erland Sommarskog

When I connect to my SSIS I can not see any of the stored packages. When I create a execute SSIS package job step I do see the packages. Anyone...

AKCodeRat

06-04-2010 01:35 PM
AKCodeRat

I have a WMI script that will add SQL Server Aliases (configured via client network utility or SQL Configuration Manager). It works perfect for...

cc

05-27-2010 05:24 PM
cc

Hello guys, does any know if there is a tool to automatically document MSSQL 2008 configuration's important elements to a HTML file ? thanks in...

Sven W.

05-20-2010 11:06 PM
Dan Guzman

Dear Microsoft: If you guys insist on having your applications create awful names for their databases give us a way to organize those into folders...

Jeff L.

05-20-2010 05:31 PM
Erland Sommarskog

Hello All, Evidently it has been too long.... I have been running Mngmt Studio 2005 on another computer for quite a while... I now have a new Win7...

MSUTech

05-17-2010 05:12 PM
Erland Sommarskog

Hello I can't install SQL Server Performance Dashboard on SQL Server 2005 x64. I have the message "Setup was interrupted before Microsoft SQL...

yuan

05-14-2010 05:30 PM
Carlos Augusto Alfonso