If you provide people an ASP form to change their password, then you could log the date they last changed there password. This form could also allow you to...

If you manually do one restore at a time it might take a while. This is why I have added onto our backup process to build the restore script...

Think something like this might work for you:

declare @t_time char(100)

set @t_time =86400

select dateadd(ss,cast(@t_TIME AS INT),CAST('1/1/1970' AS DATETIME))

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at...

There is no simple process of moving maintenance plans. Having said that it is really easy to do it manually, and if I needed to move maintenance plans around...

Seems to me that adding the column, is one function and adding the constraint is another. If you add the column, then chunk up the updates to set the...

From the command prompt you would type something like:

osql -S<servername> -U<username> -P<password> -i1.sql

There are many switches associated with osql. You can issue: osql -? to get a list of...

I'm assuming your problem is related to your development database. When you copied the database to the development box you also copied the database users. The database users...

You also could use the "OSQL" utility if you want to launch a SQL command for the OS command prompt.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out...

I don't think it is possible. But possibly your could rename the table(orig_table) to a new name, lets call it new_table, then create a view of the new_table, calling...

It is my understanding that when you do a transaction log backup the inactive portion of the transaction log is truncated. I'd do a search on "Using Transaction log...

I think you want some fault tolerance on your LOG disk. I might consider making the log and data disk (3 disks) a raid 5.

Gregory Larsen, DBA

If you looking...

Here are my stored procedures to send email use CDONTS, it supports attachments. I can't remember where I got this but, it might work for you (looks like someone...

Of course the GUI is easy, but the reality everything can't be done with the GUI. If the developers can't be trained to understand TSQL commands, then I...

Not that I am aware of. Of course you could always script out TABLE A and modify the script to create TABLE B.

Gregory Larsen, DBA

If you looking for SQL...

Typically transaction log growth is handled by periodically truncating the log. I would try to perform some action that truncates the log, at least daily. More frequent if...