Have had some trouble with this stored procedure and large (more than 1 GB) databases.. Made two changes. First gone from "int" to "bigint" and then...
I been fidling around with this for a awhile now.. Thisis actually my first stored procedure ever so be nice... [<img...
It took some thinking... <br /><br /><pre>set quoted_identifier off<br />DECLARE @sizedata int<br />DECLARE @sizelog int<br />DECLARE @databasename...
Found the solution by myself (The SQL Server books online is GOOD!!) If I do it like this then it works: EXEC ('UPDATE...
Using this code<br /><pre><br />DECLARE @sizedata int<br />DECLARE @sizelog int<br />DECLARE @databasename varchar(200)<br />DECLARE @databaseDATA...
hmm. It looks like rlahoty is right on this..<br />I can do it like this and it works:<br /><pre>EXEC ('ALTER TABLE master.dbo.DataBaseSizeFollowup...
Why do I get an errormessage when I run: EXEC ('ALTER TABLE master.dbo.DataBaseSizeFollowup ADD TEST-1_DATA [INT] NULL') But when I run: EXEC...
I should first start to say that I'm quite new to all this with MS SQL... What I did was to take the text in the post by ykchakri and pasted it in...
Thanks for the quick reply!! (less than 45 minutes, i'm impressed!!!) Haven't been able to test this (on vacation now sitting on the beach posting...
What I would like to have is some sort of scheduled job runnig that takes the sizes of all the databases and transactionlog-files and put in a...
Separate names with a comma.
