Viewing 15 posts - 5,416 through 5,430 (of 6,400 total)
10.0.2531 means its SQL2008 SP1, unsure how you check that SSMS is installed via Express with Advanced Tools or another media.
Are you able to RDP to the server and run...
March 27, 2012 at 4:53 am
also if you dont know something, tell them you dont know.
as an interviewer I like the honesty as I always check the answers interviewie give to me if it is...
March 27, 2012 at 4:49 am
they live in memory for the scope of the transaction, they are not created in a database
March 27, 2012 at 4:41 am
you will need to set item level security, best way is to create a number of AD security groups in your active directory environment and assign the users to...
March 27, 2012 at 4:36 am
you need to install BIDS from the SQL server media which will install VS2008 Shell if you dont already have VS2008 installed.
March 27, 2012 at 4:34 am
if you have BIDS (business intelligence development studio) installed on your machine, I would suggest creating a SSIS solution and a SSRS soution and see whats in the tool box...
March 27, 2012 at 4:32 am
not had the issue before but a quick google came up with a few results,
one solution might be this
Have you enabled System cryptography: Use FIPS compliant algorithms for encryption, hashing,...
March 27, 2012 at 2:02 am
looks like a potential cause for cross tabs or pivots
take a look here http://www.sqlservercentral.com/articles/Crosstab/65048/
March 27, 2012 at 1:59 am
what defines a business hour/working hour?
how are business hours/working hours calculated?
March 27, 2012 at 1:57 am
the RS DB's are created by script which is done at the configuration stage.
as these DB's are only ever used by the SSRS service then there is no logical need...
March 27, 2012 at 1:56 am
what security rights have you assigned to the schema and also what rights do the users have to the schema.
for example, SSRS uses a dedicate account to connect to, if...
March 27, 2012 at 1:53 am
its down to NTFS ACL's where it locks the files to the user which detached the DB, so ensure you detach and move as the same user or detach then...
March 27, 2012 at 1:41 am
as its at the virtual instance level that will be sending mail you only need to allow the virtual instance IP address access to the mail server. if you...
March 27, 2012 at 1:39 am
take a look at the function DATEDIFF in BOL or Google, it will get the difference between two datetime fields which you can then say is the amount of time...
March 27, 2012 at 1:28 am
Viewing 15 posts - 5,416 through 5,430 (of 6,400 total)