You found WHAT article?

If you drop a table from replication and the column is no longer needed, why don't you just drop the column?

-SQLBill

Jasmine,

Again, most countries do NOT have laws that concern computers. You cannot arrest/prosecute someone from another country for something that country doesnot have laws for.

Yes, we may be...

Ah!!!!!!!!!! I had no idea what you were talking about (I rarely go to the forum home. I just click on Active Topics in the menu). Cool change. I...

At my last job, I created scripts that ran DBCC INDEXDEFRAG on each table separately. I would run DBCC SHOWCONTIG, then based on that, I would run the necessary...

Okay, let's create a checklist.

1. Which one is a maintenance plan and which is a user-created job?

2. Is the transaction log backup job trying to backup databases that are in...

1. What have YOU come up with so far?

2. Why is there a requirement for a temporary table?

3. The way this is worded, especially the part about requiring a temporary...

Very basic information.

1. DBCC DBReindex: locks up the tables and users may not be able to access the data until the reindex is done. Bottom line - this drops the...

I don't quite understand what you are saying/asking. But...

Why did you refresh the job? Was it running?

Something happened to or with that job. Right click on the job, select...

Which product are you talking about? Microsoft Access? If so, you have to realize that SQL Server is commonly linked to Access databases and Access is commonly used as a...

Jasmine,

So you support committing a crime to stop something legal but that you don't like?

QUOTE: If they are operating in some lawless country, then I have no problem sending in...

There is a lot of malicious code that propagates via home computers to businesses. If you count the number of business computers and compare it to the number of...

It probably has to do with 'backwards/forwards' compatibility. SQL Server 2005 has more security built into it than SS2000. It also has more features than 2000. That's probably why you...

Compare:

SELECT SSN, MAX(dateid) AS Date2 from dbo.empdata GROUP BY SSN

to:

SELECT DISTINCT SSN, MAX(dateid) AS Date2 from dbo.empdata GROUP BY SSN

See if that helps....

-SQLBill

And where in your script are you narrowing it down to ONLY DISTINCT SSNs????

Run JUST the inner select "SELECT SSN, MAX(dateid) AS Date2 from dbo.empdata GROUP BY SSN" and see...

You have to realize, as Mark pointed out, that the DST fix is ONLY so that the OS changes the time on the correct day(s). That's all it's for. Without...