Viewing 15 posts - 2,641 through 2,655 (of 13,469 total)
i love this script from Microsoft for this kind of situation:
it connects to your local or named instance, and adds the current windows user as a sysadmin on the machine...
January 23, 2014 at 11:58 am
aberndt (1/23/2014)
January 23, 2014 at 10:40 am
aberndt (1/23/2014)
SELECT ...
January 23, 2014 at 10:23 am
jeandlauro (1/23/2014)
I will try that. I have also tried to instal the 64-bit access driver but get this message.http://www.microsoft.com/en-us/download/confirmation.aspx?id=13255
Engine 2010 because you currently have 32bit Office products
installed. If you want to install 64bit Microsoft Access Database
Engine 2010, you will first need to remove the 32bit installation of
Office products. After uninstalling the following product(s), rerun
setup in order to install 64bit version of Microsoft Access Database
Engine 2010:
Microsoft Office Professional Plus 2007, Microsoft Office Access
database engine 2007 (English)
I've found the hard way there are multiple prerequisites to...
January 23, 2014 at 10:16 am
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...
January 23, 2014 at 9:00 am
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...
January 23, 2014 at 5:49 am
the error seems pretty clear to me:
"Violation of PRIMARY KEY constraint 'PK_incident_id'. Cannot insert duplicate key in object 'dbo.incident'. The duplicate key value is (129).".
does your process expect to insert...
January 22, 2014 at 8:36 am
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...
January 22, 2014 at 7:29 am
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...
January 21, 2014 at 6:18 am
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...
January 21, 2014 at 5:40 am
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...
January 17, 2014 at 3:09 pm
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
January 17, 2014 at 1:18 pm
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
January 17, 2014 at 7:12 am
Edward-445599 (1/17/2014)
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...
January 17, 2014 at 6:33 am
Viewing 15 posts - 2,641 through 2,655 (of 13,469 total)