Home All Groups Group Topic Archive Search About

SQL Server Tools

microsoft.public.sqlserver.tools
Score How to type a multiline text in a column?
Catalin NASTAC - 10 Mar 2006 2:20 PM - 4 messages
I can't find how to enter a multiline text in a row... I use SQL Server Management Studio, Table >> Open Table. I have a text column (varchar) and I want to type some text containing CRLF. I alos tried ...
Score Use of SQL Server 2005 Mgmt Studio on a SQL Server 2000??
Jim Moon - 9 Mar 2006 8:48 PM - 5 messages
In this message [link] a Mr. Cheng states, "We cannot use SQL Server Management Stuido to connect ...
Score BECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K.
ISRAEL FAGBEMI - 9 Mar 2006 8:45 PM - 1 message
...
Score xp_smtp_sendmail and Outlook Express works; Database Mail doesn't
Aaron M. Lowe - 9 Mar 2006 3:07 PM - 2 messages
xp_smtp_sendmail and Outlook Express works; Database Mail doesn't Hello, I recently upgrade a SQL 2000 SP4 EE running on Windows 2003 AS to SQL 2005 EE. I was using xp_smtp_sendmail on SQL 2000 through an Exchange server successfully. However after the upgrade I am unable to send SMTP mail ...
Score Checkpoint causes need for better IO subsystem?
donsql22222 - 8 Mar 2006 12:51 AM - 9 messages
Using Profiler and PerfMon, when there is a checkpoint, the durations of INSERTS and SELECTS increase to approx 5000ms ... up from 15-30M...which causes distress for clients and needs to be fixed. Note that not ALL of the INSERTS and SELECTS are afffected..perhaps during ...
Score Installing SQL Srv 2005 commandline utilities.
me - 7 Mar 2006 8:00 PM - 5 messages
I'm being asked to "install" SQL Server 2005 "client tools" on high performance compute (HPC) nodes for researchers who use SQL. the 2005 client is a bit heavy on disk space, etc, etc. and I'm looking for info on how to ...
Score Sql Server 2005 How to ?
Bragadiru - 7 Mar 2006 4:39 PM - 4 messages
Hi, I want to check the connections opened to an instance of Sql Server 2005; who, when, eventually the connection string. I have an application without sources that connects to a database and I suspect it leaves the connections unclosed, until maximum pool size is reached. How to enumerate through ...
Score Permissions needed to Create Assembly
Chris Wood - 7 Mar 2006 4:09 PM - 6 messages
Hi, I am having difficulties in creating an assembly in a user database. I am using an SQL login that is a db_owner of a database. The assembly has PERMISSION_SET = EXTERNAL_ACCESS. The first attempt gave these 2 messages:- Error 1:  Msg 6585, Level 16, State 1, Line 2 ...
Score Sql 2000 Maintenance Plan not deleting old transaction logs
Chris Newby - 7 Mar 2006 3:39 PM - 3 messages
I created a maintenance plan using enterprise manager 8 for a sql server 2000 database. In regards to the transaction log, the maintenance plan is configured to:     - backup the transaction log     - verify the backup's integrity ...
Score We Pay 50%--100% Returns Monthly For 1 yearr on investment. You need to know this!
INCOME---DAILY - 7 Mar 2006 2:53 AM - 1 message
...
Score Securables for Application Role in Management Studio do not stick
Joginder Nahil - 6 Mar 2006 7:53 PM - 4 messages
Securables for Application and Database Roles do not show after they have been setup. I do the following:   1.. Select an Application Role from Database -> Security -> Roles - Application Roles and select Properties from the context menu   2.. Select Securables page ...
Score only test- solo test
toñooo - 5 Mar 2006 11:42 AM - 1 message
<HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>&nbsp;</P> </BODY> </HTML> ...
Next »