You seem to be under the impression that you can restore the full database and then restore a differential backup of the one filegroup for your critical data. That...

You should be more concerned by who is a member of the Administrators group than the access that the Administrators group has on the local machine.

The Administrators group has numerous...

You can gain access to SQL Server 2005 by adding your Windows login to one of the following local groups on the server , depending on if it is default...

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