i love this script from Microsoft for this kind of situation:

http://archive.msdn.microsoft.com/Project/Download/FileDownload.aspx?ProjectName=addselftosqlsysadmin&DownloadId=9198

it connects to your local or named instance, and adds the current windows user as a sysadmin on the machine...

aberndt (1/23/2014)

---

I appreciate both of your help. It is the row above in both the abc table and the view. I am reviewing the article that Brain Donor...

aberndt (1/23/2014)

---

I am trying to add a field to a view that actually contains data from the record previous to the one I am selecting here:

SELECT ...

I've found the hard way there are multiple prerequisites to...

the SUM(SUM( doesn't look right to me; i think you just wnat to add the two together:

does this minor change work?

= "Record contains "

+ Switch(

Sum(Fields!FQ.Value, "ds") <> 0 and...

Everything you mentioned is exactly why i try to donate some time here and help people.

I've sometimes put in a lot of time creating a solution on a topic...

I've...

the error seems pretty clear to me:

does your process expect to insert...

yes it's possible; you can create a CHECK constraint that uses a user defined function, that say returns 1 or 0 if the criteria is valid or not.

with DDL and...

create a new table with the appropriate primary key or unique constraint.

insert into that new table grouping by the the same appropriate primary key or unique constraint criteria from the...

even if you have a default constraint in place, if you have a data access layer that explicitly sends NULL to be the column value, then NULL it shall be.

defaults...

microsoft supplies a proc named sp_help_revlogin here that scripts out sql users with hashed passwords, for importation onto other servers.

you'll need to grab the right version off of the MS...

for that i think you'll have to search and read a bit for yourself: it's far to much for a forum post to highlight for you.

https://www.google.com/search?q=difference+between+sql+2005+and+sql+2008

https://www.google.com/search?q=difference+between+sql+2005+and+sql+2008R2

https://www.google.com/search?q=difference+between+sql+2005+and+sql+2012

format 108 givesw the time including seconds, includingpreceeding zeros, so you could do a substring/left of that:

SELECT LEFT(CONVERT(VARCHAR,getdate(),108),5) --09:10

Edward-445599 (1/17/2014)

---

Hi,

I was wondering what is the best way to change context within a DB.

For example you could have a simple script which restores a DB you might have something...