Lokesh Vij (7/26/2012)

---

Are you looking for something like this:

CREATE TABLE [productsalesRanked](

[rank1] [bigint] NULL,

[unitssum] [float] NULL,

[nvarchar](5) NULL,

[ProductSalesPopularityID] [int] NOT NULL,

[categoryid] [int] NOT NULL,

[ProductID] [int] NOT NULL,

[UnitsSold] [int] NULL

);

INSERT INTO productsalesranked...

Hey, you are at least trying to make it easy for others. 😉

SQLTestUser (7/26/2012)

---

I changed the trigger but the trigger is still now working , any suggestions ??

CReate Trigger [AddDate] on [dbo].[Status]

for Update,Insert ...

EL Jerry (7/26/2012)

---

L' Eomot Inversé (7/26/2012)

---

Sean Lange (7/26/2012)

---

How many people don't share a last name with their PATERNAL grandfather? Only unmarried women, or those that chose not to take their...

The only thing you will find regarding the job in MSDB is that the job was cancelled. There is no signal back to record that a rollback was done.

Vikrant S Patil (7/26/2012)

---

it looks like the job did not run today because you specified in the schedule that it should run on day 1 of every month.

This means that...

You can also restore a weekly copy of the database on another server and run CheckDB against it.

SQLRNNR (7/26/2012)

---

Lynn Pettis (7/26/2012)

---

Did you take a close look at how Jeff's split routine was...

Did you take a close look at how Jeff's split routine was modified? His routine...

If you aren't backing up the t-log, then why is the database using the full recovery model? You could just as easily use the simple recovery model.

The way you...

Looks like you could also use a database snapshot as the source updating the underlying database as well. Note, I'm not saying to revert to a database snapshot, but...

The error message says it couldn't create the backup subdirectory. That leads me to a space issue or a permissions issue. Not much else I can suggest.

msjust (7/26/2012)

---

We are using Litespeed(version 6.5.2.1042) for our backups. Just recently we started getting the following error message:

Quest.LiteSpeed.UI.Wrappers.UIHistoryItemMessage:

Executed as user: XXXXXXX\XXXXX. ...on 9.00.5000.00 for 64-bit Copyright (C) Microsoft...

Jpotucek (7/26/2012)

---

SELECT * FROM iaxChecksCurrent

WHERE

CONVERT(DATE,UploadDate) = '2012-07-18'

gives me this:

Msg 243, Level 16, State 1, Line 1

Type DATE is not a defined system type (I neglected to say I...

Here is another way to it:

WITH CTE AS

(

SELECT

name as TableName,

object_id

FROM sys.tables WHERE...