Sure,

Try this:

exec sp_msforeachdb '

select ''?'' as databasename

, @@version as version

, @@servername as servername

, databasepropertyex(''?'', ''IsPublished'') as IsPublished

, str(convert(dec(15),sum(size))* (select convert(varchar(11),low) from master.dbo.spt_values where type = N''E'' and number = 1)/...

Richard Edwards (3/19/2008)

---

We have encountered a situation where one of our developers has made changes to a schema (change of datatype) which has had a major knock on effect re...

El, try this:

select db_name() as databasename

, @@version as version

, @@servername as servername

, databasepropertyex(db_name(), 'IsPublished') as IsPublished

, str(convert(dec(15),sum(size))* (select convert(varchar(11),low) from master.dbo.spt_values where type = N'E' and number = 1)/ 1048576,10,2)...

adelan (3/19/2008)

---

Hi SQZ,

I appreciate your prompt reply and i understand you need more info.

The databases are police dbs and no of users is about 150 and will continue to increase,...

Hi Jay,

I'm not sure what the issue is here. You seem to know how to create a table so it's just a question of creating the table beforehand and...

In this case you'd need to ensure that you maintain the lock on TeamBalance when you do the select statement.

The updlock tells SQL Server to take out an update lock...

You could use xp_readmail to read mail from the SQL Mail box. However this is being deprecated in a future version of SQL Server.

That said, it looks like an...

Hi. This is a virtually impossible question to answer. There are so many factors that go into planning the hardware architecture required for any system

Questions like performance, how...

Niels Naglé (3/19/2008)

---

I agree with the posts posted above to put the most of work\logic in the query or the stored procedure before building your report.

The general problem of this...

imgflow (3/19/2008)

---

Hi

The issue is that i do not know with which table is is going to happen next - i seems to be any of the table carrying financial transaction...

Steve Hindle (3/19/2008)

---

Thanks for the great reply.

With the increase in log file size - the live log files (I have 2 ldfs) only total 3GB in size, but when I...

znkin (3/19/2008)

---

I am storing the balance of all teams in a sql table named TeamBalance. Table structure is

TeamId Balance

1 1000

2 2000

Now if a user belonging to Team 1...

In terms of finding out what happened there are some third party tools that will allow you to look at the transactions that went through the log file. This...

Hi Steve,

Unfortunately, if the database you've backed up has an 11 GB log file then there's no way to restore a database without logging. You could shrink the log...

There's a Previous( ) function you can use. The expression would look something like this.

=IIf (IsNothing(Previous(Fields!SomeField.Value))=1, [enter some value for condition evaluation to true], [enter some other value for...