A full backup does not truncate the transaction log. This is only done by a backup log (transaction log backup). Also, please understand that a log truncation is...

JakesterUK (11/11/2009)

---

I am fairly sure the SP is as optimised as it can be, however, I've posted it below: -

ALTER PROCEDURE CheckContext

@CxID int,

...

Assuming that SSMS is running on your PC and you can connect to the SQL Server instance in question from SSMS, in a query window run this:

select @@servername

It would help if you provided the actual error message you are getting.

Slightly confused here, could you explain your problem a little more? It may help to have the DDL for the table involved plus any code you have already attempted...

It would help to see the actual code, the DDL for the tables involved, some sample data for the tables involved, and finally the expected results based on the sample...

Does this code help you?

declare @MyDate datetime;

set @MyDate = getdate();

select convert(varchar(30), @MyDate, 113);

select case when datepart(hh, @MyDate) > 12 then replace(convert(varchar(30), @MyDate, 113), cast(datepart(hh, @MyDate) as varchar), cast((datepart(hh, @MyDate) -...

Are you sure you are trying to install SQL Server 2005 Standard Edition? It almost looks like you are trying to install a web edition.

Have you checked the setup...

Schemas can be used to simplify permissions for different users. For example, you could have schemas from Sales, Purchasing, Inventory; and the users in those departments could be granted...

This is basically the same question you asked here just worded slightly differently.

Same thing,...

Integer arthimetic. Do this:

select cast(73982597/1000000.0 as numeric(8,6))

Run this:

select name, log_reuse_wait_desc from sys.databases

What does the log_reuse_wait_desc say for this particular database?

SQL Learner-684602 (11/10/2009)

---

Hi

I am having an int column of length 8..

i have to convert it to Latitude/ longitude value bye using rule-

divide by 10 to the power 6..

but as...

From BOL:

6 = Replication

GilaMonster (11/10/2009)

---

Don't think so, but it's heavily weighted to the lower end.

There are 15 people...