Books Online (the documentation with SQL Server...

mr_omid (4/4/2008)

---

Hi,

I have a question about backups that are taken whilst updates or inserts are running in SQL 2005. If there is a job that runs from 1am-2am that...

Some more information (or proof :))

http://msdn2.microsoft.com/en-us/library/ms187956.aspx

From this page:

Regards,

Andras

Ratheesh.K.Nair (4/4/2008)

---

Hi experts

Is it possible to create a view...

The short answer is no. It could be possible via extended stored procedures, which you can write in C, then use JNI, but this would be a pain and would...

Backup, then restore...

Steven Coleman (4/3/2008)

---

Could somebody please assist with this query, I am trying to update a timestamp for a record, if the record is edited(Updated), as the trigger stands below it...

Well, you have forgotten the where clause in your update statement 🙂

You need to check that the updated record is in your "inserted" or "deleted" table (these contain all the...

jason.stinson (4/3/2008)

---

Running SQL 2000, can you change the DB Owner from dbo to whatever you want through Enterprise Manager, or do you HAVE to run a script? If you...

Michael Niemand (4/3/2008)

---

just to make sure I understood that right:

I schedule the following steps

-Full Backup at lets say 00:00

-Log Backup with INIT at 00:30

-Log Backup with NOINIT every hour, starting...

If you want to use init, then you could create 24 log backup files, and every hour you would back up to the relevant file only. You will have only...

raja_saminathan (4/3/2008)

---

Hi Girish,

Thanks for your Kind Information.

Well i tried to use the simple Insert into Query ,but i didn't get the things .

For Eg:

I have two tables with same...

raja_saminathan (4/2/2008)

---

Hi,

Can Any body help me by providing ideas in the following:

I want to transfer the datas in the table from one database to other newly updated database which contains...

It actually costs to increase you transaction log file size frequently and the physical file can become fragmented, etc. Why are you trying to shrink it? I.e. if it will...

You are trying to create a procedure (CREATE PROCEDURE dbo.CLR_Common_ReplaceChar)

You cannot do this for methods that return other than ints. I assume you want to create a UDF, so you...