Developer Newsgroups: SQL Server Tools

Not Able to Edit SQL Data in Access

wenzlow9 - 2 Dec 2005 10:50 PM - 6 messages

Greetings. I am using SQL Server 2000 to store my data, Access XP 2002 SP-3 for the front-end, and MDAC 2.8 RTM. I cannot edit any of the data in the SQL tables from Access. I can enter new data, but once it ...

EnumErrorlogs using SQLDMO

MartinC - 2 Dec 2005 7:41 AM - 3 messages

I am wanting to use the EnumErrorlogs method of the SQLServer object to identify which of the error logs have been written to in a specified period. I also need to be able to deploy this to any of our SQL Servers which could ...

Interpreting the execution plan results

Kenny M. - 1 Dec 2005 6:48 PM - 2 messages

On Query Analyzer.. I can figure out a little what the information on the execution plan means but Iâ€™m not sure Where can I find a good description about each item that is show in the execution plan? ...

Error using Db Engine Tuning Advisor

Todd C - 1 Dec 2005 2:15 PM - 12 messages

I am running SQL 2005 Standard, obtained from a recent Launch event. I got the Database Engine Tuning Advisor to run only once. Everytime after that I get a runtime error: "R6031 Attempt to initialize the CRT more than once. This indicates a bug in your application." ...

Rich Text Editor Control for Desktop application

Pankaj Jain - 1 Dec 2005 10:32 AM - 1 message

Hi I need a free Rich Text Editor Control for my Desktop application.If source code is also provided then its cool Thanks Pankaj Jain ...

error msg 601

betty_it - 1 Dec 2005 2:32 AM - 3 messages

Hallo, I'm using SQL Server 2000. I've made solution: 1. Dbcc checktable (sysobjects) with no_infomsgs 2. And I'was also removing all hint "WITH (NOLOCK)" behind the INSERTED and DELETED tables Can anybody help me? ...

debug a stored procedure in SQL Server 2005

Jaime Lucci - 30 Nov 2005 3:43 PM - 8 messages

Hi everyone! How can I do to debug a Stored Procedure in SQL Server 2005 from SQL Server Management Studio? I looked for the Debug... option when I right-clicked the SP but it seems that in SQL Sever 2005 doesn't not exist. ...

Cant get SQL Server Mgmt Studio Express CTP to run..

Wade - 30 Nov 2005 12:43 PM - 1 message

A couple of weeks ago I installed VB Express 2005, SQL Express 2005, and SSMS Express CTP and all were running fine. Then one day last week I tried opening SSMS Express CTP and nothing happened...no startup screen...nothing. ...

Re: Sql Server Profile is not filtering

m.bohse - 30 Nov 2005 9:35 AM - 2 messages

Actually depending on the template you use some filters won't work. Especially filters on database name and /or objectname will only work for security auditing. In your case you should use a filter on the database ID. That will work. ...

connect via QA with windows auth without joining domain

dinosaur8000 - 30 Nov 2005 2:01 AM - 3 messages

Hi, I'm using my laptop to connect to a client's internal network. I'd like to connect to their SqlServer database using Query Analyzer, Enterprise Manager, osql, etc... They only have Windows Authentication enabled (they won't change this setting). ...

LogShipping Monitor Not Found in Enterprise Studio 2005

Tom Frost - 30 Nov 2005 12:05 AM - 1 message

I have the Management studio tools from SQL 2005 installed and have various SQL 2000 servers registered that have logshipping installed. I have been unable to locate the logshipping monitor location in the new toolset & to review the status of the logshipping processes. ...

Error when trying to access jobs within SQL Server Agent

rivast_2001 - 29 Nov 2005 10:00 PM - 1 message

I just installed Microsoft SQL Server Management Studio 2005 and after registering a SQL Server 2000 instance I tried to access the jobs within the SQL server Agent and I am getting the following error. The account I am using ...

Sql Server Profile is not filtering

aletita - 29 Nov 2005 9:32 PM - 2 messages

Hi Everybody, I'm new with Sql Profiler tool and I'm trying to trace a Stored Procedure to run the Index Tuning Wizard for it. The problem is that I used the SqlProfilerTuning template and I put filters like: DB name like mydb, ...

Enterprise Manager Server list

Jason Chen - 29 Nov 2005 3:30 PM - 1 message

Hi, I have just given a new machine. I am wondering is there a way that I can copy over the registered servers list over to the new machine. Thanks for help. ...

MSDE tools?

RobR - 28 Nov 2005 11:05 PM - 4 messages

I have SQL Server 2000 but discovered it doesn't install on Server 2003 Web Edition, so I installed MSDE 2000 revision A. Now I've googled up the wazoo, searched the SQL 2000 CD and searched the MS website but I can't figure out where ...

ANN: AGS SQL Server 2005 Utilities Update

GregO - 28 Nov 2005 10:33 PM - 1 message

A & G Software would like to announce an update to AGS SQL 2005 utilities. A set of must have utilities (SP and UDF) only for SQL 2005. Take advantage of the power of SQL 2005 SQL CLR integration right now. ...

Management Studio Express CTP Nov Question

bubix - 28 Nov 2005 8:31 PM - 2 messages

Hello, The release edition of this tool, it'll be free with SQL Server 2005 Express???? Thanks ...

SQL2005 Mgt of Log shipping in SQL 2000

burt_king - 28 Nov 2005 6:29 PM - 1 message

I have a SQL 2000 environment set up with log shipping. When I try to use the SQL 2005 tools to check the monitoring server it doesn't have the Log Shipping Monitor I have available in SQL 2000 enterprise manager. Am I ...

Upgrade Query Templates

Dejan Sarka - 27 Nov 2005 9:16 AM - 1 message

I can't find an easy way to upgrade QA 2000 query templates to SSMS 2005 templates. Am I missing something? ...