|
SQL Server Agent Error Log
Hi,
I received this message:
[LOG] Unable to read local eventlog (reason: The handle is
invalid)
Can someone tell me what this means? Where is the
eventlog located?
Cheers,
Marc ...
Wed, 29 Sep 2004 08:09:25 -0700
|
Strange behaviour in Query Analyzer
Hello,
I'm encountering a strange behaviour in SQL Server 2000 Query Analyzer. When
trying to open the stored procedure, the Analyzer fails to fetch the
procedure parameters - they remain blank. When I put the same procedure to
another database, everything works fine.
I ran the Profiler to see what's going o ...
Wed, 29 Sep 2004 15:40:03 +0200
|
Error in Query Analyzer in Grid mode
tested on ISQLW.EXE build 2000.80.760.0 (from MSSQL2000 SP3a):
SELECT
CHAR(1)+'a' AS Col1,
NULL AS Col2
in Text mode all OK:
Col1 Col2
---- -----------
a NULL
But in Grid Mode (Ctrl+D):
Col1 Col2
---- -----------
a
Is CHAR(1) Query Analyzer internal flag ?
RADl0P ...
Wed, 29 Sep 2004 15:21:13 +0200
|
Append (?) query
I'm trying to join 8 views (ViewA, ViewB, etc...) together
into one new table. All the views have 3 columns (ID,
result1, result2), as does the destination table. I'm
currently trying this method -
SELECT * INTO [dbo].[ANewTable] FROM [dbo].[ViewA]
SELECT * INTO [dbo].[ANewTable] FROM [dbo].[ViewB]
... ...
Wed, 29 Sep 2004 02:43:49 -0700
|
set options for SEM DTS import wizard
sql-svr 2000, sp3, wxp pro sp1
When running SQL Enterprise Manager Import Data wizard (importing from
text-file) , how do I ensure that the SEM's connection to the SQL-Server
database has the following options set
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
SET ARITHABORT ON
SET ANSI_NULL ...
Tue, 28 Sep 2004 21:27:35 -0700
|
Maintenance Plan
hello everybody
Our Production DB is growing around 25 MB per day , is it necessary to have
a maintenance plan for our production database. If it is necessary than how
frequent it should be done & what we needs to included in that maintenance
plan. Can somebody provide me a maintenance plan.
regards
...
Wed, 29 Sep 2004 08:55:41 +0530
|
Assistance with error message
I am trying to run this script in Query Analyser and it seems to have a
problem in line 3:
----------------------------------------------------------------------------
-
select ID, 9, '2004', (select id from type where type = 'MF') from Dept
where dept in ('Internal Medicine', 'Surgery')
and ID + (selec ...
Tue, 28 Sep 2004 16:24:47 -0500
|
Profiler - effect on SQL performance
I'm interested to discover the effect of running SQL Profiler - all day - on
a production server (SQL7 Standard). One of our clients insists on doing
this and claim that there are no performance issues (the profiler is running
on a client workstation). Obviously there is some effect from writing to the
history ...
Tue, 28 Sep 2004 15:13:30 +0100
|
Tool for converting collations
Hi,
I tried to convert my Database running on SQL2000 from
Latin1_General_CI_AS
to SQL_Latin1_General_CP1_CI_AS
using REBUILDM
Now I don't want to use ALTER TABLE for all my 40 tables.
Is there a tool on the market which can do it?
regards
R. ...
28 Sep 2004 10:09:56 GMT
|
System Database Backups
Hello everybody
How frequently we need to take the backup of our MSDB , MODEL , MASTER
databases. We have recently switched to simple recovery model from Full for
some of our databases . And we never took transaction log backup for these
databases. As a result (which i presume ) the huge ldf files have develo ...
Mon, 27 Sep 2004 19:14:18 +0530
|
SQL 2000 Recovery Model
Hello Everybody
I need to know the full recovery model for a DB. As mentioned in bol that
full recover model provides recovery to the point of failure.
Currently we are backing up our db 4 times in a day with simple recovery.
If we shift to full recovery model then what else needs to be done beside
taking ...
Mon, 27 Sep 2004 17:52:08 +0530
|
problem with restore
hi,
i am trying to resore a database on sql --the back up of
which was taken in sql 2000
and i am getting the following error
[SQL-DMO] must be a part of sa, sysadmin or.........group
to complete this operation
i have given the server nt authentication and i am logged
in to the account with sys admi ...
Sat, 25 Sep 2004 11:59:44 -0700
|
Bunjee Love
Pictures of me and my girlfriend having sex at the end of a Bunjee Rope 100 meters off a bridge in Scotland
http://bunjeelove.fsckme.net/BunjeeLove.zip
...
Sat, 25 Sep 2004 16:06:45 GMT
|
Bunjee Love
Pictures of me and my girlfriend having sex at the end of a Bunjee Rope 100 meters off a bridge in Scotland
http://bunjeelove.fsckme.net/BunjeeLove.zip
...
Sat, 25 Sep 2004 16:02:30 GMT
|
SQL Query Analyzer Hotfix for Not-responding
Is there a valid or, dare I say, logical reason as to why
the hotfix for Query Analyzer's little Not-Responding
problem is carefully guarded by a $99 Support Fee? I hate
to say it but I won't give my company credit card number
to Microsoft just to access a fix they acknowledge is a
problem. Put it somew ...
Fri, 24 Sep 2004 12:19:21 -0700
|