Markus (11/8/2012)

---

There are several reasons for it. Typically the rows that are active are at the end of the file so it isn't shrinking. Rebuilding indexes on the...

you know your data better than use;

this query seems to be what you were trying to insert.

does the sELECT return teh expected values? if the PatientId = Key, and it...

Edit!!

Snippy Snippy Double Dippy!

i double psoted somehow sorry.

you can use a standard integer identity, and then simply format the number with preceeding zeros whenever you are displaying it. there's no need to store preceeding zeros...that's just a...

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...