Hi, We have a large number of Profiler trace rollover files, that have been generated by a server-side trace, but when loading the first file into...

Joe Pollock

03-30-2009 03:06 PM
Andrew J. Kelly

I have SQL Server 2008 Standard installed on my laptop. I also installed the 60-Day eval of VB.Net. The expiration of VB.Net has passed but now...

Erik Sampsell

03-28-2009 05:48 PM
Ekrem Önsoy

Upscene Productions has a "Secret Super Sale" on Database Workbench Pro, the database developer IDE. This is a 75% discount on the normal price,...

Martijn Tonies

03-25-2009 03:12 AM
Martijn Tonies

We are happy to announce that DbOctopus 1.0 is finally released! DbOctopus is a tool specialized for finding and editing data in Sql Server...

Dejan Grujic

03-23-2009 12:18 PM
Dejan Grujic

Upscene Productions has a "Secret Super Sale" on Database Workbench Pro, the database developer IDE. This is a 75% discount on the normal price,...

Martijn Tonies

03-23-2009 05:21 AM
Martijn Tonies

Good Afternoon Is it possible to set up a linked server in sqlsever2005 using a dot net provider driver? In particular can I link (linked...

David

03-20-2009 06:19 PM
Erland Sommarskog

Good after noon I've succesfully used a scaler valued function in a update query ie UPDATE ProductItemDH SET...

David Hills

03-20-2009 08:19 AM
David

Hi When I start SQL Management Studio 2005 SP3 the following message comes up. Could not load file or assembly 'EnvDTE, Version=8.0.0.0,...

Greg

03-19-2009 01:03 PM
Geoff N. Hiten

Interesting, We didn't do any table changes. But if you just do a select with 5 column name 3 of them will be squiggled. Our cache is probably...

Chuck P

03-18-2009 05:50 PM
Erland Sommarskog

In SQL Server 2005 Management Studio, the Connect to Server dialog has a combobox for "Server name" that remembers any servers I have ever connected...

Jack Jackson

03-18-2009 04:53 PM
Jack Jackson

I am using the management studio tool that came with SQL server 2008 Express Edition. Problem is the relationship button is greyed out on the...

jpBless

03-18-2009 09:10 AM
Itamar

I have a request to run Statistics on a DB/Schema. This will improve response time and query performance for a clients data. I have never done this....

rogv

03-17-2009 02:00 PM
rogv

Thank you -- Charles Allen, MVP "Ekrem Önsoy" wrote:

Charles Allen

03-11-2009 06:07 PM
Erland Sommarskog

We've recently released SQL Image Viewer 2.2.0.110, a tool for retrieving, viewing, transforming and exporting images stored in your SQL...

Ray Mond

03-10-2009 10:06 PM
Ray Mond

We have a maintenance plan on SQL Server 2005 that we would like to show the execution time of each query in the log file like it was setup in SQL...

DenBro

03-10-2009 04:21 PM
DenBro

DBTYP.NET 2009 Studio besides Database Schema Comaprison and Database Data Comparison includes in the latest version Database Dependency Lookup for...

03-08-2009 07:27 AM

In SQL Server 08, the 'Execute SQL' ability is grayed out in the Query designer. I don't see how it could be permisions because if I right click on...

enipla

03-06-2009 04:01 PM
enipla

SQL profiler can report the event of SQL:StmtStarting and SQL:StmtCompleted. There is an event for Exec Prepared SQL. This is the prepared version...

Dan Holmes

03-04-2009 08:03 PM
Andrew J. Kelly

Windows Server 2003 x64 Enterprise Edition SQL Server 2005 Developer Edition Why would SSMS run locally not see a local sql server instance , when...

John A Grandy

03-04-2009 07:08 PM
Aaron Bertrand [SQL Server MVP]

Hello, We have a maintenance plan with several tasks. The logging have Log extended information checked. The maintenance seems to be performing...

Carmen

03-03-2009 09:47 PM
Jeffrey Williams

Hi All, I've just released a (sort-of) beta version of a tool I've been working on - it's free, and can be found here -...

Will

03-03-2009 07:27 PM
Will

Is it possible to connect sql server 2008 server from sql express 2005 ?

kumar

03-03-2009 05:21 AM
kumar

We are going to import data from sql 2005 to a new database (not SQL server). Does anyone know how I extract attachements (word/pdf etc) stored in a...

Ivo

03-03-2009 12:21 AM
Mohit K. Gupta

SQL 2k sp4 Is there any way to retrieve a forgotten password for a SQL Login account? Thanks in advance, Andre

Andre

03-02-2009 07:27 PM
Aaron Bertrand [SQL Server MVP]

Dear Newsgroup Readers, On my development machine: database_size = 17.4 Mb unallocated_space = 1.9 Mb data + index_size tables = 16.2 Mb So the...

galien8@zonnet.nl

02-28-2009 07:55 PM
Erland Sommarskog

Hello, Not sure if this is the correct forum, however; I am looking for any help or tool to assist in designing a new schema. I have been tasked to...

Hulicat

02-28-2009 10:02 AM
Hulicat

Hello All, We got a new product we've recently launched, it's a query tool and its still in beta, and we're giving it for free to...

Itamar, Nobhill Software

02-25-2009 03:47 PM
Itamar, Nobhill Software

Thanks for your answers both of you. Ekrem, I suppose this version is not for free, am I right? I knew I can see the logs opening them manually,...

isogulaleb

02-25-2009 08:57 AM
isogulaleb

I think this is due to my lack of understanding, but I need help. I have created an SSIS package that will export the rows from a view to a text...

j0hnj0hn

02-24-2009 07:25 PM
Pat M - City of Reno

I would like to apply the SQL Server 2005 Profiler and Database Tuning Advisor to server SQL Server 2000 databases. Will I have a problem using...

Joe K.

02-24-2009 12:51 PM
John A. Consulting Services

Hi I just upgraded my Vista Business to Ultimate and managed to break a working install of SQL Server 2008 in the process. Now when I open SSMS I...

Tim P

02-22-2009 02:06 PM
Tim P

Hi, We've released beta version of our first SQL Server tool. I would be grateful to anyone who can help beta test it. It's a tool specialized for...

Dejan Grujic

02-21-2009 07:48 AM
Dejan Grujic

Please see Bill Ramos' blog post for more information: http://adjix.com/t9t4

Aaron Bertrand [SQL Server MVP]

02-20-2009 01:11 PM
Ekrem Önsoy

I'm trying to use sql 2008 and have a report where i have a textbox inside of a tablix. i'm using a calculated field to create my http url. When i...

jvcoach23

02-19-2009 04:43 PM
jvcoach23

Dear All, My client is requesting to have a visual differentiation of Prod / non Prod environment in SQL Server Management Studio 2005 (SSMS) used...

Stefan[www.itsconsulting.fr]

02-18-2009 05:28 PM
Aaron Bertrand [SQL Server MVP]

Hi Ed, Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han. I am glad to work with you on this issue. From your description,...

Ed White

02-17-2009 01:02 PM
William Vaughn \(MVP\)

SQL Server Management Studio documentation instructions: To replace template parameters On the Query menu click Specify Values for Template...

Izorich

02-13-2009 05:55 AM
Robbie Meng

SQL Server Management Studio documentation instructions: To replace template parameters On the Query menu click Specify Values for Template...

Izorich

02-13-2009 05:55 AM
Robbie Meng

SQL Server Management Studio documentation instructions: To replace template parameters On the Query menu click Specify Values for Template...

Izorich

02-13-2009 05:32 AM
Robbie Meng

Hello, I currently have SQL Enterprise Manager and Query Analyzer tools installed on my machine for which I use to administer SQL 2000 based...

spremji via SQLMonster.com

02-12-2009 12:32 PM
spremji via SQLMonster.com

I think this is due to my lack of understanding of the process. I created an SSIS package that will export rows from the database to a file on...

j0hnj0hn

02-11-2009 02:31 PM
j0hnj0hn

Hello and thank you in advance for any help! The error message was thrown because a CHAR(10) field was moved to a CHAR(2) field and finally an...

John the ScrubMaster

02-10-2009 05:57 PM
John the ScrubMaster

All, We need to run some performance testing on a SQL Cluster to determine the best HBA Queue Depth. We are going to use the SQLIOSim tool. I am...

Marcy Daeffler

02-10-2009 11:07 AM
Marcy Daeffler

Hi , I had SQL 2005 Standard edition installed in Windows Server 2003 SP2. SQL Server Agent is not available SQL Server Management Studio 2005...

Ganesh

02-09-2009 07:41 PM
Aaron Bertrand [SQL Server MVP]

we have brought up a new db machine and moved all of our sql agent jobs to the new machine. We have several console apps that run from another...

dgator

02-09-2009 07:07 PM
Dave Patrick

No, there is no such functionality. On 2/24/09 8:31 AM, in article efXZG#FiJHA.760 (AT) TK2MSFTNGP03 (DOT) phx.gbl, "Oriane" <oriane (AT) noemail...

Aaron Bertrand [SQL Server MVP]

02-09-2009 04:35 AM
Ekrem Önsoy

I have several SQL 2005 servers all in domain environment most using sql and windows authentication. I also have a couple of SQL and Analysis...

Dave Patrick

02-08-2009 04:05 PM
Sylvain Lafontaine

I have inherited SQL Server 2005 database with several tables without primary keys. Should I add auto increment column to uniquely identify the...

Joe K.

02-04-2009 05:39 PM
Hugo Kornelis

Hi, I was also having the same problem in SQL Profiler 2000. I just tried replacing profiler.exe with the profiler.exe in the SQL SERVER 2000 setup...

Syed Mujtaba Ahmed Razvi

02-03-2009 04:29 AM
Syed Mujtaba Ahmed Razvi

Hi, I have a database with over 200 tables and I'd like a version of the diagram to be available without the relationships being shown (but still...

Suchafunkymonkey

02-02-2009 05:45 PM
Erland Sommarskog