Scott D. Jacobson (8/20/2012)

---

anthony.green (8/20/2012)

---

Scott D. Jacobson (8/17/2012)

---

anthony.green (8/17/2012)

---

run query in ssms, results to grid, right click top left hand blank thing to select the whole result set including headers,...

Data file more than 90% full, find big tables and delete data no longer needed, add more space to the file, as a counter measure check the auto growth settings...

Scott D. Jacobson (8/17/2012)

---

anthony.green (8/17/2012)

---

run query in ssms, results to grid, right click top left hand blank thing to select the whole result set including headers, then right click, save...

Take a look at Ola's scripts in my signature, he has a good comprehensive maintenance script which will do what you want.

Nope, we need to give the users direct access to the web page, so rendering to file is not an option.

As this is going to be external facing SSRS and...

To add on to this, if you go in via ReportServer and browse via that URL the reports render as HTML. It is only if you go in on...

Change the function to return varchar(max) and have a str of varchar(max)

Follow the instructions on this link http://technet.microsoft.com/en-us/library/dd207004.aspx

Make sure you are a local admin of the server where SQL is installed.

Then once the above has been done and SQL is in...

You need to grant the nessesary access to your account, so you will need to login as an account which has the right access to change user permissions.

Typically your DBA...

What have you tried so far?

And does it need to be a total of all databases per month,

E.g

200GB July 2012

Or does it need to be broke down by DB

20GB...

run query in ssms, results to grid, right click top left hand blank thing to select the whole result set including headers, then right click, save results as

MSDB you probably wont have any problems with, but master you might as thats the "server" db, unsure if there would be some flag or data in master to say...

bitbucket-25253 (8/16/2012)

---

Be very, very careful about using ISNUMERIC .. for example, altering your input data slightly to more readily see the possible problem.

DECLARE @Codes TABLE (Code VARCHAR(100),LineNr...

One or more of the columns must be null.

You can handle it by using ISNULL

Something like below

(ISNULL(Vehicle.value,0) + ISNULL(Vehicle.Extras_Value,0) + ISNULL(Vehicle.Expenses,0) + ISNULL(Vehicle.Another_Tax,0) + ISNULL(Vehicle.Other_Extras_Value,0)) AS NetCost

Make your inserts into your tempoary table a sub query

something like this

declare @CurrentSchoolYear int,

@dtBeginDateIA3 datetime,

@dtEndDateIA3 datetime,

@dtBeginDateIA2 datetime,

@dtEndDateIA2 datetime,

@dtBeginDateIA1 datetime,

@dtEndDateIA1 datetime,

@dtBeginDateIA datetime,

@dtEndDateIA datetime

select @CurrentSchoolYear = iCurrentSchoolYearCode from tblSysVariables

SELECT @dtBeginDateIA3 =...