Ninja's_RGR'us (12/7/2011)

---

Divine Flame (12/7/2011)

---

In short, you should use Table Variables when it has to contain very small chunk of temporary data (i.e. few rows only). If the temporary data size...

Edward-445599 (12/7/2011)

---

I am using the function ISDATE against column of type varchar which is a date in UK date format (dd/mm/yyyy) but the Database ‘s collation has the date format...

ericwenger1 (12/6/2011)

---

Just to give you more details, I got the replication happening continously. We shot down the idea of using log-shipping which would have been much easier because they wanted...

In short, you should use Table Variables when it has to contain very small chunk of temporary data (i.e. few rows only). If the temporary data size is huge, you...

Execute below command...

anandha31 (12/6/2011)

---

Dear Sujeet,

Thanks for your reply. Actually I want to know when data are inserting / updating / deleting into the table and by whom...

There is no self paced training kit available for 70-450, don't know when it will come :unsure:.

OR BTW, I forgot to ask, do you really want to create a log file i.e. (.ldf file) because your database has got corrupt OR you have only the data...

anandha31 (12/6/2011)

---

Dear All,

I need to create a log file in SQL Server 2008 which records the activities of the tables such as...

Go with Transactional Replication if you want your report server updated in real time.

However , as you said that your manager wants the report server to be updated every...

This is...

You are most welcome :-).

1. As the data is frequently inserted & deleted, get the fragmentation report beforehand so that you know when to rebuild the indexes proactively.

(You can schedule a job to get...

!= and <> are same, it just depends on your coding style, whatever you like :cool:.

As anthony said, you can...