Error message in Query Analyzer on SQL Server 2005
I am trying to run the following command in Query Analyzer on SQL Server 2005:use tempalter user [MY-LP79EFIWXO93login_a] with login = [MY-LP79EFIWXO93login_b]However, I keep receiving this error:Msg 102, Level 15, State 1, Line 3Incorrect syntax near 'login'.Why might this be?
View Answer
| Aug 19 2008 8:08 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, SQL Query Analyzer, SQL Server errors
Running a stored procedure in SQL Query Analyzer or as part of a SQL job
I have been trying to run a stored procedure in SQL Query Analyzer and as a step in a SQL job. If I run it in Query Analyzer, it takes less than a minute, but it takes considerably longer if it is run as a step. I use SQL Server 2000. Why would there be so big a difference?
Answer Question
| Jul 11 2008 2:52 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2000, SQL Query Analyzer, Stored procedures
Execution time is varying with query analyzer and visual studio 2005
when a stored procedure is executed in query analyzer its working fine and getting the result quickly.but when same procedure is executed through visual studio timeout expired error is generated.can any one olve this issue
View Answer
| May 21 2008 6:24 AM GMT
| asked by
Abcp
Visual Studio, SQL Query Analyzer, SQL
datetime conversion
SQL Analyzer has issues w/below relative to the datetime conversion- - what is the problem?convert(varchar(10),ft.postdate,101) 'PostDate',
View Answer
| May 5 2008 3:31 PM GMT
| asked by
Mictip
SQL Query Analyzer, DateTime
