Home All Groups Group Topic Archive Search About

SQL Server Tools

microsoft.public.sqlserver.tools
Score how do I view a database transaction log?
public heath vb developer - 18 Mar 2006 9:09 PM - 4 messages
One of our developers had all of the data from all of the tables in his database show 0 rows.  The tables were still present. I wonder if viewing the transaction log would give a clue about the cause, ...
Score ¤ China ZhongZhan Aids Mei Mei
enlamasperm - 18 Mar 2006 4:41 PM - 1 message
Killer! [link] el***@digi-art.de ...
Score ¤ China ZhongZhan Aids Mei Mei
enlamasperm - 18 Mar 2006 4:41 PM - 1 message
Killer! [link] el***@digi-art.de ...
Score Management Studio Projects
Homam - 17 Mar 2006 11:54 PM - 2 messages
Is there a way to add folders to SSMS projects? Without the ability to add folders, the utility of SSMS projects is very limited, almost useless. Also, we can't we add projects generated by SSMS to VS 2005 solutions? ...
Score The Data Miner: SQL Server Data Mining Newsletter (March 2006)
Raman Iyer [MS] - 17 Mar 2006 11:49 PM - 4 messages
the data miner        sql server data mining news      March 2006 Welcome to the March 2006 issue of 'The Data Miner' - the official newsletter of SQL Server Data Mining, back after a long hiatus (we were busy celebrating the SQL Server 2005 launch :-)). This periodic newsletter keeps you up-to-date with the latest happenings in the SQL Server Data Mining world and gives you useful tips to help you get the most from SQL Server Data Mining. ...
Score SMS SQL Table Diagram
MJuarez@newsgroups.nospam - 17 Mar 2006 8:16 PM - 2 messages
Does anyone know where to find a diagram (poster like) of all the tables in the SMS database? ...
Score Hidden max number of columns in Management Studio?
Kan - 17 Mar 2006 6:43 PM - 2 messages
Hi, The following is observed in the SQLServer 2005 Management Studio Visual Editor: Open table (Right Click option on a table) fails when I try it on a table with lots of columns in it > 820 columns! Currently the table has no rows ...
Score Typing in time values
Arthur Dent - 17 Mar 2006 5:09 PM - 1 message
In SS2000 Enterprise Manager, in a date/time field, i was able to type in 16.25, and it would recognize that as the same thing as 16:25, and convert it properly to a time of 4:25 PM. ...
Score Erorr in SQL Management Studio 2005
René Preußler - 17 Mar 2006 10:05 AM - 1 message
Hi, sometime in SQL Management Studio following error occurs. after this error ths Summary window ist gray and no items are shown... how can I toggle JIT Debugging? René [attached file: error.txt] ...
Score SQL Management Studio 2005
René Preußler - 17 Mar 2006 9:42 AM - 2 messages
Hi, sometime in SQL Management Studio following error occurs. after this error ths Summary window ist gray and no items are shown... how can I toggle JIT Debugging? René [attached file: error.txt] ...
Score Alternative to OpenXML
Shilpa - 17 Mar 2006 8:23 AM - 1 message
Hi All, I want to pass XML and the data in the XML should be stored in the tables of the database. However, I do not want to use the OpenXML statement. Please let me know. Regards, Shilpa ...
Score Memory allocation in MS-SQL 2000 instances
dries - 17 Mar 2006 5:33 AM - 3 messages
Hi, From a previous sys-admin I inherited a a MS-SQL (2000) machine with 3 instances. It is a nice machine with 4 Gb of memory but the memory allocation is very weird: Instance A: 1400Mb Instance B: 1000Mb ...
Score bug: "autostat" of an index reported by SQL Server Management Studio for 2005
likong - 17 Mar 2006 2:53 AM - 2 messages
Do not know if any one has complained this to Microsoft. SQL server management studio does not seem to display the "autostat" of an index correctly.  The value in SQL server management studio is always the reverse of the value from "sp_autostats". ...
Score SQL Server Management Studio error on connection
some guy - 17 Mar 2006 12:29 AM - 5 messages
Hi, Whenever I connect to a server, I get this error message: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'. This operation failed because the QueryInterface call on the COM component for the interface with ...
Score SQL Management Studio 2005
jimmyism - 16 Mar 2006 10:00 PM - 3 messages
Why does the rendering of SQL Management Studio 2005 take forever when my monitor runs in portrait mode?  If I rotate the monitor in landscape mode the tool responds and performs just fine.  The .NET 2003 and the ...
Score New Query with Current Connection
Bojan Kuhar - 16 Mar 2006 7:45 PM - 5 messages
I am missing "New Query with Current Connection" button in SQL Editor in the SQL management studio. Few posts on the Web refer explain that  this button should allow me to open a new query in the existing window. ...
Score SS05 Profiler questions
John A Grandy - 15 Mar 2006 10:06 PM - 4 messages
Why does SS05 Profiler create multiple .trc files?  Is this configurable? If sets of SPs are called to process items (item = row in a table) , is it possible to configure SS05 Profiler to estimate the time-to-process an item ...
Score Auto-refresh the output of the 'Open Table" action
Gaetan - 15 Mar 2006 9:43 PM - 4 messages
I checked the options in SQL 2005 Management Studio and it does not appear to be an available functionality. Is it possible to have the output of the "Open table" action to refresh the output at a specified interval? Thanks. ...
Score Move Database Store
de Graff - 15 Mar 2006 9:29 PM - 4 messages
We are replacing our drive arrays on our production SQL 2000 server. Can anyone please tell me what I have to do to relocate the entire store? Let's assume that I want to move everything from F:\SQLDATA to G:\SQLDATA. Can I ...
Score Empty Column ????
Jeff Mouland - 15 Mar 2006 6:50 PM - 2 messages
I am having some weird issues that I cannot figure out. - When I right click on a table using Enterprise Manager and return all rows I see data except that one column is showing nothing.  From in that window I do a IS NULL query verify that there is in fact data in ...
Score Where did View Taskpad go...
Roz - 15 Mar 2006 5:01 PM - 2 messages
Hello, all.  Running SQL 2005.  In SQL 2000, if I wanted to quickly see how much disk & log space I had available; I could simply right-click the database name in EM, then View...Taskpad.  The screen would quickly show me ...
Score trying to delete
rodchar - 15 Mar 2006 2:47 PM - 2 messages
hey all, i'm trying to delete a user from the users node in Enterprise Manager but i'm getting a message like this: --------------------------- Error --------------------------- The selected user cannot be dropped because the user owns objects. --------------------------- OK   --------------------------- What can i do to delete this user? ...
Score How Management Studio Express was developed?
Jassim Rahma - 15 Mar 2006 2:35 PM - 3 messages
hello, i was just thinking what language was used to develop the Management Studio Express? anybody knows? thanks... ...
Score Interface
Mervin Williams - 14 Mar 2006 11:51 PM - 2 messages
Does Sql Server have a DDE interface?  If so, where can I find documentation? Thanks in advance, Mervin Williams ...
Score Trouble connecting to remote db using the .NET data provider for Sql Server
acwomble - 14 Mar 2006 9:24 PM - 1 message
I am working with a database on another system via a ssh tunnel using plink. We have setup an alias the local system for the remote database. I am able to connect and work from within Visual Studio if I connect to ...
Score SMO
Lee - 14 Mar 2006 6:44 PM - 2 messages
Using SMO for .NET 2.0 how can I determine... If a stored procedure's parameter is Input only, or input/output? ...
Score Upgrading Database Diagrams to 2005
Kevin - 14 Mar 2006 5:38 PM - 4 messages
I upgraded from Sql Server 2K to 2005 and in the process upgraded the database diagrams.  When I view the upgraded database diagram the font size and row height of the tables have increased so the bottom 25% of the rows ...
Score SSMS 2005 Default DB in Solution Explorer when creating new query
SteelMillDon - 14 Mar 2006 10:07 AM - 7 messages
Hi, Every time I create a new query from the SSMS 2005 Solution Explorer it defaults to a DB that I was working on before. How do I change the default DB in the connection or for creating a new query? ...
Score PerfMon counters question
donsql22222 - 13 Mar 2006 10:04 PM - 1 message
What do these values mean? %Disk Time = 25049.64062. Is that in percent? This is on the physical drive that holds the MDF only. Ave Disk Queue length = 258. Is that in seconds? Also on the physical drive that holds the MDF. ...
Score Index Tuning Wizard Problem
Sabri AKIN - 13 Mar 2006 9:34 PM - 1 message
hi, when i run index tuning wizard after a few minute i take an error like "the server returned an error attempting to either create a temporary table or index statistics." i try to run wizard from trace file ,trace table and query analyzer but ...
Score Enterprise Mgr - alter table fails
stephanie.harrell - 13 Mar 2006 5:51 PM - 7 messages
My developers just started having this problem a few weeks ago.  Nearly any type of "design" table changes are failing in Enterprise Mgr.  This only seems to be happening on the servers running Enterprise Edition. Standard Edition and MSDE do not have the problem. ...
Score SQL 2005 Target Server Connection vs. Local Server Connection
bwalke - 13 Mar 2006 5:23 PM - 4 messages
I am creating Maintenance Plans in SQL Server 2005 and I was wondering what the difference is between Target Server Connection and Local Server Connection.  I know this may be an unnecessary question but I was looking for a explanation of them, more less the target server. ...
Score SQL Enterprise Manager
pradeep_raina@hotmail.com - 13 Mar 2006 2:22 PM - 4 messages
Hi, I just recently moved to a different floor in the same building but my SQL Query analyzer and Enterprise Manager have become lot slower. Thouh I can query using Query Analyzer but Enterprise Manager completely freezes. I talked to database administrator and he is saying things are fine at ...
Score Templates in Management Studio
Klaus Aschenbrenner - 13 Mar 2006 8:35 AM - 7 messages
Hi there! As far as I have seen you can define your own T-SQL templates in Management Studio. But the question is: where are these templates stored? Because what is when you are working in a team and you want to distribute ...
Score XML/XSD Tools
S. Mark Brown - 12 Mar 2006 3:36 AM - 2 messages
Looking for tools to manage XML/XSD with SQL 2005; specifically import/export schemas to & from SQL TIA Mark ...
Next »