Developer Newsgroups: SQL Server Tools

Taking control with SQL Stripes

Docco - 10 Feb 2007 7:28 PM - 1 message

Most DBAs today experience the lack of control over multiple SQL Servers, when required to perform a real-time monitoring. SQL Stripes is a console which helps you to easily manage an environment with multiple SQL Servers. You can easily ...

who or what is accessing my table?

jmelkerson - 9 Feb 2007 9:37 PM - 4 messages

I have a situation where records are mysteriously disappearing from a table. How can I monitor the table to discover who or what is accessing it or executing statements or stored procedures on it? I have tried SQL Profiler ...

Generate database ...

Gabriel - 9 Feb 2007 5:03 PM - 2 messages

Hello, Is there a way ( in SQL Server 2005) to generate the script to create : - database - all tables - constraints in a single action and not table by table ? Regards, ...

SS2005: Change query order in SQL Management Studio Solution Explorer

vimas - 9 Feb 2007 3:30 PM - 3 messages

Hello, Is there an easy way to change query order to alphabetic in Solution Explorer in Microsoft SQL Server Management Studio? I have a lot of SP in the list and they all are in order they were added to ...

SSIS on a separate box

SalamElias - 8 Feb 2007 7:52 PM - 3 messages

Hi, I don't know if this is the riht place formy question. I have a customer who wants to implement SQL 2005 Enterprise edition on a physic al w2k3 excpt SSIS which should be setup on another box for performance issues. Is there ...

Veritas and SSIS

KenZo - 8 Feb 2007 1:37 PM - 2 messages

How can I install SSIS for sql 2005 on a veritas cluster? What should be the impact on application? Thanks ...

Performance Monitor

Sean - 8 Feb 2007 1:38 AM - 2 messages

Using SQL Server 2000; how do I start Performance Monitor for a specific SQL Server? Currently, I have multiple servers including my local and each time Performance Monitor is started, it monitors the local SQL Server. What is the best way to monitor the SQL Server's performance and fine tune it? ...

Limit access in SQL Enterprise Manager?

Rich L - 7 Feb 2007 10:14 PM - 2 messages

We have SQL 2000 server. And our DBA clients connect to the various databases on their using SQL Enterprise Manager installed on each of their computers. For authentication to the databases they can connect by either Windows Authentication or SQL authentication inside of SQL Enterprise ...

Management Studio - "[" symbol

Rob Schieber - 7 Feb 2007 8:56 PM - 2 messages

Is there a way to disable the quoted identifiers "[" symbol from being used when Sql Server generates a script. Its driving me nuts right now. I know you could disable it in query analyzer. Thanks, ...

SQL SOX auditing and logging

SQL apprentice - 7 Feb 2007 5:15 PM - 4 messages

Hi, We are currently being audited for SOX compliance. The auditor wants us to create log that captures all the activities from the DBA in the SA role. Is there an easy way to generate logs for this audit that can be written to ...

kill long running (hung) SQL task

dsm4898 - 7 Feb 2007 4:16 PM - 2 messages

We have an SQL task that occasionally hangs. Is there a function to end a task if it has been running for a determined period of time? This feature is available in windows task scheduler, not SQL 2005? ...

SQL 2005 Profiler (SSE Install) and Insufficent Memory problems

Julie Lerman - 6 Feb 2007 2:39 PM - 1 message

(Posted this in setup by mistake - sorry for the cross post) I have been battling this problem for two days. I have SSE installed on a VPC. The VPC has 1.5 GB Ram allocated to it. I installed the Advanced Services also so that I could get SQL Profiler. ...

SQL Agent Roles

Michelle - 5 Feb 2007 9:37 PM - 3 messages

I have a domain account that is assigned the the SQLAgentOperator, SQLAgentReader, and SQLAgentUser roles. That domain account is able to create a job and delete the job. But, it is unable to edit the job. If I create a ...

Open SQL file using SQL 2005 Management Studio

Yong - 5 Feb 2007 8:42 PM - 3 messages

Everytime when I open .SQL file using SQL 2005 management Studio, it ask me about connection info. Is there any way to use the previous one like SQL 2000? For example, first time when I open .SQL file, I put connection info, ...