a user can't be deleted...

Hi,
I've just installed SQL Server 2005, and mistakenly add a user in
ServerName\Database\master; I added two kind of schema into that user.
But when I tried to delete the user, SQL Server 2005 tells me that database
user have schema assigned to it thus can't be remove.
Is there a way to do delete it?
PS: I have another serious problem regarding SQL Server 2005 database,
please take a look at it in "SQL Server Server newsgroup" under "failed to
connect to SQL Server's database!" thread. Any suggestions and help is
greatly appreciated.
Thank you.You have to first remove the schemas assigned to the user BEFORE you can
remove the user.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Dhow" <Dhow@.discussions.microsoft.com> wrote in message
news:958F2A86-5F41-41B6-92E8-9AB888FCD441@.microsoft.com...
> Hi,
> I've just installed SQL Server 2005, and mistakenly add a user in
> ServerName\Database\master; I added two kind of schema into that user.
> But when I tried to delete the user, SQL Server 2005 tells me that
> database
> user have schema assigned to it thus can't be remove.
> Is there a way to do delete it?
> PS: I have another serious problem regarding SQL Server 2005 database,
> please take a look at it in "SQL Server Server newsgroup" under "failed to
> connect to SQL Server's database!" thread. Any suggestions and help is
> greatly appreciated.
> Thank you.

a stored procedure in C# creates a file (the file cant be deleted)

hi,
I wrote a dll in c#. It creates a bitmap file. the dll is appended to sql
server 2005 as an assembly. when I call that stored procedure it creates a
bitmap file on my local disk. the problem is, that the file cant be deleted.
I get error saying that the file is being used by another person or
application. but it isnt!. moreover, when I create an exe file and launch it,
everything works ok. then, the exe creates the bitmap which can be easy
deleted.
how to check what application is using the bitmap (a resource)? what is the
difference in creating the bitmap by launching a stored sql procedure than by
launching an exe application?
Hello Chris,
FileMon from WinTernals comes to mind. See http://www.winternals.com/
Chances are that the SQL Server is holding a lock on that file because you
didn't close the file handle on it. Can you post the bit of code that writes
the bitmap to the file?
Thanks,
Kent Tegels
DevelopMentor

a stored procedure in C# creates a file (the file cant be deleted)

hi,
I wrote a dll in c#. It creates a bitmap file. the dll is appended to sql
server 2005 as an assembly. when I call that stored procedure it creates a
bitmap file on my local disk. the problem is, that the file cant be deleted.
I get error saying that the file is being used by another person or
application. but it isnt!. moreover, when I create an exe file and launch it
,
everything works ok. then, the exe creates the bitmap which can be easy
deleted.
how to check what application is using the bitmap (a resource)? what is the
difference in creating the bitmap by launching a stored sql procedure than b
y
launching an exe application?Hello Chris,
FileMon from WinTernals comes to mind. See http://www.winternals.com/
Chances are that the SQL Server is holding a lock on that file because you
didn't close the file handle on it. Can you post the bit of code that writes
the bitmap to the file?
Thanks,
Kent Tegels
DevelopMentor

a stored procedure in C# creates a file (the file cant be deleted)

hi,
I wrote a dll in c#. It creates a bitmap file. the dll is appended to sql
server 2005 as an assembly. when I call that stored procedure it creates a
bitmap file on my local disk. the problem is, that the file cant be deleted.
I get error saying that the file is being used by another person or
application. but it isnt!. moreover, when I create an exe file and launch it,
everything works ok. then, the exe creates the bitmap which can be easy
deleted.
how to check what application is using the bitmap (a resource)? what is the
difference in creating the bitmap by launching a stored sql procedure than by
launching an exe application?Hello Chris,
FileMon from WinTernals comes to mind. See http://www.winternals.com/
Chances are that the SQL Server is holding a lock on that file because you
didn't close the file handle on it. Can you post the bit of code that writes
the bitmap to the file?
Thanks,
Kent Tegels
DevelopMentor

a server with this name already exists

Hi
I deleted the registration for my sql server. When I try
to re-add it in ent. mgr I get the error "a server with
this name already exists".
Any ideas?
Thanks
MarkCheck in the other EM groups for a registered server of
the same name. You have already registered a server of the
same name, just exactly as the message indicates.
Linchi
>--Original Message--
>Hi
>I deleted the registration for my sql server. When I try
>to re-add it in ent. mgr I get the error "a server with
>this name already exists".
>Any ideas?
>Thanks
>Mark
>.
>|||Hi Linchi
The server is not registered under any other groups, which
is why I was confused by the error. I'm able to still
stop/start the server thru service manager.
>--Original Message--
>Check in the other EM groups for a registered server of
>the same name. You have already registered a server of
the
>same name, just exactly as the message indicates.
>Linchi
>>--Original Message--
>>Hi
>>I deleted the registration for my sql server. When I try
>>to re-add it in ent. mgr I get the error "a server with
>>this name already exists".
>>Any ideas?
>>Thanks
>>Mark
>>.
>.
>

A hashtable that contains millions of records

My database has a hash table that contains millions of records.
Each day thousands of records will be inserted/updated/deleted/read from
this table.
Are there potential problems that I should be awared of?
Is there a better solution not to use just one table?I don't understand your question. A hash table is not a physical database
structure. It's an in-memory structure that is created at the time of query
execution to optimize direct retrieval by key. This is often created when
no appropriate index exists on the table.
SQL Server indexes are b-trees. These are efficient even with tables
containing of billions of rows.
Happy Holidays
Dan Guzman
SQL Server MVP
"Lang" <Lang@.discussions.microsoft.com> wrote in message
news:D3E18EB5-2318-49DC-8178-03FF7980563E@.microsoft.com...
> My database has a hash table that contains millions of records.
> Each day thousands of records will be inserted/updated/deleted/read from
> this table.
> Are there potential problems that I should be awared of?
> Is there a better solution not to use just one table?|||> Is there a better solution not to use just one table?
Just to add to Dan's answer: this one depends on your business problem. Data
model should be done logically correct first, afterwards you can do some
compromises because of performance.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com|||"Lang" <Lang@.discussions.microsoft.com> wrote in message
news:D3E18EB5-2318-49DC-8178-03FF7980563E@.microsoft.com...
> My database has a hash table that contains millions of records.
> Each day thousands of records will be
inserted/updated/deleted/read from
> this table.
> Are there potential problems that I should be awared of?
> Is there a better solution not to use just one table?
Lang,
You have asked a question about the design of your table.
But you have not provided any information about that table (please
understand that, "The database has a hash table," is not a table
description that is useful in answering your question).
The link http://www.aspfaq.com/etiquette.asp?id=5006,
is excellent when it comes to detailing how to provide
the information that will best enable others to answer
your questions.
Sincerely,
Chris O.