Home All Groups Group Topic Archive Search About

SQL Server Tools

microsoft.public.sqlserver.tools
Score Surface area configuration tool error
John - 17 Dec 2005 1:03 PM - 3 messages
Hi When I go into the 'Surface Area Configuration for Services and Connection', I get the attached error and when I click on OK the app exists. How can I fix this? Thanks Regards [attached file: surface.gif] ...
Score SqlServer 2005 Maintanence Plan Backup
Christian Haugan - 17 Dec 2005 12:32 PM - 4 messages
In the maintanence plan wizard for SqlServer 2000 there was an option to remove backupfiles older than x days. I cannot seem to find this option in SqlServer2005. Is this option gone or simply moved/renamed? regards, Christian Haugan ...
Score SQLDMO:To Change Database file Location path of DBBackup file ( VC
Inthi - 17 Dec 2005 11:44 AM - 3 messages
Dear all I am creating a tool in VC7.0 for database restoration I am facing a problem while working with sql dmo objects i need to restore a database, which has database location as "C:\Program Files\Microsoft SQL ...
Score Enable sa login for SQL Express 2005 using osql.exe
Qingsong Zhang - 17 Dec 2005 7:29 AM - 2 messages
Hi, Is there a way to enable the sa login using osql.exe? I think SQL Express 2005 disables the sys table modification using osql.exe. Regards, Qingsong ...
Score Maintenace Plan Backup
Eduardo Barcante - 17 Dec 2005 1:47 AM - 4 messages
I created a Maintenance Plan with All Database option. The job Transaction Log Backup failed because the Master and msdb database is in SIMPLE model. How can I create a Maintenance Plan with All Database option and run the the ...
Score ManStud 2005 - how to script permissions for a SP
Koni Kogan - 16 Dec 2005 7:32 PM - 1 message
It looks like this functionality that existed in QA 2K has been taken away...  Is this true? ...
Score query in SQL 2005 profiler in wrapped format
likong - 15 Dec 2005 10:42 PM - 2 messages
In SQL 2005 profiler, the bottom half of each trace window displays the actual SQL query in "wrapped" format (e.g., a single line long query is wrapped into multiple lines), which is different from SQL 2000 profiler where the actual query is displayed in non-wrapped format. ...
Score Integrating Management Studio With Subversion or CVS
Randy M. Franklin, Jr. - 15 Dec 2005 5:32 PM - 2 messages
Hello, I'm wondering if anybody knows whether it's possible to use Subversion or CVS with Management Studio instead of SourceSafe? We use CVS and Subversion in our development house and now that Management Studio works with SourceSafe, I'm wondering if there are any plugins available to make it work ...
Score Stored Procedure Usage
Susanna - 15 Dec 2005 2:30 PM - 2 messages
Is there something that can check the usage of a stored procedure? ...
Score Income for life
sixgun11 - 15 Dec 2005 11:39 AM - 1 message
Your own web domain plus income for life. Wish you had a dollar for every dot com address? Dont miss out!! http//:[link] ...
Score Trying to Copy DB and getting Error
Doug Handler - 15 Dec 2005 9:23 AM - 2 messages
Hi, I'm trying to "copy" a DB w/i 2k5 and when the wizard goes to execute my request, i get an error "No such interfacess supported."  No details are provided, just this message.  I'm unsure what it means or how to resolve it. ...
Score transaction log for the simple recovery model
Wendy Elizabeth - 15 Dec 2005 5:41 AM - 2 messages
The database that I just started to work with has a simple recovery model.  The actual production database is 5 gigs while the transaction log table is 98 gigs. I can not figure out how the transaction log became so large. There ...
Score SQL 2K Enterprise Manager Configuration
Isaac Waters - 14 Dec 2005 7:06 PM - 1 message
Can I configure Enterprise Manager under my profile and copy those settings to another users. I found the reg key but when I copied it to that users profile the SQL Group came up, but not the servers. I guess I want know how I can do this? ...
Score How to install Management Studio on client for 2005
dino_hsu_1019 - 14 Dec 2005 8:48 AM - 3 messages
Dear all, I am a newbie of SQL server, and I am going to study it because of its excellent BI functions. Before this, I have been experieced with Oracle, and I will try client-server connection to get started with SQL ...
Score sql server 2000 tools
Wendy Elizabeth - 13 Dec 2005 9:50 PM - 2 messages
My company as a sql server 2000 transaction log file that is too big. I need to truncate the size of the log file. I am relatively new to a small company that does not have an assigned DBA since there are only 5 programmers. I have been working with sql server 2000 ...
Score How to concatenate two text columns
Raju - 13 Dec 2005 8:50 PM - 3 messages
Hi all, I have a two text columns in my table with more than 100,000 rows. I want to create a third text column with the data from text column 1 + text column 2. Is there an easy way to concatenate two text fields? ...
Score Management Studio support for Foundation Server Source Control
Peter__T - 13 Dec 2005 9:36 AM - 2 messages
2nd Post on this as I didi not have a NoSpam alias!! Does the SQL 2005 Management Studio support source Control from Team Foundation Server.  All the documentation refers to VSS.  I have the TFS client installed and is working with Visual Studio but is not ...
Score new tool
Miqui - 13 Dec 2005 9:10 AM - 1 message
QuerySense adds SQL Intellisense-like features to Query Analyzer. It also can be used to document your DB. It costs EUR 19.90. [link] Regards ...
Score Disable a job schedule
Lynn - 13 Dec 2005 12:18 AM - 2 messages
Hi, I have a job with three steps and four schedule time per day.  I schedule a job to disable one of schedule time, such as 5:00PM schedule.  The job is still enable, but this schedule time show enabled =NO before ...
Score Reporting Services - Excel vs HTML ERROR plz help
Sorcerdon - 12 Dec 2005 9:17 PM - 2 messages
Hey, I have a little format issue with Excel 2003: I am working in reporting services - creating a report. The SQL store procedure returns a date with the following format: MM/DD/YYYY HH:MM PM/AM In my report on that perticular text field I have the following format: ...
Score Strange Behavior w\ SQL Server Management Studio
ZNICHTER - 12 Dec 2005 7:56 PM - 3 messages
Alright I am having a couple of strange problems with SQL Server Management Studio.  First, I am hitting a SQL Server 2000 box with no problem.  I am running a script that runs in 10 seconds for all batches together and it is ...
Score Planned Migration from SQL 2000 to 2005
Richard Brown - 12 Dec 2005 5:15 PM - 2 messages
Although we absolutely need to keep from updating our many SQL 2000 databases to 2005 versions, I'd like to get our technical users familiar with the new Management Studio / tools.  Is there any reason not to upgrade client ...
Score ANN: Version 2 of Reporting Services Scripter now available
Jasper Smith - 12 Dec 2005 2:33 PM - 1 message
Download Version 2 of Reporting Services Scripter [link] An updated version of Reporting Services Scripter is now available (Build 2.0.0.0). This major release adds full support for SQL Server Reporting ...
Score SQL Server Mgmt Studio Express doesn't run...
Wade - 12 Dec 2005 12:16 PM - 1 message
Does anyone have any ideas to solve the following from a post back on 11/30/05? In addition to uninstalling from the control panal, I've tried using "Windows Install Clean Up" without any success in re-installation. ...
Next »