|
Doubling up security on SQL Server system administrator
Hi All
Always baffled me this, but although I can set up complex SQL usernames and
passwords for my SQL database the main system administrator login details
only give me half the security because the username is always 'sa'. I can
only set a complex password for the most powerful user of them all.
This ...
Tue, 11 Jan 2005 13:05:21 -0000
|
How to convert the SQL Developer Edition to SQL Standard Edition?
I am reaching the db limit in Developer Edition 2000.
So I would like to convert it to SQL Standard Edition 2000 with no change of
my existing setting. I don't want to re-install and I want to keep the server
name, DTS, Analysis services, and mulitple instant of SQL server.
Is there any way to overcome the ...
Tue, 11 Jan 2005 05:01:03 -0800
|
failure of installing analysis services
"An error occured during the move data process: -145"
What does it mean & how do i solve it ?
...
Tue, 11 Jan 2005 12:31:34 +0200
|
cannot load dll xpstar.dll reason 126
cannot load dll xpstar.dll reason 126
Hi
This error message happens when trying to restore/backup a database
(The file exists in the binn directory)
How do I solve it ?
thanks in advance
Romy
...
Tue, 11 Jan 2005 12:03:43 +0200
|
Install SQL Server Developer Edition
Hello Lori,
I noticed the following error message in the error log:
======
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=OFFICE1\DEV_OFFICE;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data sou ...
Tue, 11 Jan 2005 09:49:40 GMT
|
Enterprise manager activity timeout
Is there a way to keep SQL Enterprise manager from prompting me about
activity timeouts and conserving resources while I'm programming? I often
have a half dozen tables open simultaneously while programming and I go back
and forth between looking at data and writing code. But every few minutes
Enterprise Manage ...
Mon, 10 Jan 2005 19:22:21 -0800
|
Move Logs to Another Drive
Does anyone know how to move SQL logs to a different Drive in SQL2000.
When I try to do it, I get an error message saying you are unable to move a
log after a database has been created.
I would like to seperate the logs and the Database for redundancy
Thanks ...
Mon, 10 Jan 2005 14:53:04 -0800
|
Peoblwm with Query
I have a query from access that I am trying to make a view in SQL server.
For the life of me I can not figure out what I need to change to make it
compatible with SQL.
Here is the query in access. Can anyone help me with the equivalent view in
SQL Server??
Thanks in advance
Laura K
SELECT tblProd ...
Mon, 10 Jan 2005 14:19:16 -0800
|
Installing SQL with Limited Rights
Hi,
I have a developer who would like to install SQL on a
server. She has very limited rights on the server and I
do not want to have to grant her and her co-workers admin
rights to the server. Since it is so infrequent that you
ever have to install SQL server we make them come down to
the data cen ...
Mon, 10 Jan 2005 11:16:00 -0800
|
Install SQL Server Developer Edition
I am attempting to install SQL Server Developer Edition on a Windows XP
machine.
I am installing it remotely using Remote Assistance
I get this error:
Setup failed to configure the server. Refer to the server error logs and
C:\WINDOWS\sqlstp.log for more information.
Here is the contents of the log. ...
Mon, 10 Jan 2005 11:01:03 -0800
|
SQL Server Access via web site
I am trying to setup a web hosting firm that also offers SQL server as its
back end and none of the consultants have been able to tell me how to give
access to the databases via a web site for my clients who are going to
customize and build their database as they wish. How can I provide this
access to their ...
Mon, 10 Jan 2005 10:13:02 -0800
|
Restored All Database Except the Master
Hi there,
Yesterday we built a new SQL server 2000 SP3, we restored all company
database using our b-up software. We tested them and our apps seems to work
fine against the newly built SQL server.
Question that is burning my head is: we restored everything except the
MASTER, MODEL, MSDB and PUBS. It was a ...
Mon, 10 Jan 2005 13:00:47 -0500
|
Upgrade NT 4.0 to 2000 Server Upgrade: SQL affected?
Hi all,
I'm planning on upgrading a NT 4.0 SQL Server to Windows 2000 Server. Will
this have any affect on the SQL DB residing on this server? Thanks in
advance.
P ...
Mon, 10 Jan 2005 06:41:15 -0800
|
SNMP Not Working
Hi,
I have had a search through this forum for help on getting SNMP working but
haven't found anything that helps me.
I have just started monitoring servers using SNMP so didn't have the SNMP
service installed BEFORE SQL2000 went on any of my servers - I realise this
is the problem. I have got the sqlsn ...
Mon, 10 Jan 2005 06:13:08 -0800
|
3rd party column level encryption
Hi,
What 3rd party encryption program would you guys recommend? this will be for
secure stuff like email addresses etc
There are a few out there from multiple companies, and just want to know if
anyone here has any experience? (I dont want to
mention prodcut names as I am afraid I might leave something out ...
Sun, 9 Jan 2005 20:03:07 +0200
|