The growing transaction log can potentially create a space and data availability issue, so you have to handle this situation.

You have two different strategies how to handle it, and specific...

koustav_1982 (10/7/2009)

---

Hi

I have implemented transactional replication between 2 databases.On the target server i see that the replicated table's createdatetime becomes todays date everyday.

Does this replication drop and recreate everytime...

Irfan-358189 (10/6/2009)

---

Hi,

Is there any body who can give me simple nice scripts or any good tips for Proactively monitoring and maintaining production databases.

I know i can use sp_who2,sysprocesses,profiler,performance monitor but...

Is your network share still visible from a network after falover?

Did you check it?

SQL 2005 no longer...

That is correct, I pointed you to...

Yes, it could be many reasons for this issue.

If ping is fine, I would try connect by IP and port# instead of name.

Mike-448558 (10/6/2009)

---

Hi,

The configuration and execution of sql jobs is new to me and I would like to ask, if one can provide me with some information about the concept of...

You are welcome.:-)

USE REPLACE command to replace [ with #var. expression.:-)

REPLACE('[2001],[2002],[2003]','[','#var.')

You may want to declare your string as a variable.

Run this code to verify the result:

SELECT REPLACE('[2001],[2002],[2003]','[','#var.')

mbrady5 (10/6/2009)

---

Good Morning,

just want to make sure my query makes sense....pretty new to this stuff.

I have a table that I would like to update a column called 'status' to 'Expired'...

Holy, I did not know that Sergey! When I read through your comment, I was like.. "how does he selects all the procs" and I read again, and the damn...

Use this link to download it, but remember - CU3 is not the latest cumulative update:

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=967909&kbln=en-us

You can also do it without the maintenance plans.

http://support.microsoft.com/kb/930615

I think free_maskot is right.

Check the SQL Server service account credentials - account and a password.

Please also verify this account is not locked.