Viewing 15 posts - 43,471 through 43,485 (of 49,571 total)
Duran (10/29/2008)
October 29, 2008 at 9:49 am
Can you post the entire error message please. SQL doesn't have a native error that refers to segmentation, so unless it's a user-defined error (error number > 50000), it's not...
October 29, 2008 at 9:42 am
You change the code so that it doesn't try to update the system tables. Then you run a checkDB to see how much mess there already is in the DB's...
October 29, 2008 at 9:40 am
You can set an end time when you create the trace. It's an optional parameter to the create trace proc.
What I typically do with the files is add the...
October 29, 2008 at 9:37 am
If all you want to do is remove the P character from the columns, then this will work
UPDATE SomeTable
SET SomeColumn = REPLACE(SomeColumn,'P','')
WHERE SomeColumn LIKE...
October 29, 2008 at 9:36 am
debbie.coates (10/29/2008)
If I did it this way, would I then have to define all the columns headings/size etc ?
Yes.
CREATE TABLE #MyTable (
....
)
If you don't want to type, then on a...
October 29, 2008 at 9:32 am
Hany Ahmad (10/29/2008)
Thx For your replay.what i m trying to do is that i need to cluster the database for recovery at the same time with performance.
Clustering is not a...
October 29, 2008 at 9:25 am
ALZDBA (10/29/2008)
Actually yesterday I ran into a pk having NULL for stats date, and the table contained +/- 9000 rows.A secondary index did have a stats date...
Coincidentally, I ran into...
October 29, 2008 at 9:22 am
Getting the date only is fairly easy
select dateadd(dd, datediff(dd,0, getdate()),0)
Easiest way to get the time is probably to convert the date to varchar and use substring to get the time...
October 29, 2008 at 1:52 am
It might, but then you'll have to reinitialise the replication. I'm concerned about that error recreating transactions from the log.
Just to be safe, can you run the following command...
October 29, 2008 at 1:45 am
It might. I don't know where reporting services stores its keys.
First check and see what's missing. If it is just the connection strings on the data sources, it shouldn't be...
October 29, 2008 at 1:26 am
nzubaria (10/28/2008)
Actually I am Developing a Database Auditing Infrastructure. I am working in SQL Server 2005.
So my main focus of area is "SQL Triggers" and "stored Procedures". I ask...
October 29, 2008 at 1:04 am
todd_dawson (10/28/2008)
October 28, 2008 at 3:39 pm
Wayne West (10/28/2008)
I'd like to see what the number of users who've posted in the last year is. But that's just me.
I'd hazard a guess that most of...
October 28, 2008 at 12:38 pm
What would the output be for the sample data given?
October 28, 2008 at 12:08 pm
Viewing 15 posts - 43,471 through 43,485 (of 49,571 total)