Database size limit of 4 GB in sql express 2005 only applies to Data file (.mdf) not for log files (.ldf)

As per MSDN

"The 4 GB database size limit applies...

Using DDL Trigger is the best option. Create an audit table and an audit trigger on that AuditTable at database level. You can capture all the schema changes in the...

simple example

create table tablename (

ObjectID int identity(1,1) not null constraint PK_Tablename primary key,

column2 int,

.

.

.

column N int

)

go

Thanks,

Amit Kulkarni

I suppose you will have to use the IN clause i.e.

.....WHERE Col1 = 'xyz'

AND Col2 in ( 'abc' ,'something' )

A Filtered Index can not use complex logic in its...

Hi Summit,

The local user is member of sysadmin role. So i suppose its not the issue with permission.

Thanks,

Amit Kulkarni

Hi,

There is a permission restriction for debugging TSQL in sql server

1) sql login must be a Windows user account

2) And secondly that account must be sysadmin role on the sql...

shrinking the log file involves following steps:-

For sql server 2005 version :-

Use [dbname]

go

Backup log[dbname] with truncate_only

go

dbcc shrinkfile(2,1) /* shrinking log file (file_id = 2) to 1 MB */

go

For sql server...

order doesn't matter. you can place it at any order.

Regards,

Amit kulkarni

Yes thats right.But i thought there may be an simple query to do that.

I dont want to use system tables to alter.

But i have heard in MySQl that this is...

i have already gone through the microsoft article....

i want encryption by password method.... i dont want to create certificates...

just creating keys, opening them.. assigning it to column(encrypt it)...

and finally decrypt...

thanks... i was able to get it

Regards,

Amit kulkarni

you cannot having columns other than one used in having clause...

never use select * from tablename when using having clause on one particular column...

you can use date Style numbers to convert to different date formats

here is an example for converting current date to different formats

select CONVERT( varchar(10), getdate(), 111 )

...