Recent IT Questions

1 - 4 of 4
<<PREVIOUS 1 NEXT>>

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


1 - 4 of 4
<<PREVIOUS 1 NEXT>>