Viewing 15 posts - 61 through 75 (of 271 total)
The develope & express versions of sql server do not by default allow remote connections.
Start sql server configuration manager, expand sql server network configuration, click protocols for...
Then on right hand...
January 29, 2007 at 12:46 pm
Couple of things first its much better to use sp_executesql than exec as you can then parameterise the query and its much more likely that the plan will be reused...
January 28, 2007 at 6:02 am
Kirk you can try this - excerpt of a previous post I made on this
There is one thing you may need to check first and thats the...
January 24, 2007 at 2:37 pm
Using windows performance monitor you can monitor
Network Interface: Output Queue Length
Should not exceed 2 for continuous periods i.e. over 10 minutes in a 24 hour period.
hth
David
January 24, 2007 at 2:25 pm
You have not included the table gentiva1206 in the from part of the query so you cannot reference it like this in the where clause.
I'm not totally sure what you...
January 23, 2007 at 12:08 pm
Bummer it just ate my reply.
Anyway all I was going to mention was why not the 64bit version of srever 2003 standard with thee 64 bit version of sql server...
October 5, 2006 at 5:06 pm
There is not a simple answer to this as it depends on both the load being applied to the server and the type of load. I have found personally that...
October 5, 2006 at 1:12 pm
In 2005 the definitions are stored in sys.sql_modules which you will need to join with sys.objects.
In 2000 its sys.comments
hth
David
September 12, 2006 at 9:10 am
isql is not supported in SQL 2005 you should use sqlcmd instead you can find details of how to use it in BOL
hth
David
September 9, 2006 at 4:42 am
There is a column name page_verify_option in this view anyway try the following query
select
name, page_verify_option, page_verify_option_desc
August 30, 2006 at 7:00 am
I am running sql server 2005 and the table dbo.sysjobactivity exists within it but maybe it does not on previous versions
hth
David
August 25, 2006 at 3:11 pm
In the msdb database if you query sys.jobs and sys.jobactivity and join them on the job_id and query for any jobs which have a start_execution and date and NULL for...
August 25, 2006 at 7:30 am
How about using using the CEILING Function
e.g. from BOL
SELECT CEILING($123.45), CEILING($-123.45), CEILING($0.0)
GO
--------- --------- -------------------------
124.00 -123.00 0.00
hth
David
August 24, 2006 at 4:13 pm
I think your problem is that by default truncation of a column will produce an error you need to change it so that truncation does not produce an error. You...
August 24, 2006 at 4:10 pm
You need to use a wee bit of dynamic sql something like this should work
DECLARE
@sp_name varchar(128)
DECLARE
...
August 24, 2006 at 12:32 pm
Viewing 15 posts - 61 through 75 (of 271 total)