Viewing 15 posts - 12,901 through 12,915 (of 39,964 total)
If you have the files in a CSV, then you can put a column at the right and use a formula for =LEN(A1) or whatever the column in.
To import into...
January 16, 2013 at 9:13 am
It's hard to understand if you are quoting something or stating something.
Full backups do not affect or break the log chain. The full backup can include part of the log,...
January 16, 2013 at 8:57 am
This kind of works, but I'm wondering if you've calculated something in this view already.
SELECT cid, COUNT(DISTINCT ccid)
FROM dbo.MyTable
GROUP BY cid
January 16, 2013 at 8:55 am
How are you getting the counts? are you basing this on the CCID column for a CID?
It's better if you can give DDL like this:
CREATE TABLE mytable
( CId int
, CCId...
January 16, 2013 at 8:54 am
You'd have to ask ArcServe. The SQL side should be fine. It doesn't matter where or how the backups are taken, as long as they are transactionally consistent with through...
January 16, 2013 at 8:49 am
Have you tried stopping and restarting the replication agent?
Can you connect from SSMS on one server to the other? Or with a Linked Server/OpenRowset just to verify there's no network...
January 16, 2013 at 8:47 am
You can use staging tables, or partitioning, if your edition supports it. Partitioning sounds like what you are thinking of.
January 16, 2013 at 8:45 am
When you looked through the data, do you mean in SSMS? Or did you query something like LEN()?
January 16, 2013 at 8:44 am
Never been to a GenCon or Comicon. Would like to give it a try if one comes close.
January 16, 2013 at 8:42 am
Miles Neale (1/15/2013)
January 15, 2013 at 9:47 am
aykut canturk (1/15/2013)
January 15, 2013 at 9:37 am
majorbloodnock (1/15/2013)
GSquared (1/15/2013)
The problem with the part I added emphasis to, is that quite often a company needs to hire a DBA because they don't have anyone who knows anything...
January 15, 2013 at 9:36 am
you may need to qualify as I mentioned:
USE [TrackIT]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[trUpdateBulkPurchases]
ON [dbo].[tblTransactions]
AFTER UPDATE
AS
BEGIN
UPDATE tblBulkPurchases
SET
PO_Number = i.PO_Number,
Quantity = i.Quantity,
Unit_Price = i.Unit_Price,
Software_Description = i.Software_Description,
PO_Date = i.PO_Date,
PurchaseCostCenter = i.PurchaseCostCenter,
HeatTicketNumber...
January 14, 2013 at 3:00 pm
Do you have an asterisk in your code? I thought you were using the to mark the place you were writing about.
No asterisks needed in your code.
January 14, 2013 at 2:32 pm
Viewing 15 posts - 12,901 through 12,915 (of 39,964 total)