This should be fairly easy to do in SQL, but you really haven't really explained the rules for when the manufacturing year and manufacturing month start, so we can't really...

What did you find when you looked it up in SQL Server 2005 Books Online?

fuzzy528 (10/30/2009)

---

thanks a lot for that. it works well except for the part where it shows month as 13 for january and 14 for febraury and so on. it wud...

declare @from_month int

declare @months int

select @from_month = 6, @months = 11

set nocount on

declare @t table (num int not null primary key clustered)

insert into @t

-- Just a quick and dirty number...

Run this query to see the size of each database file, used space, and unused space.

select

[FileSizeMB]=

convert(numeric(10,2),round(a.size/128.,2)),

[UsedSpaceMB]=

convert(numeric(10,2),round(fileproperty( a.name,'SpaceUsed')/128.,2)) ,

[UnusedSpaceMB]=

convert(numeric(10,2),round((a.size-fileproperty( a.name,'SpaceUsed'))/128.,2)) ,

[DBFileName]= a.name

from

sysfiles a

Results:

FileSizeMB UsedSpaceMB UnusedSpaceMB DBFileName

------------ ------------ -------------...

Do not store passwords in a table. Create hashes of the passwords and store the hash. That way, the password cannot be recovered from the value in the...

Use an OUTPUT clause to return the rows that were updated, and add a WHERE clause to only update rows that should be changed:

DECLARE @Output_MyTable table

(

MyTablePKintprimary key clustered,

Before_FULLNAMEvarchar(50),

After_FULLNAMEvarchar(50)

)

UPDATE MyTable

SET

FULLNAME =...

use master

alter database [MyDatabase] set offline with rollback immediate

alter database [MyDatabase] set online

They could have the camera there because they are annoyed by people dropping off their kids blocking traffic, blocking their driveway, denting their car, making noise, etc.

Even if you have concerns, what can you really do about it?

Are there any laws that restrict where a security camera can be pointed when it is an outside area?

Gift Peddie (10/27/2009)

---

Hi Michael,

I have to agree with Microsoft because SSRS usually randomly reject normal T-SQL code and to resolve most problems it generally throws strange execution context errors which...

bump

I suggested this because you can find info in the trace that the report does not...

Object changes are captured by the default trace, so you should be able to find the information there.

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

This script will truncate tables that are not referenced and delete the data from tables with foreign key references and then reseed the identity columns.

Truncate All Tables

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65341