Saturday, 22 July 2006
|
| Question on QUOTED_IDENTIFIER John 17:48:43 |
| | I have a very strange problem, it only happen to one SQL Server, other
SQL Server seems to be fine
I got the following error when trying to run a sp against one of the
SQL Server:
SELECT failed because the following SET options have incorrect
settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for
use with indexed views and/or indexes on computed columns and/or query
notifications and/or xml data type methods.
If I put the SET QUOTED_IDENTIFIER OFF In the beginning of the sp,
everything works fine, but the questions is why should I do that? and
why it only happen to only one SQLServer ? The database option on
QUOTED_IDENTIFIER are off on all SQLServer. (I am using SQL2005)
Thanks in advance.
John
Enclose is the statement that create the database
if db_id('testdb') is not null
drop database [testdb]
go
begin
USE [master]
CREATE DATABASE [testdb] ON PRIMARY
( NAME = N'testdb',
FILENAME = N'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\testdb.mdf' ,
SIZE = 8192KB ,
MAXSIZE = UNLIMITED,
FILEGROWTH = 1024KB )
LOG ON
( NAME = N'testdb_log',
FILENAME = N'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\testdb_log.ldf' ,
SIZE = 29504KB ,
MAXSIZE = 2048GB ,
FILEGROWTH = 10%)
COLLATE SQL_Latin1_General_CP1_CI_AS
EXEC dbo.sp_dbcmptlevel @dbname=N'testdb',
@new_cmptlevel=90
ALTER DATABASE [testdb] SET ANSI_NULL_DEFAULT OFF
ALTER DATABASE [testdb] SET ANSI_NULLS OFF
ALTER DATABASE [testdb] SET ANSI_PADDING OFF
ALTER DATABASE [testdb] SET ANSI_WARNINGS OFF
ALTER DATABASE [testdb] SET ARITHABORT OFF
ALTER DATABASE [testdb] SET AUTO_CLOSE OFF
ALTER DATABASE [testdb] SET AUTO_CREATE_STATISTICS ON
ALTER DATABASE [testdb] SET AUTO_SHRINK OFF
ALTER DATABASE [testdb] SET AUTO_UPDATE_STATISTICS ON
ALTER DATABASE [testdb] SET CURSOR_CLOSE_ON_COMMIT OFF
ALTER DATABASE [testdb] SET CURSOR_DEFAULT GLOBAL
ALTER DATABASE [testdb] SET CONCAT_NULL_YIELDS_NULL OFF
ALTER DATABASE [testdb] SET NUMERIC_ROUNDABORT OFF
ALTER DATABASE [testdb] SET QUOTED_IDENTIFIER OFF
ALTER DATABASE [testdb] SET RECURSIVE_TRIGGERS OFF
ALTER DATABASE [testdb] SET ENABLE_BROKER
ALTER DATABASE [testdb]
SET
AUTO_UPDATE_STATISTICS_ASYNC ON
ALTER DATABASE [testdb]
SET
DATE_CORRELATION_OPTIMIZATION OFF
ALTER DATABASE [testdb] SET TRUSTWORTHY OFF
ALTER DATABASE [testdb] SET ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE [testdb] SET PARAMETERIZATION SIMPLE
ALTER DATABASE [testdb] SET READ_WRITE
ALTER DATABASE [testdb] SET RECOVERY FULL
ALTER DATABASE [testdb] SET MULTI_USER
ALTER DATABASE [testdb] SET PAGE_VERIFY CHECKSUM
ALTER DATABASE [testdb] SET DB_CHAINING OFF
end
|
| |  4 answer | Add comment |
|
| Recreating/reloading system stored procedures Byrocat 01:57:24 |
| | A system stored procedure got accidentally deleted, and all backups are
since the stored procedure was deleted (wonderful!)
Can the SQL for the stored procedure be extracted from another server
and loaded as opposed to removing everything and then rebuilding the
server?
Thanks in advance!
|
| | 1 answer | Add comment |
Friday, 21 July 2006
|
| Left Join Problem Ryan 23:15:53 |
| | I'm going daft. I have what should be a simple query and it seems that
the left side of the join is being ignored. The query and DDL are
below. Basically, my RDOData_Extract_Lines table (where LineNum NOT
LIKE 'LAN%') on it's own gives me 959 records. If I look at the
RDOData_Extract table (with the dealer code = 8494) it shows 521
records. Using the query below and specifically a left join it 'should'
show me 959 records, but only show data for 521 of them. However, it
shows me 521 records. What have I done wrong ?
Thanks
Ryan
SELECT
L.LineDesc,
D.*
FROM
RDOData_Extract_Lines L
LEFT JOIN RDOData_Extract D
ON L.LineNum = D.Line_No
WHERE
L.LineNum NOT LIKE 'LAN%' AND
D.Dealer_Code = 8494
CREATE TABLE [RDOData_Extract] (
[Dealer_Code] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[FranDealerCode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Line_No] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Current] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[YTD] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[12Months] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[24Months] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Average_YTD] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Average12months] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Average24Months] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Last_YTD] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Current_Status] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[PD1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD4] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD5] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD6] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD7] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD8] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD9] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD10] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD11] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD12] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD13] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD14] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD15] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD16] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD17] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD18] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD19] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD20] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD21] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD22] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD23] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD24] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD25] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD26] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD27] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD28] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD29] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD30] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD31] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD32] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD33] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD34] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD35] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PD36] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SortOrder] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [RDOData_Extract_Lines] (
[DeptId] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DeptDesc] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LineNum] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LineDesc] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SortOrder1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[SortOrder2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
|
| | 6 answers | Add comment |
|
| SQL Server 2005 Script Generation Guest 19:44:20 |
| | I recently generated a script using SQL Server 2005 for a local
database that is configured as SQL Server 2000. Nevertheless, the
script used the new structures and syntax (i.e., sys.objects vs.
sysobjects). Is there a way that I can force SQL Server 2005 to use
the old 2000 syntax? I notice that when I script objects on a remote
SQL Server 2000 machine, it does use the old syntax.
Bill E.
|
| | 11 answers | Add comment |
|
| Newcomer to the whole milieu Hatcat 07:59:46 |
| | Hello. I hope someone can help me here.
I work for a game company, and we have decided to drag ourselves
kicking and screaming into the 21st century by creating all our data in
a database. Since I have a little Access experience, I have been
nominated to Sort This Out. So, what I need to do is construct a
system of work whereby a database on our server (running SQL Server for
Team Foundation Server if that's relevant) can be queried and updated
from Access clients on the LAN.
To do this, I guess I need to know how to create a database, tables
within it, grant privileges for reading and writing, and export the
tables to another format. I can do nearly all of this in Access with a
local database - how different is it on a server?
Kind regards, and thanks in advance,
Guy Davidson.
|
| | 2 answer | Add comment |
|
| quicker way to create indexes Shelleybobelly 06:41:07 |
| | Hi,
I have a new job. It needs to drop and re-create (by insert) a table
every night. The table contains approximately 3,000,000 (and growing)
records. The insert is fine, runs in 2 minutes. The problem is that
when I create the indexes on the table, it is taking 15-20 minutes.
There is one clustered index and 11 non-clustered. This is a lookup
table that takes many different paremeters, so it really needs the
indexes for the user interface to run efficiently. However, the
database owners aren't keen on a job taking 20 minutes to run every
night.
Any ideas?
|
| | 5 answers | Add comment |
|
| ms sql 2005 HandersonVA 01:32:20 |
| | somehow i cannot migrate the database from ms sql 2000 to 2005, i
recreated the same database name and exported the data from 2000 to
2005. THen what happend was all the default values that i set on
tables are not transferred and stored procedures are not transferred.
how can i duplicate the same database in sql 2000 to sql2005 w/o
loosing anything?
|
| | 1 answer | Add comment |
|
| Reduce Table Size without deleting data iamset via SQLMonster.com 01:16:29 |
| | We are using SQL Server 2000 Standard ed, sp4 on Server 2000 Advanced.
We have one table that is three times as large as the rest of the database.
Most of the data is static after approximately 3-6 months, but we are
required to keep it for 8 years. I would like to archive this table (A), but
there are complications.
1. the only way to access the data is through the application (they are
images produced by the application-built on Power-Builder)
2. there are multiple tables refrencing this table and vise-versa
3. we restore the entire db to two other servers for testing and training
regularly
4. there might be more complications that have not been thought of
Currently, our only plan is to setup a seperate server with a copy of this db
on it and the application. Leave only the tables necessary to access the data,
and if this 'archive' works, remove from production the data from the table A
and all references to the table A from rows on the other tables.
I mentioned #3 because someone mentioned a third party tool that may be able
to pull the data from the table, archive it elsewhere, and at the same time,
place a 'pointer' in the table to the new storage location. The tool they
mentioned only works on Oracle and we have not explored beyond that yet.
I am ready to explore ideas and suggestions; I am still new to the DBA world,
I am out of ideas.
Thank you!
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200607/1
|
| | 1 answer | Add comment |
|
| SQL Generator Bit Byter 01:14:34 |
| | Hi,
This may be a little OT, but I don't know exactly where else to post
it. I am writing a little parser that generates valid SQL using
"English like" text. I want to use this to allow non-technical users to
be able to quickly write their own queries, to search through a
database that stores information about the sales of different
companies. I can provide more information for anyone who wants to help.
Currently, the syntax is :
Select ALL PRODUCT_FILTER from COMPANY where funcname(params) conditon
... and ITEM_DATE date_condition
Where:
product_filter specifies the product type to be included in the search
company specifies the company whose data is to be searched
funcname is an aggregate function
condition specifies the criteria for the aggregate function (i.e. a
HAVING clause)
date_condition specifies the criteria for the dates to be used in the
search
Note: there can be more than 1 aggregate function
A typical query then may look like this:
Select all 'toys' from 'Walmart' where average_sales(100) > 100000 and
avaerage_cost(100,10) <= 1 and item_date between "01-Jan-00" and
"01-Jan-06"
I would like to know what the underlying SQL statement will look like,
so that I can use this knowlege to build a generic parser that creates
SQL statements from the "English like" text, using the syntax I
described above.
|
| | 1 answer | Add comment |
|
| Scripting table with rows values Guest 01:11:04 |
| | Hi
Is there any way to script a table (with EM or Management studio) along
with data contained in the table (rows values)?
J
|
| | 1 answer | Add comment |
|
| 2005 Express Edition: installing full-text search Ram 01:07:19 |
| | Hello,
I have installed SQL Server 2005 Express Edition Advanced Services and
SQL Server 2005 Express Edition Toolkit SP1. I cannot use full-text
search. When I called:
exec sp_fulltext_service 'load_os_resources', 1;
exec sp_fulltext_service 'verify_signature', 0;
go
I got error:
Full-Text Search is not installed, or a full-text component cannot be
loaded.
What should I do to be able to use full text search? Could you help me
please? I cannot find solution in Internet...
/RAM/
|
| | 1 answer | Add comment |
Thursday, 20 July 2006
|
| Re: Replicatoin for user defind functions Tolcis 22:30:26 |
| | Hi!
My user defined functions have permissions setup on a primary server.
Two users are allowed certain access. When I am replication the whole
database to another server those permissions are not being replicated
(despite of the fact that those users are defined on a destination
server).
If I go to a destination server (subscriber) and set permissions
manually(the way they are in production) - those permissions will
disappear once the replication is completed.
Thanks,
tolcis
|
| | Add comment |
|
| Free web based MS SQL management app Brian D 21:16:04 |
| | Is there a free web based app available to manage a MS SQL. I am not
looking to manage the server itself, just the DB. Basically something
similar to phpMyAdmin (http://www.phpmyadmin.net).
Thanks.
Brian
|
| | 1 answer | Add comment |
|
| DTS export to Excel Sbarrow 19:41:55 |
| |
I'm attempting to export data to a dynamically named excel file
everyday. For the most part it all is working well other than when the
DTS package runs as a package it inserts an empty row (Row 2) in the
excel file. If I run each task individually in the same order the DTS
runs it then there is no empty rows. Can anyone please help?
Thanks
Seth
--
sbarrow
------------------------------------------------------------------------
sbarrow's Profile: http://www.dbtalk.net/m556
View this thread: http://www.dbtalk.net/t320450
|
| | Add comment |
|
| Updating text containing ж,ш or е Hansen 17:31:54 |
| | Hi,
I'm making a translation thingie, that contains several languages. One of
them is Danish and in one of my update scripts, I've come upon something
strange.
I have a text containing the letter "е" which is a special Danish letter
(along with ш and ж). When I create the data base and inserts the default
data everything is fine. But if I use an update script like:
UPDATE [dbo].[TextControlLanguage]
SET [Text] = 'Skabelonen er mеske ikke gemt. Vil du gemme den?'
WHERE TextControlID = 1217
AND LanguageID = 1
the "е" in "mеske" gets lost. Do I have to some alpha nummeric code?
How come that when inserting the default data everything is fine, but when
updating the "е" is removed?
/Hansen
|
| | 1 answer | Add comment |
|
| select no. of rows from the current database Ssingh 17:17:40 |
| | Hello,
I want to select the names and number of rows of all tables in the
current database, whose name starts with 'sys'
my query is:
select o.[name], sum(i.[rows]) as numbers
from sysobjects o
inner join sysindexes i
on (o.[id] = i.[id])
where o.[name] like 'sys%'and i.indid=1
group by o.[name]
the result of the query is (depending of the database) :
name numbers
sysaltfiles 14
syscharsets 114
syscolumns 4934
syscomments 2035
sysconfigures 38
sysdatabases 7
sysdepends 5524
sysdevices 6
sysfilegroups 1
sysfulltextcatalogs 0
sysfulltextnotify 0
sysindexes 98
syslanguages 33
sysmessages 3795
sysobjects 1285
syspermissions 806
sysproperties 0
sysreferences 0
sysservers 1
systypes 26
sysusers 14
sysxlogins 3
But when I count the number of rows of "sysobjects", I get
numbers=1298, which is different from the result displayed above and
same goes for "syscolumns".
I also tried "dbcc updateusage [0]" to update the SQL Server but I
didnt help me.
Can anyone please advice me on this behaviour?
|
| | 2 answer | Add comment |
|
| query to populate child table Guest 13:22:59 |
| |
hi all, can anyone help me?
I am a relative newbie to sql server and I am more familiar with
Enterprise Manager than QA. I have made many many access databases
though. I am making an asp.net application where by there are a set
number of users, about 80, each one logs in and manages information
within their department.
To get them started a manager has written 10 different hazards that
will apply to all of the departments, and he has written consequences
and controls for the hazards. Each department must have this
information as each will manage and deal with them differently
The hazard information is stored in a main 'hazards' table, and the
consequences and controls are stored in related tables linked by the
'hazardID' from the main table to a foreign key 'hazardID' in the
related tables
What i want to know is if there is a relatively simple way of using a
query to populate the 10 hazards to each department, and to also
include the related table links, i dont mind renaming the departments
names to match each hazard, but i do not want to have to relink the
related tables manually
If anyone can give me any advice to get me started i will be incredibly
grateful
thank you
Table information is below
Hazards
------------
HazardID - identity key field
Hazard - varchar
Department - varchar
Consequences
----------------------
ConsequenceID - identity key field
HazardID - FK
Consequence - varchar
Controls
------------
ControlID - identity key field
HazardID - FK
Control - varchar
dwight
|
| | 3 answer | Add comment |
|
| Text Import Finding Table to Import to Problem Guest 11:38:27 |
| | Dear All,
I'm trying to import a quite large text file (25mb) I had this working
fine by using the transfertext command and having a schema.ini file,
however having changed the username and password for my connection to
SQL server all my tables and queries come with dbo attatched, which is
fine as I've now edited all the relevent code and macros.
However, on the transfer text command, it doesn't recognise the table I
want to import into, it says it can't find it.
I've edited it to put dbo.tablename and I've tried importing the file
through the menu and selecting the table from the list using the wizard
and it still can't find the table to import to.
Any ideas?
Matthew
|
| | Add comment |
|
| Exporting data from SQL 2005 to Access Bisjom 11:00:52 |
| |
Hi Guys,
I was trying to export the database from 2005 sql to access.
But it shows error
Setting Destination Connection (Error)
Messages
Error 0xc0204016: DTS.Pipeline: The "output column "ReplyText" (961)"
has a length that is not valid. The length must be between 0 and 4000.
(SQL Server Import and Export Wizard)
Exception from HRESULT: 0xC0204016
(Microsoft.SqlServer.DTSPipelineWrap)
I tried to change the size of the Reply text from varchar(500) to
varchar(50) and again it shows the message.
any idea?
thanks
Bismi
--
bisjom
------------------------------------------------------------------------
bisjom's Profile: http://www.dbtalk.net/m552
View this thread: http://www.dbtalk.net/t320367
|
| | Add comment |
|
| Second Transaction Log File Laststubborn 01:30:51 |
| | Hi All,
I have a dillema that I created 2 transaction file before I started to
take log back. Now I changed my recovery model from simple to full. Do
I still need to keep my second transaction file? If I remove it would
it be a problem for my system and log back up?
If somebody responds me I really appreciate it
Regards
|
| | 5 answers | Add comment |
|
| URGENT - Link server 2005 to 2000 Nasir 01:07:49 |
| | I've a database in 2000 which needs to be accessed from 2005 via linked
server. I've tried the GUI options and it is failing. One thins is that our
both servers have hyphen('-' not underscore, could that be a problem) in the
names, like 2k-srv and 2k5-srv as hosts, but the instances are default.
Can anyone give me the steps please.
TIA
Nasir
|
| | 4 answer | Add comment |
Wednesday, 19 July 2006
|
| Delete 2005 [user] schema? Will 23:59:46 |
| | TITLE: Microsoft SQL Server Management Studio
The database principal owns a schema in the database, and cannot be
dropped. (Microsoft SQL Server, Error: 15138)
I have an installer that is supposed to "clean up" the DB server before
an install. The installer checks for like object names and attempts to
clean house. All this is done via WMI objects. I have not been able to
find how to do this particular task with WMI - delete user schemas
prior to deleting users. Using management studio is easy and gets me
around the issue for testing but I need to do it programticaly - the
equilvilant of DROP SCHEMA [name]. Thanks!
-Will
|
| | Add comment |
|
| How to send an automated email when SQL Server 2000 is shutdown... Jags 32 23:38:16 |
| | We are trying to automate notification by email when a SQL Server goes
down, no matter how the Alert is configured, it does not seem to work.
We do see the message in the event log but the alert is never invoked.
Appreciate any help / feedback.
Thanks
Jagannathan Santhanam
|
| | Add comment |
|
| not permitted in this context Kivak 15:10:10 |
| | Hi,
I am having a SQL Server 2005 problem with my Insert statement. I am
sending a command via my website to my database. It comes up with an
error I'll put below. The code is here:
"INSERT INTO tblUsers (userName) VALUES ( userNameTest)"
This is the error I get:
The name "userNameTest" is not permitted in this context. Valid
expressions are constants, constant expressions, and (in some contexts)
variables. Column names are not permitted.
Now, userName is a varchar field in the database. What is wrong?
Kivak
|
| | 2 answer | Add comment |
|
| Terminal Service Manager Msg 01:10:11 |
| | I opened up Terminal Service Manager on my SQL Server to close out some
ghost connections. Then I minimized the application. After working on
some other issues. I right clicked on the minimized icon of Terminal
Service Manager on my tool bar and closed it. Now when I go to
Start/Admin Tools/Terminal Service Manager, it opens up minimized and I
can't get it to maximize to close out ghost connections. The only way
I can close it is to go to the task manager and kill it from there.
I've rebooted my server and I still have this problem when I open
Terminal Service Manager. Does anyone have a solution for this?
|
| | 2 answer | Add comment |
|
