Jeff Moden (3/13/2012)

---

anthony.green (3/12/2012)

---

you might want to take a look at full text indexing and the contains function then, otherwise you will be wrapping the variable in a multiple of...

i would suggest creating a profile trace which looks at the text data of all connections for the following strings

ALTER DATABASE nameofyourdatabase SET RECOVERY FULL

or

ALTER DATABASE nameofyourdatabase SET RECOVERY SIMPLE

that...

if you have enterprise edition you can do a scale out deployment where you have multiple hosts acting as SSRS front ends which will give load balancing and HA if...

if you want to run two instances one on each node then you need two virtual names SQL01\INSTANCE01 and SQL02\INSTANCE02 for example, then if they are resources in the...

the drive sizes are ok as long as they are big enough to factor in growth, so you dont want to put in a db now which will grow to...

what is the backing behind changing the collation? is it just to have the same collation throughout or is there other factors at play here?

there is no issue in that its the capacity splits that you need to worry about, but only you can decide this as you should know roughly how the database...

might want to take a look at this url http://www.codeproject.com/Articles/5986/Passing-a-Comma-Delimited-Parameter-to-a-Stored-Pr

replace the , for a + to concatinate the strings at the end of the first case

are you wanting the users to be able to use the data picker, as I have just created a test report allowing multiple values for a date time parameter and...

does the stored procedure handle multiple dates being passed in with the startdate parameter?

you need to split the disks out as you see fit ensuring that they are big enough for db growth and that you can easily add more disk space should...

your login will have a language of english which is US so dates are in the format MDY, if you change it to british english it changes it to dmy,...

try set dateformat dmy at the top of the script