Viewing 15 posts - 42,871 through 42,885 (of 49,571 total)
rbarryyoung (11/27/2008)
Actually, Plan Guides might be able to do this. Unfortunately, I missed that session at PASS.
Only if a hint will help the query, and only if its one...
November 28, 2008 at 12:23 am
lrams99 (11/27/2008)
Hi GuysIf you have any idea in this issue, Please give some tips onthis..and detailed process
Please post a new thread with your question and don't hijack a completely unrelated...
November 28, 2008 at 12:18 am
v.g.mujumdar (11/27/2008)
Please tell me why this message occured? is this error? How can I understand that my replication is running normally?
It's not an error. In transactional replication the snapshot's...
November 27, 2008 at 2:27 pm
Yup, because a proc doesn't have a defined output. It's possible to have a procedure that returns various different resultsets (or none at all) depending on parameters passed.
November 27, 2008 at 2:14 pm
Um... Did anyone notice that this thread is 4 and a half years old, and was answered accurately 10 days after it was posted?
November 27, 2008 at 12:17 pm
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
Viewing 15 posts - 42,871 through 42,885 (of 49,571 total)