Viewing 15 posts - 1,126 through 1,140 (of 1,790 total)
So when you walk through the ODBC configuration for that DSN and you get to the end what happens when you hit the TEST button? Curious.
Not familiar with Sybase...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 7, 2008 at 8:12 am
cemmeke (10/7/2008)
give you any sample for 'remote folder address' ?
thanks
\\YourServerName\YourShareName\ should work.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 7, 2008 at 7:50 am
Ultimately this is an ODBC configuration issue with the link being to Sybase. So, open control panel, administrative tools, Data Sources. Find the data source associated with the error and...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 7, 2008 at 7:41 am
Ya know, I fought for 3 years at a company to prove that SQL Server could compete with Oracle (actually not only did I prove it but proved it could...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 7, 2008 at 7:05 am
The MS documentation for creating linked server and the associated security is a good place to start. http://msdn.microsoft.com/en-us/library/ms175537(SQL.90).aspx
Getting the security right with the linked servers can be a bit more...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 6, 2008 at 3:44 pm
Woo Hoo! Huge sigh of relief on my end as well. Glad to be of help.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 3, 2008 at 11:09 am
Hope you find it as I am just about out of ideas.... 😛
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 3, 2008 at 10:56 am
Just a guess but there might be a "PriceList" table that would then contain more information that those ID's would relate to which the application would then build it's select...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 3, 2008 at 10:48 am
Being that this is only one table I might have assumed something incorrectly. However, you mention that there are id's 3, 13, and 14. What do they relate to and...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 3, 2008 at 10:34 am
...or,
select db_name(dbid), count(*) from sys.sysprocesses
group by db_name(dbid)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 3, 2008 at 10:13 am
Getting the exact moment could be pretty tricky. There are clearly scripting methods to "query" windows services, which SQL Agent is, but even the best of monitoring apps do that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 3, 2008 at 10:08 am
My immediate question is whether those tables have an identity column on them and if so, did you do an insert with the original identity value in the previous table...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 3, 2008 at 10:02 am
Assuming that you have a datetime column on the table that is default based on the insert date / time then you could write a fairly simple query to do...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 3, 2008 at 9:58 am
Here are some links on scalability of ESX server primarily. Some rumors of IO issues that are addressed in the links.
http://www.vmware.com/products/vi/esx/esx_features.html
http://scottf.wordpress.com/2007/02/09/sql-server-on-vmware-server/
http://blogs.vmware.com/performance/2008/05/100000-io-opera.html
As with everything test. I did find the first...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 3, 2008 at 9:43 am
Sounds like you have some relational data issues, not corruption as Paul stated. How did you go about copying and what method did you use in order to ensure that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 3, 2008 at 9:38 am
Viewing 15 posts - 1,126 through 1,140 (of 1,790 total)