Developer Newsgroups: SQL Server Tools

Good Dashboard Tools

Josh Sale - 16 Dec 2006 12:49 AM - 4 messages

I have a multidimensional application and have built an interface that exports the application data to a SQL Server 2005 data cube. My users are clamoring for dashboards. Can anybody recommend good tools for building web based dashboards that get their data from a SQL Server 2005 data cube? ...

sql2000 wrong delete can restore??????????

lizj - 15 Dec 2006 9:36 AM - 4 messages

anyone help!! if i deleted several rows from sql2000, and i had no backup,no trans log, can i restore what i deleted? if yes, tell me more... thanks ...

SQL Server Profiler analyzer tools

Brian Madden - 14 Dec 2006 8:35 PM - 2 messages

Hi all, I need to find an open source analyzer tool for SQL Profiler results. Is there anything out there that can do this? I did find Lakesides tool, but I'd prefer to find an open source tool first, if possible. I ...

SS2005 Management Studio question

Peter Lux - 13 Dec 2006 7:37 PM - 3 messages

I've got our production Great Plains db's on SqlServer 2005. In management studio, I've defined my maintenance tasks to backup the db's (34 - each company is a separate database) into separate subdirectories. The backup is fine, but deleting the older backups (2 days) is difficult. In the ...

BCP genric error

SalamElias - 13 Dec 2006 3:57 PM - 8 messages

I am trying to BCP locally, first I created the format file using "BCP...nul...." and then issued the following bcp phrase : bcp myDB.dbo.WEBFARM_DailyBandWidth_temp in D:\Tracing\Charts\Dailybandwidth_ex061212.txt -T -f DailybandwidthOut.fmt I am getting the genric error ...

Announce: Version 2007 of Altova XML tools available

announce - 12 Dec 2006 3:40 PM - 1 message

....with continued support for SQL Server & other DBs. Altova is pleased to announce the availability of Version 2007 of its XML product line. Version 2007 provides numerous new features and updates, including a revolutionary new WSDL editor in XMLSpyÂ®, the ...

Can backups be done via stored procedures?

Tom Glasser - 12 Dec 2006 2:35 PM - 3 messages

That's my question. Thanks, Tom ...

can't modify table in SMS...timeout expired?

geek-y-guy - 12 Dec 2006 2:19 PM - 2 messages

Hi: I'm trying to add a field to a table by modifying it in Management Studio. I'm running SQLSMS locally on the server. When I try to save the table I get an error "Post-Save Notifications... [table name] ...

install tools

mmark75 - 12 Dec 2006 12:08 AM - 2 messages

Where would i find and how would i install the sql server 2000 tools on a win2k3 standard server. My developer is stating he wants the 'tools' installed and i'm assuming from this he means the sql enterprise ...

ADO Connection to Backend SQL Server

ashleycvernon@gmail.com - 11 Dec 2006 8:40 PM - 7 messages

I am using MS Access forms as a front end to a backend SQL Server Database. I am trying to use an ADO connection to return a Select Statement from the SQL Server to an Access form to be viewable by the ...

3rd Party Performance Tool/Software

David - 11 Dec 2006 8:05 PM - 5 messages

Is there any software that can analyze stored procedure performance and recommend solutions? Thanks, Dave ...

What is 'asdb' and whether or not it should be backed up

markfine - 11 Dec 2006 2:52 PM - 7 messages

We developed a DB for our customer using MS Access and upsized it to SQL Server. Our customer does daily back up of his DB and he asked me whether or not 'asdb' should be backed up as well. My question is: what is 'asdb' and whether or not it should be ...

jrc component for crystal report 9

samay - 11 Dec 2006 2:57 AM - 1 message

Can any one help me in this.im working with java now.now i need to use all my reports which i have done in crystal report 9 in java ie i need to call all the reports in cr 9 to java.so give me some ideas...plz i ...