add more space to the drive

or

restart SQL

DECLARE @Account TABLE (AccountNo INT, Name VARCHAR(100))

INSERT INTO @Account VALUES

(60000000,'Mrs Rayford Hufflepuff18'),

(60000001,'Miss Forest Hufflepuff18'),

(60000061,'Miss Bex Ignore'),

(60000068,'Mr Jason Twirl'),

(60000088,'Mrs Katuta Sunger'),

(60000111,'Mrs Corene Ravenclaw19'),

(60000112,'Miss Reta Ravenclaw19'),

(60000132,'Miss Aubrey Ravenclaw19'),

(60000137,'Mr Millicent Ravenclaw19'),

(60000207,'Brigadier Hannah Decorationbextest'),

(60000220,'Professor...

You need to group by in the sub select as your using an aggregate function

SELECT

(

CASE

WHEN (GROUPING([MAT]) = 1) THEN

'Tot'

ELSE

[MAT]

END

) AS MAT,

[myNUmber]

FROM

(

SELECT DISTINCT

CASE

WHEN LEFT (TZZ, 2) = '1D'

OR LEFT (TZZ, 2)...

Might be a tough one to get all that in one product.

You could potentially use Dynamics AX or maybe NAV depending on the complete requirements.

Would deffinatly work with stock management.

IT...

Data file = mdf

Transaction log file = ldf

Yes, lookup sp_attach_db in BOL or a search engine of your choice.

Well msdb.dbo.backupset wont help you as that is successfull backups. It is always good to say what you are trying to acheive first.

You will need to look through the...

You will need to provide more details that what you have posted already to get a query.

What is the goal? What do you want to see?

SELECT * FROM MSDB.dbo.BackupSet...

query msdb.dbo.backupset

It would seem that the data in the sheet is either unicode/non-unicode and the connection manager is saying its the other, or the data in the sheet is to big...

http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

Chapter 4 - Memory management

Please dont cross post.

All replies here http://www.sqlservercentral.com/Forums/Topic1350740-1292-1.aspx?Update=1

http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ Chapter 4 - Memory Management

You can do this, 1 of two ways.

Either combine multiple chart layers on the same chart, 1 bar, 1 line, and set the filters up correctly in the chart to...

Delete the rdl.data files from within the solutions folder.

I also tried the change of the value to not cache files but it still does, this manual delete is the only...