Just to let any repliers to this topic know...Nelson posted this question twice. There are two GENERAL forums and this is in both. The other forum has the solution.

For those...

I suggest reading the Books OnLine (refered to as BOL). It installs with SQL Server (Go to START>Programs>Microsoft SQL Server>Books OnLine).

Go to the Index tab and enter:

BACKUP DATABASE

Read the information...

As alphaindex pointed out, INSERT creates a new row each time. You can solve it via alphaindex's solution or change your second INSERT to an UPDATE.

INSERT to create the row...

jmowery,

Nope not in a cave, but I have seen this occur when you hit Post New Reply and it seems to hang or not accept the post. Then you select...

Concerning the advertisements:

Please check today's (9 July) "BOOGIE TOOLS" advertisement on the left side of the site. While you are checking it out, try and 'hover' over RESOURCES in the...

If SQL Server Agent service is grayed out in EM, I'm guessing it might be a permissions issue. Did you set the service permissions as administrator on the domain?

-SQLBill

I currently have one table that has 734,371,580 rows. I don't see any problems/slowness because of the size.

-SQLBill

Concerning the date issue.

It depends on what you are doing with the date data.

For example:

Let's say you are trying to input a date...

01/28/03

SQL Server doesn't know how to interpret...

How was authentication set up? Windows Authentication only or Mixed Mode?

If Windows Authentication only, then I'm guessing you have a DOMAIN ACCOUNT with SQL Server and since you are no...

I would have also checked db_denydatawriter.

Does this person need to see ALL of the tables/columns in the database? If not, you might consider creating a view.

-SQLBill

If you go with the binder idea, I have two suggestions that will keep costs down.

1. Don't supply a binder.

Let the purchaser buy the binder of their choice. It will...

If TEMPDB reaches it's limit, pretty much everything stops. TEMPDB is used for just about everything SQL Server does.

Do you have a way to move TEMPDB onto another set of...

Maybe use an IF statement.

IF

mydate > getdate()-730

THEN

SELECT <columns>

FROM main_database

ELSE

SELECT <columns>

FROM history_database_view

The getdate()-730 would give the date 2 years (730...

BTW- I just found this cool page of information on this site.

http://www.sqlservercentral.com/columnists/dPriyankara/versionservicepack.asp

Specifically, it shows the use of

SELECT SERVERPROPERY('productlevel')

That will return the 'readable' version of your SQL Server product. I ran...

Run this query:

select @@version

Then take the results and compare them to the list at:

http://www.sqlsecurity.com go to the SQLSecurity Checklist.

This list is also on Microsoft's site and it might be on...