Home All Groups Group Topic Archive Search About

SQL Server Tools

microsoft.public.sqlserver.tools
Score Can SSIS packages target SQL 2000 DBs?
Beige Bond - 4 Mar 2006 1:05 PM - 2 messages
It would seem like it could, but I don't see that mentioned explicitly anywhere. ...
Score error launching SSIS SQL 2005 Ent
decipher - 3 Mar 2006 4:43 PM - 1 message
Hello, I recently installed sql 2005 in a two node cluster.  I first installed analysis services and sql 2005 clustered.  Then i went back and installed reporting, notification and integration studios on both nodes.  i can lauch ...
Score 1 day left: 75% discount on SQL Server/Oracle/MySQL/Firebird/InterBase developer tool!
Martijn Tonies - 3 Mar 2006 8:21 AM - 1 message
This week only, because of the 5-year celebration of our database development IDE Database Workbench, there's a 75% discount on ALL modules. Database Workbench supports InterBase, MySQL, Firebird, Oracle and Microsoft SQL Server. Feel free to spread this news! ...
Score Scripting schema & data absent in 2005?
Juan Dent - 2 Mar 2006 10:31 PM - 7 messages
Hi, I started using SQL Server 2005 developers edition a couple of months ago and I notice that it is no longer possible (or I have been too dumb to find how) to script both a selection of tables AND their data. As far as I can ...
Score Openquery Error
pradeep_raina@hotmail.com - 2 Mar 2006 10:14 PM - 4 messages
Hi I am trying to connect to teradata using SQL Query Analyzer Teradata is linked through our Linked Server Below is the query I run select * from openquery(teradata, 'SELECT * FROM mktg.vtcsr'); mktg is schema is teradata database The error it gives me is: ...
Score sql editor
Fritz Robert - 2 Mar 2006 3:33 PM - 2 messages
Hi! I like another sql editor in place of the query analyzer. I need the intellilist, outlining and bracket injuctions. Help! What? ...
Score database diagrams in SQL 2000 + VS.NET 2005
Graham Charles - 2 Mar 2006 7:40 AM - 1 message
I've recently upgraded to VS.NET 2005 (still using SQL Server 2000), and I'm no longer able to edit database diagrams from with VS.NET as I could with 2003. Am I missing a setting somewhere, or is this no longer ...
Score SQLCMD errorlevel?
Pablo Montilla - 1 Mar 2006 10:58 PM - 3 messages
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, I'm executing the following command line inside a .cmd file: osql -E -S .\sqlexpress -b -n -d DBName -i commands.sql if %errorlevel% neq 0 goto error goto end echo Something went wrong... ...
Score CheckPoint causing long SP durations
donsql22222 - 1 Mar 2006 9:30 PM - 3 messages
There are thousands of continuous SELECTS on the tables per min and durations are good and low. Periodically, there are massive INSERTS done in batch that number in the many thousands. While monitoring the Checkpoint Pages/Sec counter, whenever the checkpoint ...
Score ANN: Version 2.0.0.5 of Reporting Services Scripter now available
Jasper Smith - 1 Mar 2006 8:35 PM - 1 message
An updated version of Reporting Services Scripter is now available (Build 2.0.0.5). This release adds a commandline version (RSScripterCmd), a new scripting mode to generate input files for RSScripterCmd and fixes an issue with some scripting options being ignored when scripting Linked Reports. ...
Score CheckPoint Pages/Sec counter
donsql22222 - 1 Mar 2006 8:28 PM - 2 messages
In EM, changed the checkpoint interval to 1. I monitored the CheckPoint Pages/Sec counter and inserted 3000 records and waiting 10 minutes, I have not seen any activity on this counter. SQL 2000 SP4 Thanks, Don I'm trying to solve a problem where during the CheckPoint Pages/Sec that SQL ...
Score Exception trying to import data from Excel .
Rich Denis - 1 Mar 2006 7:58 PM - 8 messages
Hello, I am running SQL Management Studio and was trying to import excel data into a table on my local 2005 database.  When I choose the import task then choose Excel as the data source I get this lovely message: ...
Score Monitor Index Usage.
mpighin - 1 Mar 2006 6:35 PM - 2 messages
Hi, Is there any tool out there that can monitor what indexes are being used in SQL Server? Example a filter in SQL Server Profiler for index usage? Marcel ...
Score ANN: MSSQL LogManager v1.5.0 has been released!
Thomas Steinmaurer - 1 Mar 2006 4:58 PM - 1 message
Ladies and Gentlemen, Upscene Productions is proud to announce the next version of the popular logging/auditing suite for Microsoft SQL Server: MSSQL LogManager 1.5.0 has been released today! MSSQL LogManager supports: - Microsoft SQL Server 2000, 2005 - MSDE 2, SQLExpress 2005 ...
Score Problems with DTS in SQL 2005
Beige Bond - 1 Mar 2006 4:43 PM - 2 messages
Hi, I'm try to edit/run DTS packages against a SQL 2005 (developer edition) database. I installed the download to support the DTS designer, but occasionally the designer still prompts for the download and then (usually) crashes. Sometimes, however, it works fine -- sort of. In Bulk Insert task, I can't ...
Score EARN $3,000.00 A DAY. OPEN AN INCOME-DAILY ACCOUNT WITH US
ISRAEL FAGBEMI - 1 Mar 2006 7:15 AM - 1 message
<HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>YOU COULD BE EARNING OVER $3K A DAY , $100K A ...
Score Limit on the size of the select generated by "open table"?
DS - 1 Mar 2006 12:18 AM - 1 message
Is there a limit to the size of the select statement that is generated by the "open table" command in Sql Server 2005 management studio? I can run what should be the same select (auto generated by "Script Table as->SELECT to->New Query Edit Window") interactively. But, when I do a "Open ...
Score ANN: Version 2.6 of SQLExecMS is released.
John Smith - 28 Feb 2006 11:01 PM - 1 message
Version 2.6 of SQLExecMS is released! SQLExecMS is a program having almost everything DBA or developer needs to work with MS SQL Server. This version is fully compatible with SQL Server 2005 and SqlExpress. It supports Schemas, CLR Objects, Partition Functions, Partition Schemes, ...
Score email notificaiton when log files are getting large
Joe Murphy - 28 Feb 2006 2:54 PM - 9 messages
Can SQL send me an email alert when log files are getting large? Thanks, JM ...
Score Restore DB table - SQL Server 2000
darren.daniel - 28 Feb 2006 1:06 PM - 1 message
Hi, I made a release on system at 12pm 22/02 and overwrote a table by mistake. I have a back from from the night before (12 at night) but from the time I did a backup and and the time I did the release some records ...
Score Restore DB table - SQL Server 2000
darren.daniel - 28 Feb 2006 1:06 PM - 2 messages
Hi, I made a release on system at 12pm 22/02 and overwrote a table by mistake. I have a back from from the night before (12 at night) but from the time I did a backup and and the time I did the release some records ...
Score SQL Mail
Gary Angus - 27 Feb 2006 10:08 PM - 6 messages
Running SQL 2000 sp4 on W2003 server.  Trying to get SQL Mail to run. Installed Outlook 2000 and setup my profiles as Internet POP3.  I can send mail fine from Outlook.  In SQL no profiles are found. In SQLAgent the Mail ...
Score behavior of command in the 'SQL Query Analyzer'
dbuchanan - 27 Feb 2006 1:41 PM - 4 messages
Hello, A command in 'SQL Query Analyzer does not return expected results. This command:     sp_depends 'lkpRate' Returns these results:     dbo.usp_Rate_del    stored procedure     dbo.usp_Rate_ins    stored procedure ...
Score Import/Restore/Transfer, Only Updated/Changed/New Values Between Two SQL Server Over Dialup Connecti
Tahir - 27 Feb 2006 11:57 AM - 1 message
HelpTopic: Import/Restore/Transfer, Only Updated/Changed/New Values Between Two SQL Servers Over Dialup Connection. ...
Score One week only: 75% discount on database developer IDE
Martijn Tonies - 27 Feb 2006 11:35 AM - 1 message
For the 5-year celebration of our developer tool Database Workbench, we have this special week. Database Workbench supports multiple database engines from within a single IDE. The SQL Server module was added recently, so are the Oracle MySQL modules. ...
Score SQL Server 2005: Error 14258...SQL Server Agent is starting
Jill - 27 Feb 2006 4:57 AM - 9 messages
When ever I try creating a job under SQL Server 2005 I get the error message: "Error 14258: cannot perform this operation while SQL Server Agent is starting; try again later". When you look under services the service looks like it has already started.  ...
Score Deleting old servers still listed in Query Analyzer ???????????????
"A_Michigan_User\ - 26 Feb 2006 7:18 PM - 5 messages
I can use the Client Network Utility (CNU) from SQL 2000 to create/delete aliases. But when I 1st run Query Analyzer (QA)... it shows a list of some old servers we used to have... long ago. How do I delete from that list? ...
Score How determine the number of CALs installed
Bill - 26 Feb 2006 4:21 AM - 2 messages
How can I determine the number of CALs installed on SQL Server 7? I need to determine the number of CALs that must be purchased to upgrade. ...
Next »