Viewing 15 posts - 42,871 through 42,885 (of 49,566 total)
I'm not sure that works properly.
DECLARE @Table1 (X int, Y int, Latitude float, Longitude float)
insert into @Table1 values (1,1, 90,0) -- the north pole
insert into @Table1 values (2,2, 52,0)...
November 27, 2008 at 12:06 pm
Could you start a new thread with that question in the performance forum?
Standard forum etiquette is to post a question in a new thread, with a descriptive title, so that...
November 27, 2008 at 10:57 am
I'd recommend you run a checkDB on that database asap. Make sure your backups are available and you know what your recovery options are. How long have you been getting...
November 27, 2008 at 10:38 am
Perhaps change the jobs on both principal and mirror to check the status of the DB before backing it up. So
IF (select DATABASEPROPERTYEX('AdventureWorks', 'Status')) = 'Online'
Backup database AdventureWorks to disk...
November 27, 2008 at 10:16 am
Do you know where the error's occuring? The error message should include the line number. Can you run the function im Query analyser and post the full error message, including...
November 27, 2008 at 9:30 am
select @startbase = convert(datetime, convert(char(2), datepart(d, @startdate)) + '-' +
convert(char(2), datepart(m, @startdate)) + '-' +
...
November 27, 2008 at 8:54 am
Then find the job that runs the log backups. In the properties of the job step (second tab) there's an option to log output to a file.
November 27, 2008 at 8:43 am
And his environment is a 24x7, no downtime, no data loss environment.
I wonder how much longer it's going to last..... 😀
November 27, 2008 at 8:40 am
Is upgrading to SQL 2008 an option? There are geospatial data types built in and solving your problem there would be trivial.
pseudo-code:
DECLARE @g geography;
SET @g = geography::STPointFromText('POINT(30.0045, -93.8824)', 4326);
SELECT MIN(GeographyColumn.STDistance...
November 27, 2008 at 8:35 am
That should not be possible. Running as sa is definitely not recommended. Too many security problems.
Can you please post the udf so that maybe someone can spot the root problem?
November 27, 2008 at 8:33 am
It could be worse. Like this one - developer background, now a senior DBA, depends on forum answers to do their job
Train wreck waiting to happen.
If you want some laughs,...
November 27, 2008 at 8:20 am
There's an option within the maint plans to log all output to a file. If you do that, what's the exact error that you get?
November 27, 2008 at 8:10 am
I'll help you if you can answer my questions please. Right now I don't know what you're trying to do or what errors you're getting.
Why are you trying to restore...
November 27, 2008 at 8:06 am
I started posting on this forum because I wanted to improve my own SQL skills, and trying to figure out other people's problems seemed like a good way to do...
November 27, 2008 at 7:42 am
Anything in the SQL error log from around the same time?
November 27, 2008 at 7:41 am
Viewing 15 posts - 42,871 through 42,885 (of 49,566 total)