Developer Newsgroups: SQL Server Tools

monitor backup jobs on MSDE

inquisite - 14 Jan 2005 10:39 PM - 2 messages

We have several backup jobs on MSDE. How do I monitor these jobs and get notified when a job fails. What are the different notification possibilites with MSDE. ...

SQL reporting services - issues

Hans Cryspin - 14 Jan 2005 1:31 PM - 3 messages

Hi, i've been making for some time now a series of reports in reporting services, mainly because it's free and fairly easy to use... but, still I encountered some problems: when using matrixes in reports, the subtotals come in very handy, however, I ...

Customizing Agent Mail Backup Content

Michael - 14 Jan 2005 1:21 PM - 4 messages

Hi, I was wondering if there is a way to customise e mail alerts that are sent after a backup is taken of a database ? I currently receive the following e mail alert format JOB RUN: 'Northwind backup' was run on 14/01/2005 at 11:06:06 ...

Detecting Tables with no recent activity

Tim O - 14 Jan 2005 9:05 AM - 5 messages

Is there an efficent way to determine which tables in a SQL Server database have had no activity reccently. This includes inserts, updates, deleted and/or selects. Are there any tools or techniques to find these tables? All help appreciated! ...

How to display sub reports using SOAP API on a asp .net

Atul Bahl - 13 Jan 2005 9:19 PM - 1 message

I have created a report with bunch of sub reports. Now I am tyring to consume this report via reports soap api but the subreports are not streamed along the main report to the web server. Do I miss something? ...

Problems installing SQL Reporting Services

Cwhitmore - 13 Jan 2005 8:05 PM - 3 messages

I verified that the prerequisites MDAC, ASP, IIS 5 and MSDTC were all installed, but I'm getting an error duing the install that says: "IIS is either not installed or not configured for server component installation" Any ideas? Carlton. ...

512 Error: Finding which SQL Statement is causing using profiler

Kodi - 13 Jan 2005 7:57 PM - 1 message

Hi, I have an production issue which is causing the 512 exception. I can see this in the profiler but I can't seem to find a way to see the sql statement that is causing the error. All I see is that there is an error. Is there a ...

Profiler with Object ID

Steven Lazan - 13 Jan 2005 6:37 PM - 5 messages

I cannot get Profiler to work with just ObjectID and/or ObjectName. I want to just trace commands that access a certain table/stored proc. Is this a bug and/or is there a work around? Thanks, Steve ...

SLEEPING status in Enterprise Manager

OJ - 13 Jan 2005 6:11 PM - 2 messages

Hi, I started execution of one huge UPDATE statement in Query Analyzer, and when I check Current Activity in Enterprise Manager for my connection, I see sleeping status, and still, command is running and getting processor/IO time... What's the catche here? Isn't it suppose to have RUNNING ...

Agent Mail

Michael - 13 Jan 2005 3:05 PM - 3 messages

Hi All, I have already posted this question in a different forum it was recommended that I post it here instead. I am having a problem setting up sql agent mail. I am running in with a groupwise mail system but I have it running POP3 so I should be able to use ...

Profiler and set fmtonly On issue

SalamElias - 13 Jan 2005 2:27 PM - 12 messages

Hi, why do I have a lot of set fmtonly On, the sql phrase and then set fmtonly Off example : SET FMTONLY ON Select PROD_VAT_CODE From Product Where PROD_MANF_SKU = ...

Different dates returned from Enterprise Manager and Query Analyse

Joe Farr - 13 Jan 2005 11:51 AM - 2 messages

We have a table with an 8 Byte DateTime column. Query Analyser says the date in the column is 2005-10-31 23.59.59.990 Enterprise manager sayes the value is: 01/11/05 We have no adea which date is the correct one... ...

Save Query Results to Word

rbedick - 13 Jan 2005 4:29 AM - 1 message

Export MS-SQL and Oracle Query Results to a Word Document Jan. 12, 2004, Providence, RI: SchemaToDoc Enterprises is pleased to announce the release of a new software product: QueryToDoc. QueryToDoc lets users write queries against MS-SQL and Oracle ...

Re: What makes Enterprise Manager so slow?

tony - 13 Jan 2005 3:25 AM - 1 message

Here is a script to turn autoclose off for all of your databases. declare dbcursor cursor for select name from sysdatabases where status & 1 = 1 open dbcursor declare @name sysname fetch next from dbcursor into @name while(@@FETCH_STATUS = 0) BEGIN ...

database backup schedule not working

Gilbert - 12 Jan 2005 7:45 PM - 2 messages

I'm running SQL server 2000 on a Windows Server 2003. I'm trying to schedule a backup for my databases but it's not sticking. I went under Backup Database, selected the local disk as a backup destination, clicked on ...

Scheduling a .sql file through "jobs"

Amy - 12 Jan 2005 5:43 PM - 3 messages

This is going to be a stupid, easy question; but I'm a SQL Server Newbie, so here goes... I have a .sql file that I need to schedule to run through SQL Server. The actual SQL in it is too large to be pasted into the Exec Transact-SQL screen ...

cribe Report Generator - version 1.0 released

Alex Molochnikov - 12 Jan 2005 5:39 PM - 1 message

Gestalt Corporation announces the release of the production version of Scribe. Scribe is a report generator that can: - produce reports from one or more relational databases, - e-mail the reports as PDF attachments or HTML-formatted content, - publish them over the Web in PDF or HTML format, ...

Index Tuning Wizard doesn't work

OJ - 12 Jan 2005 4:32 PM - 2 messages

Hi, I was running profiler trace for few days with the intention to run index tuning wizard against trace files. However, it fails with the following message: "The workload does not contain any events or queries taht can be tuned against current database. Check to see that ...

Microsoft SQL Server Best Practices Analyzer

Martin Millar - 12 Jan 2005 4:21 PM - 3 messages

Should this tool be installed and run in a production server???? ...

Problem with Best Practices Analyzer and set nocount on.

Esio Nunes - 12 Jan 2005 4:20 PM - 2 messages

Hi. There is a bug with BPA. When you configure a server with sp_configure 'user options',512 or EM (default connection options) seting to NOCOUNT ON, BPA fails when reading the catalog. Esio ...

How to recreate/restore the database from the data and log files

Karen Middleton - 12 Jan 2005 11:58 AM - 3 messages

My development system hard disk crashed and I have lost the Operating system and the SQL executables and the system cannot be salvaged. However at the time of the crash the server was not running and the log files and the data files of the database were on another hard ...

RE: BPA Installation Error

Mike W. - 11 Jan 2005 10:31 PM - 2 messages

I was having the same problem. I solved it by: Removing BPA in Control Panel/Add Remove Programs Removing the BPA database from my SQL Server Removing the BPA directory in c:\Program Files After doing all these, it installed fine. Now to try it... ...

Tools for export data definitions to word or excel

Alu - 11 Jan 2005 10:19 PM - 4 messages

Are there any microsoft tools available to export SQL database tables & column names with description to word or excel ? I know we can use Visio reverse engineer to get the ER diagram but that is not what I am looking for.. ...

Cannot connect to SS 2000 across Internet

Bill Todd - 11 Jan 2005 2:49 PM - 2 messages

I am attempting to connect to a named instance of SS 2000 across the Internet using Enterprise Manager. The machine running SS is behind a NAT router. According to BOL I should be able to connect if I forward the TCP ...

DB shld b available thru our Front-End App not any other means SQL Ent. Mgr etc.

paresh goyal via SQLMonster.com - 11 Jan 2005 10:30 AM - 2 messages

Hi, The users are made accessible to SQL server thru a windows group say member users of AppUserGroup. whoever is the member of this group can access sql server thru any client application like SQL Query Analyzer, SQL Enterprise manager. ...

Newbie requires advice on Log Shipping

KOdedra - 11 Jan 2005 9:05 AM - 3 messages

Hi, Trying to setup up log shipping in a test platform in a workgroup between Two Enterprise Edition servers. Running through the Maintenance Plan wizard i get as far as copying the Initialization.Bak file to the share on the primary ...

MYSQL and Reporting Server

Michael van der Veeke - 11 Jan 2005 5:58 AM - 3 messages

Hi All, Not sure if this is the best place to ask this, but how can I use parameters in a report connecting to a MYSQL database. Thanks Michael ...

SQL Query Analyzer cannot bring up all the database in Object Brow

Kam - 11 Jan 2005 5:05 AM - 3 messages

when using the enterprise Manager, I can read 12 database. But when I use the SQL Query Analyzer, I can only read 6 DB. They are Master, Model, Msdb, Tempdb, Northwind and pubs. I try to disconnect and connect again or refresh. It didn't help. ...

Query Analyzer Adds Blank Line in Scripts of Objects

Michael Lowery - 10 Jan 2005 2:43 PM - 2 messages

I was wondering if anyone knows why Query Analyzer will add an extra blank line when editing objects? Here's how I can reproduce the problem: 1. Edit an object in QA, let's say a stored procedure, by right clicking on ...

How to get BLOB using PHP

Guntar Klopek - 10 Jan 2005 2:01 PM - 1 message

I am told this is a BLOB image from a 7.0 server I querried. Next I list the charactors from the table field. 0xFFD8FFE000104A46494600010201009600960000FFED123A50686F746F73686F7020332E30003842494D03E900000000007800030000004800480000000002DA0228FFE1FFE102F902450347052803FC00020000004800480000000002D80228000100000064000000000003030300000001270F0001000100000000000000 How do I get back to an image... I am using PHP but use what info one ...

How to restrict access our DB on SQL server.

paresh goyal via SQLMonster.com - 10 Jan 2005 12:49 PM - 3 messages

Hi, How can we restrict our DB if connecting thru other applications like SQL query analyzer, Excel & even Enterprise manager? but this DB should be accessible by our application (from front end) only... I learned about "Application Role" in SQL server 2000 but to apply this ...

Why does "Select ... FOR XML RAW" only return one row.

Dwight - 10 Jan 2005 12:13 PM - 1 message

Hi I have the following simple query SELECT Forename,Surname FROM Customer FOR XML RAW This only returns one row with all the records in this one row. Does anyone know how I can produce a row for each record? ...