Home All Groups Group Topic Archive Search About

SQL Server Tools

microsoft.public.sqlserver.tools
Score SQL Server Management Studio and Developer Edition
michael - 14 Jan 2006 10:03 PM - 5 messages
I have success managing my Developer edition of SQL Server 2005 when the SS Management Studio is on the local machine with the  SQL Server instance. However, I can't seem to manage another Developer edition on a another ...
Score Which version of SQL Server?
gregory_may - 14 Jan 2006 12:13 AM - 3 messages
I am developing a small application that needs quick access to about 12 Megs of data.  This 12 Megs of data is mastered in another application.  So, my app needs to refresh from the source every 1/2 hour or so.  But, there is ...
Score sp_send_dbmail
ronc - 13 Jan 2006 4:18 PM - 2 messages
Can this mail feature be used in sql 2005 express edition?  Thanks ...
Score ToString UDT
William Stacey [MVP] - 12 Jan 2006 11:01 PM - 17 messages
My UDT works fine on the server and ToString() will work on the type in a Select.  However, even if I install .dll into GAC, SSMS will not display my UDT as a string (i.e. does not call ToString()) so I get byte display ...
Score Copy database
William F. O'Neill - 12 Jan 2006 7:38 PM - 2 messages
What is the best way to copy an entire SQL Server 2K DB?  I want to take an existing DB on one computer, and move its entirety to another.  It seems that DTS will only import/export tables...  I'd like to be able to get the ...
Score Executed as user: domain\user. Warning: cannot write a log to table. The step failed.
Phil Nicholas - 12 Jan 2006 6:03 PM - 2 messages
Trying to processing a dimension via the agent in 2005 & I get this error (seems to be possible as a AS command)?? Can't find any reference to it on the web (beginning to remember why I tend to leave new stuff for a couple of ...
Score backing up databases
rodchar - 12 Jan 2006 5:58 PM - 3 messages
hey all, i have several databases in my sql server i need to back up. Do i have to do them individually or is there a way i can back them up all at once? thanks, rodchar ...
Score Problem Viewing SQL2000 Tables Definition chm
Chris Wood - 12 Jan 2006 5:13 PM - 5 messages
Hi, I have the systabl.chm compiled HTML help file from the Resource Kit. I was able to view the table definitions before the MS06-001 problem surfaced. Now I just get an Action cancelled screen saying Internet Explorer was unable to ...
Score how do you edit query results in results pane of Management Studio
David Hubbard - 12 Jan 2006 4:03 PM - 9 messages
I have been running querries in management studio and ocasionally I want to edit the result set but when you double click on the row and column you want to edit nothing happens. I have searched google and seen some references to ...
Score where is SQL Server Management Studio?
Federico Caselli - 12 Jan 2006 11:52 AM - 7 messages
Hi, I've installed SQL Server 2005 Dev and VS 2005 pro. I just can't find SQL Server Management Studio from the menu start-> programs-> SQL Server 2005. Can you help me? Thank you. ...
Score mssql export to webhost, when creating asp.net pages
syska - 12 Jan 2006 11:11 AM - 1 message
Hi, I talked to a Microsoft person for about 4 month ago, and he said that microsoft was developing a tool/program, so it was easier to deplay the mssql database to the webhost.... at that time it was still beta. I ...
Score Limiting a server side trace to a specific table in SQL 2000
Chris Powell - 11 Jan 2006 11:00 PM - 1 message
I have setup a server side trace on a database, but now I want to limit the queries captured to a specific table.  Is there a way to do this with the filters available? I have attempted to filter on the Object Name, but the SQL:BatchCompleted ...
Score StoredProc View Permission
icsTeam - 11 Jan 2006 8:05 PM - 2 messages
Hi there, We would like to create a restricted account in such a way that that account cannot view all stored procs from Query Analyzer or Enterprise Manage. We want to give view access to some stored procs though. Currently I can restrict this account so that user won't be able to view any ...
Score Unexpected EOF problem with BCP in
Chen - 11 Jan 2006 2:20 PM - 2 messages
Hi, Does anybody know that when execute bcp in utility, I received error message: Unexpected EOF from SQL Server 2000 with SP4. Actually the data text file is bcp out table_name.txt and export/import table data in same database ...
Score Restore Dialog Box Won't Open
John Oberlin - 10 Jan 2006 5:50 PM - 3 messages
I am trying to restore a particular database in Enterprise Manager and the restore dialog box won't open.  I right-click the database and select All Tasks >> Restore Database... Enter. Mgr sits at an hour glass 'not ...
Score Updated Version of SqlClrProject
Niels Berglund - 10 Jan 2006 5:44 PM - 1 message
Back in December (26:th to be exact) I released a new version of the SqlClrProject and wrote about it here [0]. One drawback of the deployment functionality was that you could only deploy locally as the deployment process used the CREATE ASSEMBLY based ...
Score problem with SQL 2000 Enterprise Manager display
JD - 10 Jan 2006 3:57 PM - 8 messages
Hello,    I'm having problems when using SQL 2000 Enterprise manager and viewing the Distribution Agents via Enterprise Manager. I have this SQL server setup for replication with a local a distribution database. When I click on the ...
Score Management Studio - Persist Connections
Amos Soma - 10 Jan 2006 3:27 PM - 2 messages
I'm finding that each time I enter Management Studio I have to re-establish all the connections I had established last time I was in M.S. Is there any way I can have these connections persisted so that they are there by default ...
Score limit connections option
rvegas - 9 Jan 2006 5:51 PM - 5 messages
Under the server properties>> connections tab. I have an option "max concurrent user connections set to 0" Can some one plase tell me what is this for? and what should i set it to? This is a shared server with 150 databases belonging to different domains, ...
Score Script data to T-SQL
Thomas - 9 Jan 2006 4:43 PM - 1 message
I am pleased to offer, free of charge, a new version of SQL-Scripter: - Generate INSERT, UPDATE, DELETE (+ Combinations) data scripts in T-SQL. - All sources are supported (Table, View, SQL). - Free selection of your fields and key fields - Save and read settings to template files. ...
Score Test operator using SSMS?
Ken Jensen - 9 Jan 2006 3:25 PM - 1 message
What happened to the ability to test email/page functionality for operators?  I am using SSMS to manage a SS2000 instance, and in the Operator Properties page there isn't a way to test sending a notification.  I know this isn't EM ...
Score SSMS Error
baddy - 9 Jan 2006 11:54 AM - 2 messages
We have two production servers running SQL 2000 and that are set up as linked servers.  My desktop has SQL 2005 and I am using MAnagement Studio to connect to the first server.  While running a stored procedure on a 1st remote server that inserts data into another server, ...
Score Management Studio scripting options
Roman Mellenberger - 9 Jan 2006 9:33 AM - 3 messages
Hi there, Is there apossibility to set the options for script creation in SQL Server 2005 Management Studio? I want to create a script with a drop and create statement... Regards Roman ...
Score Enterprise Manager Won't Run
john - 8 Jan 2006 5:46 PM - 6 messages
I am unable to start my Enterprise Manager. I get the following error message: "Microsoft Management Console has encountered a problem and needs to close". This is a SQL 2000 system. This happened one day for no apparent reason. I use SQL Enterprise Manager ...
Next »