there sure is...

on the same page you posted, there's a drop down menu for Otehr versions...R2 was the sole selection, which redirects you to here:

http://msdn.microsoft.com/en-us/library/bb677408(v=sql.105).aspx

maybe a create a logon trigger that prevents anyone from connecting unless from local connection?

then do...

ok I've got this implementation in my snippets that does what you are asking.

see if this works for you.

you need a table and a procedure, shown below:

CREATE TABLE [dbo].[InvoiceKeys] (...

you can search fro more infor by searching "SQL SERVER CHANGE DATABASE OWNER;

the BOL Links are here for the explanation and the code:

Changing the Database Owner

ALTER AUTHORIZATION (Transact-SQL)

and a basic...

it's just a syntax issue;

CASE for SQL has two forms :

CASE ValuetoTest

WHEN SomeValue

THEN SomeOtherValue

ELSE DefaultValue

END

--OR

CASE

WHEN {SomeExpression} (ie SomeColumn = SomeValue)

THEN SomeOtherValue

ELSE DefaultValue

END

you werejust...

just because you have a windows login, does not auto-magically mean the login...

If you are trying...

you would want to save the filename as well, don't forget....

deepkt (11/5/2012)

---

Try this,

CREATE TABLE Img(Id INT, Filename varchar(255), Obj VARBINARY(MAX))

INSERT INTO Img (Id ,FileName,Obj)

VALUES (1,'Blue Lace 16.bmp',(SELECT * FROM OPENROWSET(BULK...

CREATE LOGIN [appp]

WITH PASSWORD=N'NotTheRealPassword'

MUST_CHANGE,

DEFAULT_DATABASE=[master],

...

i see that error in other posts a lot because people place the mdf in their MyDocuments folder or on their desktop, which all have restricted access, and the service...

SET PARSEONLY ON/OFF works as well.

i'm having some fun trying to get a CLR to work as a proof of concept; i'll post it as soon as it returns results...

does the comments...

SELECT * FROM FROM sys.objects

, yeah the parse assumes the second FROM is a table name, and so the alias 'sys.tables' is an error.

a longer, better error message comes from...

I've played with this a couple of times, Jason; i've used it to chop a SQL statement into elements, so i could play with building my own formatter, and of...

Data is the first thing that comes to mind.

If you save any data of any kind in that database, it would of course be unique to you and your...