Home All Groups Group Topic Archive Search About

SQL Server Tools

microsoft.public.sqlserver.tools
Score Scheduling backup of SQL 2005 while database is in use
Bill Bradley - 1 Jul 2006 2:08 AM - 2 messages
I use a patch scanner/deployer, Shavlik NetChk, with a SQL 2005 w/SP1 backend.  This is setup on a server 2003 w/SP1 computer with multiple drives for OS, APP, SQL, LOGS, SWAP. I run this at odd times, but, would like to also schedule a maintenance plan ...
Score SQL 2005 redundant error message
DWalker - 30 Jun 2006 4:27 PM - 2 messages
When you modify a view in SQL 2005 Management Studio, and there's an incorrect column name (that you typed in the SQL pane), you get a silly error message: Invalid column name "Categorry" Invalid column name "Categorry" It's so nice they named it twice! ...
Score SQL 2005 Find and replace
DWalker - 30 Jun 2006 4:18 PM - 2 messages
When I am in the Management Studio, and editing a view (using Modify View), Find and Replace doesn't let me change things in the SQL part of the view definition.  Is this by design? When editing a view, Quick Find and Quick Replace are grayed out.  Why? ...
Score Unicode encoding with SQL Management Studio
Tom Huguelet - 30 Jun 2006 3:16 PM - 5 messages
Greetings all, We have an environment that is a mixture of SQL 2000 and 2005. Most of my developers are switching over to use SQL Management Studio for both SQL 2005 and SQL 2000 (Relational Engine). We also use Visual Source Safe 6.0 for source code control. We're ...
Score bcp invalid object name error
Raja - 30 Jun 2006 12:22 AM - 2 messages
Hello All, I am trying to perform the following bcp command but keep getting "invalid object name error".  Please help. C:\Documents and Settings\radhikari>bcp lp_risk.dbo.risk_hourly_var out test.xls /Ubcp_user -c Password: SQLState = 42S02, NativeError = 208 ...
Score Announcing a new SQL Comparison tool - get your unlimited free copy
yoni - 29 Jun 2006 1:57 PM - 1 message
Nob Hill Software, maker of several popular SQL Server tools, now have their own SQL Server schema comparison tool. It is Superior to other tools on the market in several ways; You can download your own copy at Since this tool is new, we are mainly looking for user feedback. ...
Score "Attempt to fetch logical page" during attaching
Angelo Brusati - 29 Jun 2006 8:56 AM - 3 messages
Hi everybody As my SQL server had some problems, I had to reinstall it. Once reinstalled, I wanted to attach the original .mdb and .ldf files, but I got the error message: "Attempt to fetch logical page during attaching". I'm lost. How can I solve this problem? ...
Score Foreign Key Relationships Management Form
Karl 140.6 - 28 Jun 2006 9:01 PM - 2 messages
To : Microsoft SQL Team I've just started using the "new" SQL Server 2005 and was checking some foreigh key relationships. The form you gave us is "SO" small and tight and you "can't" adjust the size when using it. ...
Score Error 0x80041010 WinMgmt when launching SQL SERVER MANAGEMENT STUD
Pan - 28 Jun 2006 4:27 PM - 10 messages
Event filter with query "select * from __InstanceModificationEvent within 10 where TargetInstance isa 'Win32_Service'" could not be (re)activated in namespace "//./root/Microsoft/SqlServer/ComputerManagement" because of error 0x80041010. Events may not be delivered through this filter until the problem is corrected. ...
Score How do you insert a carriage return in Management Studio?
Nick Gilbert - 28 Jun 2006 3:49 PM - 8 messages
Hi, This is really winding me up. How on earth do you type a carriage return   into a field from the "open table" view in SQL Server Management Studio? I think I've tried everything - including copying and pasting ...
Score Scheduling of snapshot agent
perhiyar - 28 Jun 2006 6:14 AM - 1 message
I have replicated a database as a snapshot replication. I have scheduled distribution agent to run at the interval of one hour daily from 9:00 AM to 5:30 PM. Do i also need to schedule snapshot agent accordingly? What will be optimal schedule depending on the scheduling ...
Score bcp invalid object name
Mike - 27 Jun 2006 4:42 PM - 2 messages
I have a bcp command bcp xxxxx.FASTECHTIME.EmpEvals out C:\EmpEvalsDue.txt -STime -Uxxxxx -Pxxxxxxxxxxx for which I receive the error SQLState = 37000, NativeError = 4060 Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'xxxxx'. Login fails. ...
Score Backup and Restore
Gary L - 27 Jun 2006 3:42 PM - 4 messages
I am attempting to restore a database to a different server.  When I run restore either from the GUI or a script I receive the following error: System.Data.SqlClient.SqlError:  The backup set holds a backup of a database ...
Score How to Remove "SQL Server Management Studio" from My Docs?
JonOfAllTrades - 27 Jun 2006 1:23 PM - 3 messages
Good morning.  This is not important, but it's been irritating me, maybe someone here knows the answer offhand? Every time I start SQL Server Management Studio, it creates a directory in my documents folder.  This is "my" documents folder, organized with care.  I ...
Score save query results to formatted text file
sneaky - 26 Jun 2006 9:53 PM - 3 messages
Greetings, I'm very new to SQL & I'm attempting to schedule a weekly query that saves the results to a formatted text file. I used osql but the format was wrong.  (all spread out, lots of whitespace & ...
Score ANN: Context Database Designer v.2.07 for MS SQL 2005 is now available!
Context Software - 26 Jun 2006 7:30 PM - 1 message
Dear Friends, We are happy to announce the new release of Context Database Designer & Database Extensions v.2.07. Context Database Designer & Extensions now supports:   - MS SQL 2000/2005/Express   - My SQL 4 & 5   - Mimer 9 ...
Score SQL Server Management Studio - Script Objects to Individual Files
jlccd@newsgroups.nospam - 26 Jun 2006 4:06 PM - 2 messages
Using SQL Server Enterprise Manager we typically select a group of objects and scripted them to individual files.  We are in the process of migrating to SQL Server 2005 and using SQL Server Management Studio.  How can we ...
Score SQL Server Management Studio - one file per object
jlccd@newsgroups.nospam - 26 Jun 2006 3:56 PM - 3 messages
Using SQL Server Enterprise Manager objects could be selected, stored procedures, tables, triggers... and scripted to individual files. We are in the process of migrating to SQL Server 2005 and we are all getting familiar with Management Studio.  Typically all the objects were scripted to ...
Score WE ARE LOOKING FOR FASHION CLOTHES REP
worldwideconsulting - 26 Jun 2006 3:49 PM - 1 message
Contact : Mr. Lutfi Bakir Tel : 001-954-524.2341 MSN : lb33***@hotmail.com ''L'' SKYPE : lbakir ''L'' Best Regards ...
Score WE ARE LOOKING FOR FASHION CLOTHES REP
worldwideconsulting - 26 Jun 2006 3:49 PM - 1 message
Contact : Mr. Lutfi Bakir Tel : 001-954-524.2341 MSN : lb33***@hotmail.com ''L'' SKYPE : lbakir ''L'' Best Regards ...
Score WE ARE LOOKING FOR FASHION CLOTHES REP
worldwideconsulting - 26 Jun 2006 3:49 PM - 1 message
Contact : Mr. Lutfi Bakir Tel : 001-954-524.2341 MSN : lb33***@hotmail.com ''L'' SKYPE : lbakir ''L'' Best Regards ...
Score need tool for managing database object ownership
batman - 26 Jun 2006 3:01 PM - 4 messages
we have a group of developers which have created and asked us (DBAs) to create many objects in the databases including tables / stored procedures / functions / etc. since our company is growing, however we have an increasing amount of objects that have either been abandoned or have several versions. ...
Score Management Studio: Backup and Restore Events Report
Michelle - 26 Jun 2006 2:09 PM - 2 messages
Why does this report not have any data for my databases?  We use SQL Lite Speed but I backed up a database using native commands and still this report only has descriptions of the different sections but no data. For example, the ...
Score Backup SQL 2K using Volume Shadow Services on Win2K3?
Bill Bradley - 25 Jun 2006 2:09 PM - 1 message
Can VSS be used with SQL 2K SP4? Does this just automatically work in a maintenance plan, or, do you have to use the Windows Backup tool? I COULD backup this DB using a third-party product, CommVault, but...am ...
Next »