I'm trying to get my first clr stored procedure going.
I believe I was able to create the clr stored procedure in visual studio,
set 'clr enabled' on the server, create an assembly, create an sp based on
the external name, and finally EXEC it from T-SQL to call it. When I call it, ...

Is sql2k sp4 has internal tables encryption function?
I need to encrypt the tables in one database?
Don't know how?
ANy ideas?

I am attempting to add a windows login to be able to access a database.  When
I try to do this I receive the following error.
Error 823: I/O Error (bad page id) detected during read at offset
0x00000000ae6000 in file e:\program files\microsoft sql

In sql2005, I don't a lot of sys tables in master db.
i.e. sysusers and syslogins?
ANy ideas?
Thanks

If I DTS master.syslogins and sysusers table,the users' passwords
transferred as well?
Thanks

How do I transfer all logins from sql2k server to a new sql2005 box?
Thanks

I have checked the google group search and found a topic regarding
the setting Proxy account for SQL agent. The topic was logged last Dec.
2003. I have the same issue but this time, a changed with Domain might
be the cause. we moved from NT domain to AD. I am encountering 'No

Can I disable local admin right in SQL Server?
What is the affect if I could do that?
Your response would be greatly appreaciated,
Culam

I've made a stored procedure stp_LogError which will be used to have a
central errorhandling system.
(So in the usermade stored procedures in the catch-block stp_Logerror will
be used to log the error).

OK. I've read all kinds of stuff on the internet about changing the SQL
Server Service and SQL Server Agent Service account passwords. They all
say "use Enterprise Manager" because it performs additional tasks that
you would otherwise have to perform manually. I can dig that.

Is there a way to link servers together using windows authentication when you
are not logged into the server?  I would like to run queries between servers
from a local server.
I am logged on serv1 as myself with win auth.  I am "SA" on all 3

I've been asked to create a method of alerting if the account that the
MSSQLSERVER service runs under is used to attempt to log into the
database from another workstation. Here's what I've thought of so far:
OPTION 1: Monitoring for all login attempts. I don't want to do this as

We've got this strange situation. I want to perform a bulk insert in
SQLserver 2005 from a file on the file system. This works OK when I use a
SQLuser. When I do the same logged in with windows account (with
administrator privileges) I get an error. I thought that when I use a

Running SQL Server 2000... I've installed a new instance of this on a new
server (to migrate from server1 to server2).
On server1, i have a group set up (domain/SQLGroup)...
On server2, i have the exact same group set up... unfortunately all the

On a customer-owned SQL Server 2000, we've got our db placed, together with
other software vendors databases. How can we protect from that the customer
and\or the other companies from fetching the db schema of our db?
All parties are allowd to login with the sa account. Can we by ...