...in addition, when running via QA select master as db, or you'll get something like this

Server: Nachr.-Nr. 208, Schweregrad 16, Status 1, Zeile 2

Invalid object name...

According to http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4 you should be on 8.00.760 or above if you had SP3.

8.00.194 is the version number without any SP

Frank

http://www.insidesql.de

Changing to

CREATE PROCEDURE [dbo].[prc995CreateUserLogin] 

(@strLogin nvarchar(30),

@strPwd nvarchar(30))

AS



EXEC sp_addlogin @strLogin, @strPwd, 'MyDatabase', 'english'



EXEC sp_adduser @strLogin, 'myRole'

GO

should work

GO ends a batch. And in the 'next' one your...

Yes, from the security point of view, you're right!

Frank

http://www.insidesql.de

quote:

---

No, but I have noticed that sometimes I've logged in and want to reply to a post, but the post asks me...

Yes, that's right!

Nothing is for free. But learning is fun

Frank

http://www.insidesql.de

Why? There is no real need for this!

However, you can open your table in design view in EM, insert an empty row at the desired place, define data type, save...

In addition to what Brian mentioned, you should take a look at BOL for WRITETEXT.

I found this to be the cause why my log backups failed from time to...

quote:

---

Nice to know you have the time Frank

---

yes, at the moment...

???

shouldn't there be some differences

Frank

http://www.insidesql.de

I guess your boss won't be so happy about that

Frank

http://www.insidesql.de

Insufficient permissions on the network, I would say.

Frank

http://www.insidesql.de

quote:

---

Cool! I love the way MS adds new features with barely any documentation. You should add it as an...

Just a thought!

It happened to me that all of a sudden all my subscription seems to be dropped. You can easily check this on the 'All Forums' page. I checked,...

Sorry, I deleted my response, because I saw edwin_fredrick did the same.

So I thought no further need.

Frank

http://www.insidesql.de