Hi,
I need encrypt media containing a sql backup, this media travel around any
factorys, is very important the security of content in this media and
garantize don't read for anyware sql server, only read in the original
server, is possible¿?
resguards
JordiLook at www.netlib.com -- Encryptionizer allows you to encrypt backups.
On Fri, 20 Jan 2006 16:13:52 +0100, "jordi" <jordifarell@.hotmail.com> wrote:
>Hi,
>I need encrypt media containing a sql backup, this media travel around any
>factorys, is very important the security of content in this media and
>garantize don't read for anyware sql server, only read in the original
>server, is possible¿?
>resguards
>Jordi
>
-- AntiSpam/harvest --
Remove X's to send email to me.|||Some of the 3:rd party backup programs have built-in encryption. Check out my link page:
http://www.karaszi.com/SQLServer/links.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"jordi" <jordifarell@.hotmail.com> wrote in message news:OR8BhQdHGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I need encrypt media containing a sql backup, this media travel around any factorys, is very
> important the security of content in this media and garantize don't read for anyware sql server,
> only read in the original server, is possible¿?
> resguards
> Jordi
>
Showing posts with label security. Show all posts
Showing posts with label security. Show all posts
Monday, March 26, 2012
Monday, March 12, 2012
How to drop user names after copying database?
I copied a database from a SQL 2000 server to a SQL 2005 server. In the
node for that database, and in the security > users node, it shows the users
from the 2000 box. Of course, those users don't exist on the 2005 box.
The GUI (SQL Server Management Studio) won't let me right click and delete.
When I try that, it says an error occurred. I thought 2005 would be smarter
than 2000. Microsoft has done a terrible job with the UI upgrade after 5
years. I know the answer is in running some lines in query analyzer to
remove those false user names from the db, but I can't remember what they
are, and I don't know if it is different for sql 2005 that it was under
2000.Run this in the said database, then execute the output it generates. That
will clean up the users for you.
set quoted_identifier off
select "exec sp_dropuser '" + name + "'" from sysusers where uid between 3
and 16383
AndyP,
Sr. Database Administrator,
MCDBA 2003
"HK" wrote:
> I copied a database from a SQL 2000 server to a SQL 2005 server. In the
> node for that database, and in the security > users node, it shows the use
rs
> from the 2000 box. Of course, those users don't exist on the 2005 box.
> The GUI (SQL Server Management Studio) won't let me right click and delete
.
> When I try that, it says an error occurred. I thought 2005 would be smart
er
> than 2000. Microsoft has done a terrible job with the UI upgrade after 5
> years. I know the answer is in running some lines in query analyzer to
> remove those false user names from the db, but I can't remember what they
> are, and I don't know if it is different for sql 2005 that it was under
> 2000.
>
>|||Exactly what I was looking for. Thanks!
"AndyP" <AndyP@.discussions.microsoft.com> wrote in message
news:CD6F6C73-B481-4D5F-B6A8-5C2C78985F9D@.microsoft.com...[vbcol=seagreen]
> Run this in the said database, then execute the output it generates. That
> will clean up the users for you.
>
> set quoted_identifier off
> select "exec sp_dropuser '" + name + "'" from sysusers where uid between 3
> and 16383
>
> --
> AndyP,
> Sr. Database Administrator,
> MCDBA 2003
>
> "HK" wrote:
>
users[vbcol=seagreen]
delete.[vbcol=seagreen]
smarter[vbcol=seagreen]
5[vbcol=seagreen]
they[vbcol=seagreen]
node for that database, and in the security > users node, it shows the users
from the 2000 box. Of course, those users don't exist on the 2005 box.
The GUI (SQL Server Management Studio) won't let me right click and delete.
When I try that, it says an error occurred. I thought 2005 would be smarter
than 2000. Microsoft has done a terrible job with the UI upgrade after 5
years. I know the answer is in running some lines in query analyzer to
remove those false user names from the db, but I can't remember what they
are, and I don't know if it is different for sql 2005 that it was under
2000.Run this in the said database, then execute the output it generates. That
will clean up the users for you.
set quoted_identifier off
select "exec sp_dropuser '" + name + "'" from sysusers where uid between 3
and 16383
AndyP,
Sr. Database Administrator,
MCDBA 2003
"HK" wrote:
> I copied a database from a SQL 2000 server to a SQL 2005 server. In the
> node for that database, and in the security > users node, it shows the use
rs
> from the 2000 box. Of course, those users don't exist on the 2005 box.
> The GUI (SQL Server Management Studio) won't let me right click and delete
.
> When I try that, it says an error occurred. I thought 2005 would be smart
er
> than 2000. Microsoft has done a terrible job with the UI upgrade after 5
> years. I know the answer is in running some lines in query analyzer to
> remove those false user names from the db, but I can't remember what they
> are, and I don't know if it is different for sql 2005 that it was under
> 2000.
>
>|||Exactly what I was looking for. Thanks!
"AndyP" <AndyP@.discussions.microsoft.com> wrote in message
news:CD6F6C73-B481-4D5F-B6A8-5C2C78985F9D@.microsoft.com...[vbcol=seagreen]
> Run this in the said database, then execute the output it generates. That
> will clean up the users for you.
>
> set quoted_identifier off
> select "exec sp_dropuser '" + name + "'" from sysusers where uid between 3
> and 16383
>
> --
> AndyP,
> Sr. Database Administrator,
> MCDBA 2003
>
> "HK" wrote:
>
users[vbcol=seagreen]
delete.[vbcol=seagreen]
smarter[vbcol=seagreen]
5[vbcol=seagreen]
they[vbcol=seagreen]
How to drop user names after copying database?
I copied a database from a SQL 2000 server to a SQL 2005 server. In the
node for that database, and in the security > users node, it shows the users
from the 2000 box. Of course, those users don't exist on the 2005 box.
The GUI (SQL Server Management Studio) won't let me right click and delete.
When I try that, it says an error occurred. I thought 2005 would be smarter
than 2000. Microsoft has done a terrible job with the UI upgrade after 5
years. I know the answer is in running some lines in query analyzer to
remove those false user names from the db, but I can't remember what they
are, and I don't know if it is different for sql 2005 that it was under
2000.
Run this in the said database, then execute the output it generates. That
will clean up the users for you.
set quoted_identifier off
select "exec sp_dropuser '" + name + "'" from sysusers where uid between 3
and 16383
AndyP,
Sr. Database Administrator,
MCDBA 2003
"HK" wrote:
> I copied a database from a SQL 2000 server to a SQL 2005 server. In the
> node for that database, and in the security > users node, it shows the users
> from the 2000 box. Of course, those users don't exist on the 2005 box.
> The GUI (SQL Server Management Studio) won't let me right click and delete.
> When I try that, it says an error occurred. I thought 2005 would be smarter
> than 2000. Microsoft has done a terrible job with the UI upgrade after 5
> years. I know the answer is in running some lines in query analyzer to
> remove those false user names from the db, but I can't remember what they
> are, and I don't know if it is different for sql 2005 that it was under
> 2000.
>
>
|||Exactly what I was looking for. Thanks!
"AndyP" <AndyP@.discussions.microsoft.com> wrote in message
news:CD6F6C73-B481-4D5F-B6A8-5C2C78985F9D@.microsoft.com...[vbcol=seagreen]
> Run this in the said database, then execute the output it generates. That
> will clean up the users for you.
>
> set quoted_identifier off
> select "exec sp_dropuser '" + name + "'" from sysusers where uid between 3
> and 16383
>
> --
> AndyP,
> Sr. Database Administrator,
> MCDBA 2003
>
> "HK" wrote:
users[vbcol=seagreen]
delete.[vbcol=seagreen]
smarter[vbcol=seagreen]
5[vbcol=seagreen]
they[vbcol=seagreen]
node for that database, and in the security > users node, it shows the users
from the 2000 box. Of course, those users don't exist on the 2005 box.
The GUI (SQL Server Management Studio) won't let me right click and delete.
When I try that, it says an error occurred. I thought 2005 would be smarter
than 2000. Microsoft has done a terrible job with the UI upgrade after 5
years. I know the answer is in running some lines in query analyzer to
remove those false user names from the db, but I can't remember what they
are, and I don't know if it is different for sql 2005 that it was under
2000.
Run this in the said database, then execute the output it generates. That
will clean up the users for you.
set quoted_identifier off
select "exec sp_dropuser '" + name + "'" from sysusers where uid between 3
and 16383
AndyP,
Sr. Database Administrator,
MCDBA 2003
"HK" wrote:
> I copied a database from a SQL 2000 server to a SQL 2005 server. In the
> node for that database, and in the security > users node, it shows the users
> from the 2000 box. Of course, those users don't exist on the 2005 box.
> The GUI (SQL Server Management Studio) won't let me right click and delete.
> When I try that, it says an error occurred. I thought 2005 would be smarter
> than 2000. Microsoft has done a terrible job with the UI upgrade after 5
> years. I know the answer is in running some lines in query analyzer to
> remove those false user names from the db, but I can't remember what they
> are, and I don't know if it is different for sql 2005 that it was under
> 2000.
>
>
|||Exactly what I was looking for. Thanks!
"AndyP" <AndyP@.discussions.microsoft.com> wrote in message
news:CD6F6C73-B481-4D5F-B6A8-5C2C78985F9D@.microsoft.com...[vbcol=seagreen]
> Run this in the said database, then execute the output it generates. That
> will clean up the users for you.
>
> set quoted_identifier off
> select "exec sp_dropuser '" + name + "'" from sysusers where uid between 3
> and 16383
>
> --
> AndyP,
> Sr. Database Administrator,
> MCDBA 2003
>
> "HK" wrote:
users[vbcol=seagreen]
delete.[vbcol=seagreen]
smarter[vbcol=seagreen]
5[vbcol=seagreen]
they[vbcol=seagreen]
How to drop user names after copying database?
I copied a database from a SQL 2000 server to a SQL 2005 server. In the
node for that database, and in the security > users node, it shows the users
from the 2000 box. Of course, those users don't exist on the 2005 box.
The GUI (SQL Server Management Studio) won't let me right click and delete.
When I try that, it says an error occurred. I thought 2005 would be smarter
than 2000. Microsoft has done a terrible job with the UI upgrade after 5
years. I know the answer is in running some lines in query analyzer to
remove those false user names from the db, but I can't remember what they
are, and I don't know if it is different for sql 2005 that it was under
2000.Run this in the said database, then execute the output it generates. That
will clean up the users for you.
set quoted_identifier off
select "exec sp_dropuser '" + name + "'" from sysusers where uid between 3
and 16383
AndyP,
Sr. Database Administrator,
MCDBA 2003
"HK" wrote:
> I copied a database from a SQL 2000 server to a SQL 2005 server. In the
> node for that database, and in the security > users node, it shows the users
> from the 2000 box. Of course, those users don't exist on the 2005 box.
> The GUI (SQL Server Management Studio) won't let me right click and delete.
> When I try that, it says an error occurred. I thought 2005 would be smarter
> than 2000. Microsoft has done a terrible job with the UI upgrade after 5
> years. I know the answer is in running some lines in query analyzer to
> remove those false user names from the db, but I can't remember what they
> are, and I don't know if it is different for sql 2005 that it was under
> 2000.
>
>|||Exactly what I was looking for. Thanks!
"AndyP" <AndyP@.discussions.microsoft.com> wrote in message
news:CD6F6C73-B481-4D5F-B6A8-5C2C78985F9D@.microsoft.com...
> Run this in the said database, then execute the output it generates. That
> will clean up the users for you.
>
> set quoted_identifier off
> select "exec sp_dropuser '" + name + "'" from sysusers where uid between 3
> and 16383
>
> --
> AndyP,
> Sr. Database Administrator,
> MCDBA 2003
>
> "HK" wrote:
> > I copied a database from a SQL 2000 server to a SQL 2005 server. In the
> > node for that database, and in the security > users node, it shows the
users
> > from the 2000 box. Of course, those users don't exist on the 2005 box.
> > The GUI (SQL Server Management Studio) won't let me right click and
delete.
> > When I try that, it says an error occurred. I thought 2005 would be
smarter
> > than 2000. Microsoft has done a terrible job with the UI upgrade after
5
> > years. I know the answer is in running some lines in query analyzer to
> > remove those false user names from the db, but I can't remember what
they
> > are, and I don't know if it is different for sql 2005 that it was under
> > 2000.
> >
> >
> >
node for that database, and in the security > users node, it shows the users
from the 2000 box. Of course, those users don't exist on the 2005 box.
The GUI (SQL Server Management Studio) won't let me right click and delete.
When I try that, it says an error occurred. I thought 2005 would be smarter
than 2000. Microsoft has done a terrible job with the UI upgrade after 5
years. I know the answer is in running some lines in query analyzer to
remove those false user names from the db, but I can't remember what they
are, and I don't know if it is different for sql 2005 that it was under
2000.Run this in the said database, then execute the output it generates. That
will clean up the users for you.
set quoted_identifier off
select "exec sp_dropuser '" + name + "'" from sysusers where uid between 3
and 16383
AndyP,
Sr. Database Administrator,
MCDBA 2003
"HK" wrote:
> I copied a database from a SQL 2000 server to a SQL 2005 server. In the
> node for that database, and in the security > users node, it shows the users
> from the 2000 box. Of course, those users don't exist on the 2005 box.
> The GUI (SQL Server Management Studio) won't let me right click and delete.
> When I try that, it says an error occurred. I thought 2005 would be smarter
> than 2000. Microsoft has done a terrible job with the UI upgrade after 5
> years. I know the answer is in running some lines in query analyzer to
> remove those false user names from the db, but I can't remember what they
> are, and I don't know if it is different for sql 2005 that it was under
> 2000.
>
>|||Exactly what I was looking for. Thanks!
"AndyP" <AndyP@.discussions.microsoft.com> wrote in message
news:CD6F6C73-B481-4D5F-B6A8-5C2C78985F9D@.microsoft.com...
> Run this in the said database, then execute the output it generates. That
> will clean up the users for you.
>
> set quoted_identifier off
> select "exec sp_dropuser '" + name + "'" from sysusers where uid between 3
> and 16383
>
> --
> AndyP,
> Sr. Database Administrator,
> MCDBA 2003
>
> "HK" wrote:
> > I copied a database from a SQL 2000 server to a SQL 2005 server. In the
> > node for that database, and in the security > users node, it shows the
users
> > from the 2000 box. Of course, those users don't exist on the 2005 box.
> > The GUI (SQL Server Management Studio) won't let me right click and
delete.
> > When I try that, it says an error occurred. I thought 2005 would be
smarter
> > than 2000. Microsoft has done a terrible job with the UI upgrade after
5
> > years. I know the answer is in running some lines in query analyzer to
> > remove those false user names from the db, but I can't remember what
they
> > are, and I don't know if it is different for sql 2005 that it was under
> > 2000.
> >
> >
> >
Subscribe to:
Posts (Atom)