|
Database Corruption
Hello,
I have a problem with database corruption. In the database there several
thousand parts and a few hundred partlists, the partlists are becoming
corrupt when closed after editing, not all of them, it happens maybe 1 in
100 list edits. One line disappears from the list and then the client cannot
call the ...
Thu, 30 Sep 2004 09:21:03 +0200
|
Error 87 from GetProxyAccount on line 604
I am trying to set up a regular SQL login which is NOT a
sysadmin with the ability to run xp_cmdshell. It's not
the best idea, but I have no choice. I granted it
execute permissions on the proc and used
xp_sqlagent_proxy_account to point to a login which is a
local admin on the server. Whenever I try t ...
Wed, 29 Sep 2004 08:13:22 -0700
|
Changing DBO
Have you sorted it as yet
>-----Original Message-----
>
>I have assigned an SQL account as DBO of a database. I
>am going to change the DBO to a Windows login account.
>When I run the sp_changedbowner stored procedure, will
>change the owner of the objects created by the SQL
>account? The table obje ...
Wed, 29 Sep 2004 07:29:13 -0700
|
Resetting DTS password
Hi all,
can anybody please how to reset passwords for an DTS? I need to edit and run
it...but the former DBA left without giving us the passwords...
Thanks,
Tudor
...
Wed, 29 Sep 2004 13:47:18 +0200
|
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
have SQL Server 2000 Enterprise Manager installed on XP box. I want to
connect to SQL Server 2000, using trusted connection. I have required
permisiions, but I receive this error message:
Connection failed:
SQLState: '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server] Login fail ...
Wed, 29 Sep 2004 12:23:08 +0200
|
Login failed for user '(null)'
I have SQL Server 2000 Enterprise Manager installed on XP box. I want to
connect to SQL Server 2000, using trusted connection. I have required
permisiions, but I receive this error message:
Connection failed:
SQLState: '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server] Login fai ...
Wed, 29 Sep 2004 12:13:17 +0200
|
ASP Security Issue
Use windows authentication of ASp and sql server 's SSPI
to get in to the database and then you can even opt for
the impersonation ... also in that case get the username
and password from the registry ;) ... i know i replied in
abstraction .... hope you can understand what i
mean .......
well as far as t ...
Wed, 29 Sep 2004 01:57:20 -0700
|
can I send the audit file to a table?
Hi,
I have "C2 audit mode"=1, is it possible to send the trace files to a
table?, how can I do it ? ...
Tue, 28 Sep 2004 13:13:06 -0700
|
xp_cmdshell
How can I check who has permissions to the xp_cmdshell stored procedure?
Thanks
Marcos ...
28 Sep 2004 11:04:07 -0700
|
Changing DBO
I have assigned an SQL account as DBO of a database. I
am going to change the DBO to a Windows login account.
When I run the sp_changedbowner stored procedure, will
change the owner of the objects created by the SQL
account? The table objects have the SQL account as the
owner. If not, will I have to ...
Tue, 28 Sep 2004 09:47:22 -0700
|
Looking for a script to audit user table rights
Hello everyone,
Does anyone know of a quick way to audit all users in a
database and display their rights and permissions on a
table level. I would hate to have to do it one user at a
time. There has to be an easier way.
I'm going through a Sarbanes Oxley audit and need to
provide them this informati ...
Tue, 28 Sep 2004 08:10:33 -0700
|
Force Protocol Encryption - Please help!
Hi, I just recently set up a SQL 2000 server and have a question about
the "Force Protocol Encryption" setting... can someone please help me!
I installed my SQL server on a standalone W2K server which is NOT a
member of a domain. I want to ensure that all connections to the SQL
server are encrypted, so I ena ...
Tue, 28 Sep 2004 07:51:29 -0700
|
Domain Users
Hi,
Can I create Sql Server Logins from an different Nt
Domain??
thank ...
Tue, 28 Sep 2004 01:57:58 -0700
|
SQL Server 2000 on Win 2003 and DTC
We have an env. with a distributed COM+ application on a
Win2003 server and a SQL Server 2000 on a Win 2003 server,
connecting through ODBC.
In this env. we always get "Failed to enlist Distributed
transaction..." ODBC error, when doing a transaction in
COM+. If we switch the ODBC to point towards an SQL ...
Tue, 28 Sep 2004 00:25:36 -0700
|
Password does not work on SQL Server 2000
The sa password no longer works on my SQL 2000 server. I
am positive I know the password, but it does not work.
Windows authentication does not work either. I am unable
to backup or update my data. HELP! ...
Mon, 27 Sep 2004 11:05:56 -0700
|