As this is posted in a SQL Server 2005 forum, I am going to make a partial assumption, the primary server is running SQL Server 2005. What about the...

I can't really answer your questions either. We are just getting into WSS ourselves. I agree with getting training. I would also look for SharePoint Administration training...

clive (11/17/2008)

---

Found this added as a truncate job on customer SQL Server 2005,

can someone elaborate on this method of shrinking the log file.

use Mydatabase

go

DECLARE @DB VARCHAR(40)

SELECT @DB = 'Mydatabase'...

First of all, if your company has already purchased and deployed SQL Server 2005, they should provide you with the CD's or DVD's used to install SQL Server 2005 on...

ITHELP85 (11/16/2008)

---

WAREHOUSE acts as an inventory.

The Trigger should update the WAREHOUSE.ItemQty column. After testing the trigger I have came up with does not update the WAREHOUSE table correctly the...

You may want to talk to your supervisor or a coworker. You may not store backups on disk for more than 12 hours or so, based on your comment...

I'd start with reading Books Online about restoring the system databases. This is a good place to get basic information. From there, you can ask much more specific...

That looks close to what I have in my calendar view at work. I'll have to check it later, as I am at the Y right now and need...

Jeff,

You still haven't reposted your on-the-fly tally table for SQL Server 2005/2008. I'd be real happy to see that. I use a CTE version in a view (I...

Hey, so would I. I know I could have used a smaller decimal number based on the sample data, but sometimes you you just have to go with something...

Slight change to the code, and this seems to work:

create table #tmp

(id varchar(10))

insert into #tmp

select '10.10'

union all select '1010'

union all select '20.20'

union all select '2020'

select *, cast(cast(id as decimal(18,2))...

Hang on!! How can I get in on this and sell tickets?? I'll even give 75% of the proceeds to SSC!

Just for S & G's, I added another select statement to my test code. In it you will see that I use a case in the join. If...

Jeff Moden (11/14/2008)

---

Also, I never suggested making a Tally table on the fly... a permanent Tally table is really the way to go, in most cases. Exception to that...

Jeff,

Just gotta know, has anyone every called you an anti-rbar fanatic? This seems to be the main area you really become "excited" about. And NOT that it is...