Multi Value Parameters

I just created a report with 2 parameters and it works fine. If I change one of them to MV it still works but if I pick 2 values I get a message about a problem with the "," - Incorrect syntas near ','

Is this a known problem or is it something I'm doing. Is a problem is there a fix for it.

YOu habe to change your query after changing the parameter type, as your query probably look like

WHERE SomeColumn = @.MyParameter

which will evaluate in a MV-Parameter to

WHERE SomeColumn = 'A','B'

This is not valid SQL. Therefore you to write your query like the one below.

WHERE SomeColumn IN (@.MyParameter)

That should work for you and your value list.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Works perfect - thank you.

Multi Row Insert

According to the CTP3 BOL the following code should work just fine, unfortunately is giving me the error message (below the code):

create table FamilyNames (

Id int identity,

[Name] varchar(30)

);

go

insert into FamilyNames values (

('Andersson'),

('Ben-Gan'),

('Carlsson'),

('Davidsen')

);

Msg 213, Level 16, State 1, Line 1
Column name or number of supplied values does not match table definition.

Does anybody know why this code fails?

Hi,

Try

insert into FamilyNames values

('Andersson'),

('Ben-Gan'),

('Carlsson'),

('Davidsen');

Kind regards,

Wesley

|||Thanks.

MSX/TSX question between SQL 2000 and 2005

Hi,
I have a SQL Server 2005 as a master server, I want to make a SQL Server
2000 default instance a target server, but it failed and the error message i
s
'The master server version 9.00.2047 is not compatible with the target serve
r
version 8.00.818'. Can we have a SQL 2000 server as a target server when we
have a SQL 2005 as a master server? If so, how?
Thanks for your help.So far i have not seen any documentation on mingling 2k and 2k5 MSX and
TSX services. I believe you would have to have both instances running
on the MSX server and have 2 complete MSX db's running.
Hong Wang wrote:
> Hi,
> I have a SQL Server 2005 as a master server, I want to make a SQL Server
> 2000 default instance a target server, but it failed and the error message
is
> 'The master server version 9.00.2047 is not compatible with the target ser
ver
> version 8.00.818'. Can we have a SQL 2000 server as a target server when w
e
> have a SQL 2005 as a master server? If so, how?
> Thanks for your help.

MSVCR70.dll

While trying to run Yahoo Browzer, Got I got a message saying MSVCR70.dll was not found. How can I get it fixed?

Rick

This does not look like a SQL Setuo question. Please post with more details if it is.

Thanks

Michelle

MSSQLServerOLAPServi - Server - 129

I have got SQL Server 2000 and 7.0 on a one computer with Windows NT Server. In the Event Log I received next message:
Source: MSSQLServerOLAPServi
Category: Server
ID: 129
There was an error during loading dimension Promotions in database FoodMart. Dimension file(s) may be corrupted or missing.
But the FoodMart database is sample database and we are't use this database.
Must I anything doing?
Michael S. Androsov
EXPOCENTR> I have got SQL Server 2000 and 7.0 on a one computer with Windows NT
Server.
> In the Event Log I received next message:
> Source: MSSQLServerOLAPServi
> Category: Server
> ID: 129
> There was an error during loading dimension Promotions in database
FoodMart.
> Dimension file(s) may be corrupted or missing.
> But the FoodMart database is sample database and we are't use this
database.
> Must I anything doing?
> Michael S. Androsov
> EXPOCENTR
--
Are you using Analysis Services 2000 at all? If so, you can simply
uninstall it.
Hope this helps,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

MSSQLServerADHelper

MSSQLServerADHelper failed to start with error code
1073741724 on the initial error message box. When going
into event viewer the error code for the failed service
is 3221225572.
I have tried restarting the service and restarting the
server but it still fails, I have also tried starting the
service with the Admin account.
Any advice would be much appreciated.
ThanksHello,
Theres something it doesn't like about the account. See
http://support.microsoft.com/default.aspx?scid=kb;en-
us;273499.
Try deleing then recreating it.
>--Original Message--
>MSSQLServerADHelper failed to start with error code
>1073741724 on the initial error message box. When going
>into event viewer the error code for the failed service
>is 3221225572.
>I have tried restarting the service and restarting the
>server but it still fails, I have also tried starting the
>service with the Admin account.
>Any advice would be much appreciated.
>Thanks
>.
>

MSSQLServer services

I'm running SQL 7.0 SP4 on NT 4.0. Each time i restart server, the sql
services just showing starting status for 2 minutes & gives error message "1
or more services failed to start". I have start the services manually. I've
tried to reinstall sql server but still the same. Kindly advice wht could be
the possible causes for this problem.
ThanksHi
What does the NT event log say? Any startup errors are logged there.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"chittana" <chittana@.discussions.microsoft.com> wrote in message
news:638D188B-8D35-4667-BFE3-0225BA31CB4B@.microsoft.com...
> I'm running SQL 7.0 SP4 on NT 4.0. Each time i restart server, the sql
> services just showing starting status for 2 minutes & gives error message
"1
> or more services failed to start". I have start the services manually.
I've
> tried to reinstall sql server but still the same. Kindly advice wht could
be
> the possible causes for this problem.
> Thanks|||Nope Mike. No startup error been logged in NT event log.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> What does the NT event log say? Any startup errors are logged there.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "chittana" <chittana@.discussions.microsoft.com> wrote in message
> news:638D188B-8D35-4667-BFE3-0225BA31CB4B@.microsoft.com...
> > I'm running SQL 7.0 SP4 on NT 4.0. Each time i restart server, the sql
> > services just showing starting status for 2 minutes & gives error message
> "1
> > or more services failed to start". I have start the services manually.
> I've
> > tried to reinstall sql server but still the same. Kindly advice wht could
> be
> > the possible causes for this problem.
> >
> > Thanks
>
>

MSSQLServer services

I'm running SQL 7.0 SP4 on NT 4.0. Each time i restart server, the sql
services just showing starting status for 2 minutes & gives error message "1
or more services failed to start". I have start the services manually. I've
tried to reinstall sql server but still the same. Kindly advice wht could be
the possible causes for this problem.
Thanks
Hi
What does the NT event log say? Any startup errors are logged there.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"chittana" <chittana@.discussions.microsoft.com> wrote in message
news:638D188B-8D35-4667-BFE3-0225BA31CB4B@.microsoft.com...
> I'm running SQL 7.0 SP4 on NT 4.0. Each time i restart server, the sql
> services just showing starting status for 2 minutes & gives error message
"1
> or more services failed to start". I have start the services manually.
I've
> tried to reinstall sql server but still the same. Kindly advice wht could
be
> the possible causes for this problem.
> Thanks
|||Nope Mike. No startup error been logged in NT event log.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> What does the NT event log say? Any startup errors are logged there.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "chittana" <chittana@.discussions.microsoft.com> wrote in message
> news:638D188B-8D35-4667-BFE3-0225BA31CB4B@.microsoft.com...
> "1
> I've
> be
>
>

MSSQLServer services

I'm running SQL 7.0 SP4 on NT 4.0. Each time i restart server, the sql
services just showing starting status for 2 minutes & gives error message "1
or more services failed to start". I have start the services manually. I've
tried to reinstall sql server but still the same. Kindly advice wht could be
the possible causes for this problem.
ThanksHi
What does the NT event log say? Any startup errors are logged there.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"chittana" <chittana@.discussions.microsoft.com> wrote in message
news:638D188B-8D35-4667-BFE3-0225BA31CB4B@.microsoft.com...
> I'm running SQL 7.0 SP4 on NT 4.0. Each time i restart server, the sql
> services just showing starting status for 2 minutes & gives error message
"1
> or more services failed to start". I have start the services manually.
I've
> tried to reinstall sql server but still the same. Kindly advice wht could
be
> the possible causes for this problem.
> Thanks|||Nope Mike. No startup error been logged in NT event log.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> What does the NT event log say? Any startup errors are logged there.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "chittana" <chittana@.discussions.microsoft.com> wrote in message
> news:638D188B-8D35-4667-BFE3-0225BA31CB4B@.microsoft.com...
> "1
> I've
> be
>
>

MSSQLServer

Hi
I have created a ghost of a system running SQL server 7 (on windows 2000 server)
When I try and start MSSQLServer I get the message
Your SQL Server installation is either corrupt ot has been tampered with (unknown package id).
Any ideas on how I can fix this without rerunning setup
Thank
ConorRe-run setup. See http://www.karaszi.com/SQLServer/info_change_server_name.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Conor" <anonymous@.discussions.microsoft.com> wrote in message
news:479704EB-01A0-4AF2-BCB0-5D699ECD2ABA@.microsoft.com...
> Hi
> I have created a ghost of a system running SQL server 7 (on windows 2000 server).
> When I try and start MSSQLServer I get the message:
> Your SQL Server installation is either corrupt ot has been tampered with (unknown package id).
> Any ideas on how I can fix this without rerunning setup.
> Thanks
> Conor|||This is correct. SQL Server 7.0 does not support ghosted installations.
Rand
This posting is provided "as is" with no warranties and confers no rights.

MSSQL Server 2005 reported account locked out for user 'sa'

Greetings,

I receive an error message in event log when i try to connect to the Database Server using ODBC on a client machine. The database server is running on Windows 2003 Server Standard Edition and the client machine is Windows XP Professional. Following is the error message from the event log:

2147467259 - [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it.

What causes the error to occur and how to resolve it?Appreciate for your assistence.

Thanks and regards,

Viknes

That error message means that the number of unsuccessful attempts to connect as the ‘sa’ account on your server and triggered the lockout policy on SQL Server 2005 for this account.

I would recommend verifying the logs and trying to find out the reason why the account was locked out. It is possible that one of your applications is using an outdated password and it needs to be fixed, but it may also be possible it was an automated attack trying to guess the SA password.

The following links will hopefully help you to resolve your problem, but if you have any further question or if the documentation is not clear enough, please let us know:

· Password Policy (http://msdn2.microsoft.com/en-us/library/ms161959.aspx)

· Alter Login (TSQL) (http://msdn2.microsoft.com/en-us/library/ms189828.aspx)

· Changing password programmatically (http://msdn2.microsoft.com/en-us/library/ms131024.aspx)

-Raul Garcia

SDE/T

SQL Server Engine

|||Also remember that SQL Server accounts can now use Windows Security policies on whiche SQL Server is running(Password complexity, password expiration, etc.) This only works for Windows Server 2003