|
Problem linking server
I moved a 7.0 database to 2000 SP3 via backup/restore.
Database and app work fine. The one standard user login
was 'auto_fixed'. But I can't link the new server to a
7.0 database. I can link it ok, but can't access any
table. I get 'Error 2: Access denied.' in Enterprise Mgr
and 'Server: Msg 2, Level ...
Wed, 1 Dec 2004 05:21:31 -0800
|
Help on changing the PW on SQL2000
Hi, all,
I got a problem to change the users' password from the VB
side. It is almost same as one from SQL7, and it works on
SQL7 but I have problem on SQL2000. It is ok when I run it
from QA, what's wrong? Do I need set ANSI NULLS?
Any one can help? Thanks you very much and have a good one
Abchawk
...
Tue, 30 Nov 2004 11:52:40 -0800
|
how can i move a local directory with all files within a procedure
Hello i'd like to know how i can move all my files from C:\SQL to C:\DB
using a Table with a reference to the batch file.
it looks like that:
1.) i have batch.bat file with " call move c:\sql\* to c:\db "
2.) a table MyTable contains a column with value 'c:\db\batch.bat'
3.) i'd like to know if there are ...
Tue, 30 Nov 2004 11:49:08 +0100
|
Moving a Database to another Server
How can i move a Database from one to another 2 SQL Server 7.0 SP2
I already backed up the Database and restored it on the new Server but
now i have the Error Message that the role is alreasdy in the Database ,
but there are no user at all created.
...
Tue, 30 Nov 2004 02:45:04 -0800
|
Windows 2003 Server IPSEC Example for SQL
Greetings,
I would like to secure SQL 2000 using a combination of the builtin
firewall for Windows 2003 server and IPSEC. For the firewall I would
open up ports 1433/TCP and 1434/UDP for SQL. Then I would use
IPSEC to control access to those ports. Please comment on my IPSEC
example below and on this solu ...
Mon, 29 Nov 2004 13:55:45 -0500
|
Ownership Chain Issue
Here is the situation:
I create a database - I am dbo. In this database I have 1 table and 1
updateable view. dbo shows as the owner of both the table and the view. I
create a new database user and do not add them to any database or server
roles. I grant the new user select, update, insert and delete per ...
Mon, 29 Nov 2004 10:09:36 -0800
|
sql icon disappear from sys tray and getting SQL-DMO 80040005 erro
hi folks,
I have tried to installed Microsoft SQL Server 2000 Desktop Engine SP3a and
the full SQL server 2000 on a Win 2000 server with the same result. This is
the problem I see...
With SQL installed and server rebooted, initially I see the sqlmangr.exe
icon in the sys tray. But when I put my icon o ...
Mon, 29 Nov 2004 01:21:03 -0800
|
Windows authentication in reporting services
Hi,
I have a web-application which I log in to with forms authentication.
In this application there is a page with an iframe that displays
reports from the reporting services. The reports is displayed after
filling in data in some input controls at the top of the page and
clicking a button.
After the butt ...
28 Nov 2004 04:08:25 -0800
|
Execute UDF/extended stored procedure only through view?
Lets say I have a view, MyView, that calls MyUDF and/or MyExtendedProcedure.
Is there a way I can allow a user to access MyView, but stop them from
directly executing MyUDF or MyExtendedProcedure?
E.g., I'd like them to be able to do this:
select * from MyView
but stop them from doing this:
...
Sat, 27 Nov 2004 11:17:29 -0500
|
restrict acces to server from lan
Hello,
I got a new SQL 2000 server running. Now we have some clients with local
msde's who are not allowed to connect to that server with their client. Can
this be done? they need network acces and they need to be able op connect to
that server using another application. So it's strictly their local engine
w ...
Fri, 26 Nov 2004 14:45:20 +0100
|
How can i restrict the SA user
hi,
Is there any way to restrict the SA access. The problem is that all my
client machine users knows the sa password, and also right now i don't want
to change the password. So i just want to know is there any way to restrict
their access ? thanking in advance
AR
...
Fri, 26 Nov 2004 11:15:45 +0530
|
Problen with the Logins in SQL
The History is the following:
Exists any Bugs in SQL When tha Firts and Next Letter is Equal for example
JM1502 and JM1007 ? It is posible in SQL Profiler only Register one of them.
Thanks, ...
Thu, 25 Nov 2004 17:55:33 -0800
|
Password Management Policy in SQL 2000
Hi,
Does the SQL 2000 provide the same Password Management Policy capabilities as provided in Oracle 9i ?
By Password Management Policy, I mean the Account Locking, Password Ageing and Expiration and Password History features.
Thanks.
Raja
---
Posted using Wimdows.net NntpNews Component -
Post Made f ...
Thu, 25 Nov 2004 07:06:43 -0800
|
User Role Permissions
sIs there a system stored proc that provide access to changing the
permissions on a user role.
I am using the sp_addrole to create a role and sp_addrolemember to add a
member but wish also to script certain permissions in the new role.
.....thanks ...
Thu, 25 Nov 2004 04:33:06 -0800
|
SQL Server 6.5 Post Service Pack 5a
SQL Server 6.5 SP5a version 6.50.479.
I am trying to get what are the description of the patch. But unable to get
the information on what are fixes.
274035 INF: SQL Server 6.5 Post Service Pack 5a Update Fixlist
The link appear to be no longer exist
http://support.microsoft.com/kb/273914/EN-US/
Anyo ...
Wed, 24 Nov 2004 18:19:02 -0800
|