Developer Newsgroups: SQL Server Tools

Reporting Services Erro

samoore33 - 16 Jun 2006 3:23 PM - 1 message

Query execution failed for data set 'driverplanning'. (rsErrorExecutingCommand) Get Online Help Grantor does not have GRANT permission. I have never seen an error like this. It is saying that I need to grant permission on the dataset that I am using in Reporting Services. ...

SQL Agent keeps failing

Adrian Ciuca - 16 Jun 2006 10:03 AM - 10 messages

My sql agent keeps failin with the following error: Message [298] SQLServer Error: 2812, Could not find stored procedure 'msdb.dbo.xp_sqlagent_notify'. [SQLSTATE 42000] (DisableAgentXPs) I mention that I have imported by detach - atach databases from sql 2000 to sql 2005 standard ed and made some maintenance plans (created in sql2005) to ...

SQLCMD error -100

harris_da - 16 Jun 2006 3:48 AM - 9 messages

I'm trying to execute a script but it will not execute the following combination: IF EXISTS (SELECT * FROM master.sys.databases WHERE [name] = @Database) I can have anything else, but never a statement that begins with [:]. I've already tried installing MSSQL 2005 SP1 with no success. I've ...

Msg 15404

Richard - 16 Jun 2006 1:04 AM - 2 messages

Can someone tell me specifically what the following error means, and then, if there's more to it, what some of the possibilities are for this error when executing a SQL command, such as "xp_logininfo [mydomain\myusername]" from Query Analyzer? That command works on some SQL Servers, and not on ...

Results Pane in Query Designer in Management Studio

The Seeker - 15 Jun 2006 8:43 PM - 3 messages

Hello, I'm running SQL 2005 SP1 with the latest hotfix rollup, and I'm struggling with the new Query Designer in the Management Studio. The functionality that I'm looking for is the ability to quickly query a table and produce a results pane that will allow me to quickly edit or delete ...

Relationships problem in Enterprise Manager

Edward Diener - 15 Jun 2006 6:20 PM - 3 messages

I am using Enterprise Manager for Sql Server 2000. In designing a foreign key relationship for a table, let's call it table A, I have more then one column acting as a foreign key for the same primary column in ...

How To Pick Winning Stocks

info - 15 Jun 2006 8:25 AM - 1 message

To pick winning stocks, you need the tools to separate the companies with superior sales and profit growth from the ones who are just making a lot of noise. Besides choosing the right companies to invest in, you must learn how to read the market's trend so that your timing ...

2005 query designer yellow/green in margin

DWalker - 14 Jun 2006 10:31 PM - 7 messages

When I type stuff in SQL query designer, there is a (usually) yellow mark (thin yellow vertical line) to the left of each line that I type. Sometimes this line is green or occasionally it's not there (or it's ...

Upgrade Advisor issue not clear

Emanuele Ornella - 14 Jun 2006 2:53 PM - 1 message

I'm testing the upgrade from SQL Server 2000 to SQL Server 2005 and first of all I ran the Upgrade Advisor. I received one issue that I cannot understand. The desctiption is: Unexpected szVal value from parser - expected sp:name but received ...

Sql 2000 Profiler question

Joe D - 14 Jun 2006 2:52 PM - 2 messages

From time to time I get the following error: "Some trace events have not been reported to SQL Profiler because the server has reached its maximum amount of available memory for the process." The last time I ran into this (last night) I was running SQL Profiler from ...

ANN: Multi DBMS tool "Database Workbench" version 2.8.7 released

Martijn Tonies - 14 Jun 2006 8:02 AM - 2 messages

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular database development tool: Database Workbench 2.8.7 has been released today! Download a trial at: [link] What's new?: [link] ...

Can't use Profiler to get execution plan for a particular query

pshroads - 13 Jun 2006 11:37 PM - 9 messages

I am trying to troubleshoot some performance problems and I am trying to set up Profiler so that I can look at the execution plan of a particular stored procedure. I am using the ExecutionPlan event class in the Performance event category. I am also setting up a filter on ...

2005 - Refresh in Object Explorer doesn't work

DWalker - 13 Jun 2006 11:00 PM - 4 messages

In SQL server 2005 management studio, the Object Explorer has a Refresh icon. Plus, there's a Refresh item in the right-click menu if you click on the Views folder icon in a database. If you have a "Query" window open, and use that window to create a new ...

Database Engine Tuning Advisor problem

MIS - 13 Jun 2006 8:33 PM - 2 messages

I am trying to the the Database Engine Tuning Advisor in SQL 2005. I start by running a Tuning trace in SQL profiler and saving it to a file. Next I load the trace file into the Advisor for analysis. I get the following error in ...

Copy Database wizard problem

Amadelle - 13 Jun 2006 4:57 PM - 3 messages

Hi all, I am trying to user the new wizard copy database in SQL 2005 to copy one database to another server. The task always fails. In the Application events viewer it reports that it can't generate certain login accounts from ...

Profiler Error Column

smithabreddy - 13 Jun 2006 2:34 PM - 1 message

Hi, I'm capturing Profiler traces for resource intensive SPs and T-SQL statements/batches. I know a DELETE failed earlier today - the 2 million records it was supposed to delete were still in the table it was deleting from. The error column of the Profiler trace for this ...

Query Slow after Replication

wwhiteford - 12 Jun 2006 11:57 AM - 1 message

We am fairly new to replication and we have suddenly encountered a problem with our databases after replication is configured. A standard query we have always used normally takes 5 sec to run. Once replication is configured this same query takes 15sec. I have ruled ...