Viewing 15 posts - 12,691 through 12,705 (of 26,486 total)
kodalisridevi (4/18/2012)
error Message :Invalid object name '#Orderstatics'. (.Net SqlClient Data Provider). I am getting
This is the complete error message? No line number, nothing on any additional line? Anything...
April 18, 2012 at 1:12 pm
Sean Lange (4/18/2012)
As I posted in the other thread. The timestamp datatype is deprecated. http://msdn.microsoft.com/en-us/library/ms182776%28v=sql.105%29.aspxUse datetime to record datetime information.
If I read the link correctly, timestamp may be going away...
April 18, 2012 at 1:06 pm
GilaMonster (4/18/2012)
Lynn Pettis (4/18/2012)
GilaMonster (4/18/2012)
Lynn Pettis (4/18/2012)
Also, mirroring would require both instances be the same version of SQL Server as well.No it doesn't.
Except for doing an upgrade a mirror needs...
April 18, 2012 at 1:03 pm
GilaMonster (4/18/2012)
Lynn Pettis (4/18/2012)
Also, mirroring would require both instances be the same version of SQL Server as well.No it doesn't.
Except for doing an upgrade a mirror needs to have the...
April 18, 2012 at 12:43 pm
Is that the complete and unabridge error message or is there more to it?
April 18, 2012 at 12:39 pm
Not enough information to really help.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ and follow the instructions on what information to post and how to post it. The more information you provide,...
April 18, 2012 at 12:29 pm
Your code looks like Oracle. DECODE is not part of MS SQL Servers T-SQL language.
April 18, 2012 at 12:27 pm
Duplicate post. Please post replies here.
April 18, 2012 at 12:24 pm
Not enough information to really help.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ and follow the instructions on what information to post and how to post it. The more information you provide,...
April 18, 2012 at 12:23 pm
First question, although your experience is with SQL Server 2005, what have you done recently to ensure your skills will work with SQL Server 2008? Let me also ask...
April 18, 2012 at 12:18 pm
Have you setup database mail for SQL Server Agent? IIRC, this is a separate step from just setting up database mail. Sorry if I'm not sure, but it...
April 18, 2012 at 11:57 am
capn.hector (4/18/2012)
Lynn Pettis (4/18/2012)
Childishman-boy-ish
infantile 😀
April 18, 2012 at 11:51 am
dsohal (4/18/2012)
Thanks I will do that,
Do what? From what I have read in this thread it looks to me that replication is the best choice for what you are...
April 18, 2012 at 11:50 am
capn.hector (4/18/2012)
Lynn Pettis (4/18/2012)
SQLRNNR (4/18/2012)
Lynn Pettis (4/18/2012)
Here is a our first challenge. No one should post again until we get what has been requested.
that kind of blatant hijacking needs...
April 18, 2012 at 11:48 am
Your join was wrong. I flipped the view and table and it looks like it works based on the sample data provided.
select
*
from
...
April 18, 2012 at 11:46 am
Viewing 15 posts - 12,691 through 12,705 (of 26,486 total)