Roy Ernest (5/27/2009)

---

GetDate is the function to get the current date. let us say you want to find out what is was the date 10 days back, it will be...

Ah...thank you so much!

Well, I guess I was kinda asking how to set a job like that up. Oracle has a sysdate() function that you can use to do date math. ...

I had to drop 3 views to get it working:

drop view dbo.AVIView_Sensors

drop view dbo.AVIView_Software

drop view dbo.AVIView_LeafNode

I have 2 Publications/Subscriptions. Using the GUI, I delete those, then disable the Distribution. I then rebuild the Distribution and the Publications/Replications. One works beautifully, the other...

Yes, it's the same database. I'm trying to replicate into and another database on the same sever, but only grabbing a few fields from the source. It's posted...

Thanks for all the help guys. I took some time off this weekend, came back and the log file is now up to 10Gb and the database is up...

Mayank Khatri (5/21/2009)

---

It means your transaction is no longer active now. What is the size of your Log file now? Can u post the results of Following two queries too?

[Code]

DBCC...

Mayank Khatri (5/21/2009)

---

When u run DBCC OPENTRAN, your result should be displayed as following:

Where the Bold one is ur SPID

Transaction information for database 'master'.

Oldest active transaction:

SPID (server process...

LOL! Ok, I'll bite. How do I find my spid? I'm from the UNIX world and not all that familiar with Windows.

Steve Jones - Editor (5/21/2009)

---

If this is in Simple mode (right click the database, properties, options), then you have an open transaction that is preventing space from being reused.

Run

dbcc...

SQLDBA (5/21/2009)

---

Unlimited growth is fine, the important part is in what increments is it growing, by MB, by %?

The database file is only 580MB?? I would presume it is...

unrestricted growth is turned on for...

Yes, it is. It is a high transactional server. Now up to 3.5Gb

I've gone into options and changed it to Simple. I have been running dbcc shrinkfile, truncateonly pretty much back to back since my last post. Windows Explorer is...