Replacement for SETUSER

Books Online says 'SetUser' is deprecated, but doesn't tell me what the
new way to change user contexts is. Am I not supposed to want to do
this, or is there some other way?
Thanks!
Ionit's execute as.
http://msdn2.microsoft.com/en-us/library/ms181362(SQL.90).aspx
-oj
<ionFreeman@.gmail.com> wrote in message
news:1141934114.006542.247290@.j52g2000cwj.googlegroups.com...
> Books Online says 'SetUser' is deprecated, but doesn't tell me what the
> new way to change user contexts is. Am I not supposed to want to do
> this, or is there some other way?
> Thanks!
> Ion
>|||Thanks, OJ. I'm using SQL Server 2000, however, for which Books online
doesn't mention an 'Execute As'. So, I'll just live with the fact that
it's deprecated in this version, but not replaced until the next.

Replace SA account name

I want to change the sa account and rights associated with it, while putting
in a new user that hides below the radar.
Anyone know the PHB real name?
This was a request out of a brain storming session or was a lunchtime BS
session? Either way I'm looking for a comic name. Second on my list is
Bill Watterson. So any other ideas?
TIAYou cannot modify the rights of the sa account. However, in SQL Server
2005, you can rename it.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"_Stephen" <srussell@.electracash.com> wrote in message
news:Oev4Ox1rGHA.3748@.TK2MSFTNGP04.phx.gbl...
I want to change the sa account and rights associated with it, while putting
in a new user that hides below the radar.
Anyone know the PHB real name?
This was a request out of a brain storming session or was a lunchtime BS
session? Either way I'm looking for a comic name. Second on my list is
Bill Watterson. So any other ideas?
TIAsql

REPLACE Arguments

Hi,

I'm trying to create a view that shows columns based on user access level. I would like to be able to test for different values without having to add a REPLACE command for each value.

For example,

My UserLevelID can be 1, 2, 3, 4 or 5. 5 is an Officer level so I have the following command:

REPLACE(m.UserLevelID, 5, 'Yes'') AS 'Officer',

The problem is that I want the field to be blank for this column if the value is 1, 2, 3 or 4. I've tried the following, but none work.

REPLACE(REPLACE(m.UserLevelID, 5, 'Yes''), IN(1,2,3,4), '') AS 'Officer'

REPLACE(REPLACE(m.UserLevelID, 5, 'Yes''), NOT 5, '') AS 'Officer'

REPLACE(REPLACE(m.UserLevelID, 5, 'Yes''), < 5, '') AS 'Officer'

Any suggestions? I know I can add a REPLACE function five times, but I have a few more uses for this so I would like to find the easiest method.

Thanks,

Lee

not context or sample DDL or data but how about something like

SELECT

CASE CAST(m.UserLevelID AS varchar(10))

WHEN '5' THEN 'Officer'

ELSE ''

END

|||

If you are going to reuse it, a more compact form is something like:

substring (' Yes', 1+3*(UserLevelId/5), 3)

as in the example:

declare @.test table ( UserLevelId integer )
insert into @.test values (1)
insert into @.test values (2)
insert into @.test values (3)
insert into @.test values (4)
insert into @.test values (5)

select UserLevelId,
substring (' Yes', 1+3*(UserLevelId/5), 3) as Indicator
from @.test

-- UserLevelId Indicator
-- --
-- 1
-- 2
-- 3
-- 4
-- 5 Yes

|||

You could have a small table with the UserLevedID and the replacement values, and then JOIN against that table. If you have several such 'replacements' (or lookups as they are often called), then you could add an additional column to specify the 'group' of replacements.

SET NOCOUNT ON

CREATE TABLE MyTable
( LookupGroup int,
UserLevelID int,
UserLevel varchar(20),
)
GO

A lot better and more robust than attempting to 'hard-code' a potentially changing list of values.

Replace - simple MDX question

I am using the following MDX statement to retrun data to populate a drop dow
n
list allowing the user to select a time period:
WITH
MEMBER [Measures].[DisplayName] AS
'SPACE([Period].CurrentMember.Level.Ordinal * 4) +
[Period].CurrentMember.Name'
MEMBER [Measures].[UniqueName] AS '[Period].CurrentMember.Unique
Name'
SELECT
{[Measures].[UniqueName], [Measures].[DisplayName]} ON
Columns,
[Period].Members ON Rows
FROM MyCube
The idea of the "SPACE([Period].CurrentMember.Level.Ordinal * 4)" bit in
the
first MEMBER declaration is to provide indentation to give a sense of the
hierarchy in the drop down list display.
I now need to serve a client application that doesn't allow leading spaces
in the drop down list display. Is there a function I can use instead of SPAC
E
to put an alterntive indentation character at the start?
For example, a hyphen. So the returned data would look something like:
ALL
--2004
--Qtr1
--Jan
--Feb
--MarWITH
MEMBER [Measures].[DisplayName] AS
'String([Period].CurrentMember.Level.Ordinal * 4, "-") +
[Period].CurrentMember.Name'
MEMBER [Measures].[UniqueName] AS '[Period].CurrentMember.Unique
Name'
SELECT
{[Measures].[UniqueName], [Measures].[DisplayName]} ON
Columns,
[Period].Members ON Rows
FROM MyCube
"Dave Morrow" wrote:

> I am using the following MDX statement to retrun data to populate a drop d
own
> list allowing the user to select a time period:
> WITH
> MEMBER [Measures].[DisplayName] AS
> 'SPACE([Period].CurrentMember.Level.Ordinal * 4) +
> [Period].CurrentMember.Name'
> MEMBER [Measures].[UniqueName] AS '[Period].CurrentMember.Uniq
ueName'
> SELECT
> {[Measures].[UniqueName], [Measures].[DisplayName]} O
N Columns,
> [Period].Members ON Rows
> FROM MyCube
> The idea of the "SPACE([Period].CurrentMember.Level.Ordinal * 4)" bit
in the
> first MEMBER declaration is to provide indentation to give a sense of the
> hierarchy in the drop down list display.
> I now need to serve a client application that doesn't allow leading spaces
> in the drop down list display. Is there a function I can use instead of SP
ACE
> to put an alterntive indentation character at the start?
> For example, a hyphen. So the returned data would look something like:
> ALL
> --2004
> --Qtr1
> --Jan
> --Feb
> --Mar
>

Repl works on VPN, not via internet

I am trying to setup a process in a VB.Net app that allows the user to manually invoke a transactional replication process. This works fine on my development machine within our network/VPN. However, when I disconnect my machine from the VPN, the process
keeps failing with a "Process could not connect to Distributor" error. Unfortunately, our customers/users will not be in our domain...they need to be able to connect & replicate over the internet.
Here is the current setup:
Server
Windows 2003 Server
Sql Server 2000 (sp3)
Client
Windows 2000 Pro or Windows XP Pro
MSDE
Also...from within the network I have to use only the server's name "MyServer" to get this to work. If I use a fully qualified name, like "MyServer.Domain.Com" it fails with the same error.
The server acts as both the publisher and the distributor. The publication is set up to allow anonymous pull subscriptions via FTP. I have a sql login that I have setup and made sure that it is in the Publications PAL.
I have used this example: http://support.microsoft.com/default...;en-us;Q319648 to create the .net process.
From a client machine...I can access the ftp site on the server via:
ftp Server.Domain.Com.
I cannot get to the server with Ping or Tracert. I was told by our network admin that the ability to Ping our server has been disabled.
I think that this must be a server configuration problem...since I can get the whole thing to work when I am on the network. I checked the log files (based on a suggestion from another post) on the server...and it doesn't even appear that a login is attem
pted.
Does anyone have any other suggestions?
thanks
when you are using a vpn you are able to authenticate using NT
authentication. This won't work over the internet. You will have to change
how you are authenticating for this to work.
If you can ftp you have connectivity.
Make the following changes
oSnap.PublisherSecurityMode = SQLINITXLib.SECURITY_TYPE.NT_AUTHENTICATION
to
oSnap.PublisherSecurityMode = SQLINITXLib.SECURITY_TYPE.DB_AUTHENTICATION
oSnap.PublisherPassword="password"
oSnap.PublisherLogin="account"
change
oSnap.DistributorSecurityMode =
SQLINITXLib.SECURITY_TYPE.NT_AUTHENTICATION
to
oSnap.DistributorSecurityMode =
SQLINITXLib.SECURITY_TYPE.DB_AUTHENTICATION
oSnap.DistributorPassword="password"
oSnap.DistributorLogin="account"
Repeat these changes everywhere you see NT_AUTHENTICATION.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"dd" <dd@.discussions.microsoft.com> wrote in message
news:BBA7CF14-42B4-417C-8C4D-A422D520EA0B@.microsoft.com...
> I am trying to setup a process in a VB.Net app that allows the user to
manually invoke a transactional replication process. This works fine on my
development machine within our network/VPN. However, when I disconnect my
machine from the VPN, the process keeps failing with a "Process could not
connect to Distributor" error. Unfortunately, our customers/users will not
be in our domain...they need to be able to connect & replicate over the
internet.
> Here is the current setup:
> Server
> Windows 2003 Server
> Sql Server 2000 (sp3)
> Client
> Windows 2000 Pro or Windows XP Pro
> MSDE
> Also...from within the network I have to use only the server's name
"MyServer" to get this to work. If I use a fully qualified name, like
"MyServer.Domain.Com" it fails with the same error.
> The server acts as both the publisher and the distributor. The
publication is set up to allow anonymous pull subscriptions via FTP. I have
a sql login that I have setup and made sure that it is in the Publications
PAL.
> I have used this example:
http://support.microsoft.com/default...;en-us;Q319648 to create
the .net process.
> From a client machine...I can access the ftp site on the server via:
> ftp Server.Domain.Com.
> I cannot get to the server with Ping or Tracert. I was told by our
network admin that the ability to Ping our server has been disabled.
> I think that this must be a server configuration problem...since I can get
the whole thing to work when I am on the network. I checked the log files
(based on a suggestion from another post) on the server...and it doesn't
even appear that a login is attempted.
> Does anyone have any other suggestions?
> thanks
|||Hilary...
Thanks for the reply. It is good to know that if I can connect via ftp I am doing something right.
Actually, I already made those changes to the example code...changing from NT to DB authentication in each place it was occuring. Though...even on our VPN, I had to change the login and password to the "sa" account so it would work.
We do have a firewall...not sure if that is the problem. And...another note...I have another application running on a PocketPC (with the .Net Compact Framework) that is successful in a merge replication over the internet without using "sa" account...and
it is on the same database I am using for my transactional one that is failing.
"Hilary Cotter" wrote:

> when you are using a vpn you are able to authenticate using NT
> authentication. This won't work over the internet. You will have to change
> how you are authenticating for this to work.
> If you can ftp you have connectivity.
> Make the following changes
> oSnap.PublisherSecurityMode = SQLINITXLib.SECURITY_TYPE.NT_AUTHENTICATION
> to
> oSnap.PublisherSecurityMode = SQLINITXLib.SECURITY_TYPE.DB_AUTHENTICATION
> oSnap.PublisherPassword="password"
> oSnap.PublisherLogin="account"
> change
> oSnap.DistributorSecurityMode =
> SQLINITXLib.SECURITY_TYPE.NT_AUTHENTICATION
> to
> oSnap.DistributorSecurityMode =
> SQLINITXLib.SECURITY_TYPE.DB_AUTHENTICATION
> oSnap.DistributorPassword="password"
> oSnap.DistributorLogin="account"
> Repeat these changes everywhere you see NT_AUTHENTICATION.
>
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "dd" <dd@.discussions.microsoft.com> wrote in message
> news:BBA7CF14-42B4-417C-8C4D-A422D520EA0B@.microsoft.com...
> manually invoke a transactional replication process. This works fine on my
> development machine within our network/VPN. However, when I disconnect my
> machine from the VPN, the process keeps failing with a "Process could not
> connect to Distributor" error. Unfortunately, our customers/users will not
> be in our domain...they need to be able to connect & replicate over the
> internet.
> "MyServer" to get this to work. If I use a fully qualified name, like
> "MyServer.Domain.Com" it fails with the same error.
> publication is set up to allow anonymous pull subscriptions via FTP. I have
> a sql login that I have setup and made sure that it is in the Publications
> PAL.
> http://support.microsoft.com/default...;en-us;Q319648 to create
> the .net process.
> network admin that the ability to Ping our server has been disabled.
> the whole thing to work when I am on the network. I checked the log files
> (based on a suggestion from another post) on the server...and it doesn't
> even appear that a login is attempted.
>
>

Repeating Textbox

I'm creating a form which will enter all the information from the database
onto the form when the user enters a paramter. The problem is that I can't
get it to display more than one form.
Let say that the user wants all information from a certain company on the
form such as employees. The user enters the company name as parameter, and
then click view. There are about 25 employees, and that should generate 25
forms.
So can anyone point me to how to go about setting the form so that it will
generate all 25 forms with each employee's information on that form?Read up on subforms.
Do the following.
1.Create a report that just shows data for a single employee. Use a query
parameter that accepts employee id. Test and make sure it works
2. Create a report that just lists the employee ids based on the company
query parameter
3. Embed the first report as a subreport, right click on the embedded
subreport and map the employee id parameter to employee id in the company
report.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"chang" <chang@.discussions.microsoft.com> wrote in message
news:9CAFDA8D-84F0-45FA-AADF-E3403992D1F8@.microsoft.com...
> I'm creating a form which will enter all the information from the database
> onto the form when the user enters a paramter. The problem is that I
can't
> get it to display more than one form.
> Let say that the user wants all information from a certain company on the
> form such as employees. The user enters the company name as parameter,
and
> then click view. There are about 25 employees, and that should generate
25
> forms.
> So can anyone point me to how to go about setting the form so that it will
> generate all 25 forms with each employee's information on that form?
>|||Thank you Bruce. This works and saves me a lot of time trying to figure it
out.
If I wanted to say do the same thing, but now not using parameter. Do I
just set it like what you went over without the paramter part? The reason is
I also need to create report that will allow the user to do a mass print of
all employees information within all the companies.
"Bruce L-C [MVP]" wrote:
> Read up on subforms.
> Do the following.
> 1.Create a report that just shows data for a single employee. Use a query
> parameter that accepts employee id. Test and make sure it works
> 2. Create a report that just lists the employee ids based on the company
> query parameter
> 3. Embed the first report as a subreport, right click on the embedded
> subreport and map the employee id parameter to employee id in the company
> report.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "chang" <chang@.discussions.microsoft.com> wrote in message
> news:9CAFDA8D-84F0-45FA-AADF-E3403992D1F8@.microsoft.com...
> > I'm creating a form which will enter all the information from the database
> > onto the form when the user enters a paramter. The problem is that I
> can't
> > get it to display more than one form.
> >
> > Let say that the user wants all information from a certain company on the
> > form such as employees. The user enters the company name as parameter,
> and
> > then click view. There are about 25 employees, and that should generate
> 25
> > forms.
> >
> > So can anyone point me to how to go about setting the form so that it will
> > generate all 25 forms with each employee's information on that form?
> >
>
>|||Instead of using = use like and have the parameter value be %. Try it with
the employee report.
Bruce Loehle-Conger
"chang" <chang@.discussions.microsoft.com> wrote in message
news:57B79B63-0809-4FCB-AA90-9483EDEA7461@.microsoft.com...
> Thank you Bruce. This works and saves me a lot of time trying to figure
> it
> out.
> If I wanted to say do the same thing, but now not using parameter. Do I
> just set it like what you went over without the paramter part? The reason
> is
> I also need to create report that will allow the user to do a mass print
> of
> all employees information within all the companies.
>
> "Bruce L-C [MVP]" wrote:
>> Read up on subforms.
>> Do the following.
>> 1.Create a report that just shows data for a single employee. Use a query
>> parameter that accepts employee id. Test and make sure it works
>> 2. Create a report that just lists the employee ids based on the company
>> query parameter
>> 3. Embed the first report as a subreport, right click on the embedded
>> subreport and map the employee id parameter to employee id in the company
>> report.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "chang" <chang@.discussions.microsoft.com> wrote in message
>> news:9CAFDA8D-84F0-45FA-AADF-E3403992D1F8@.microsoft.com...
>> > I'm creating a form which will enter all the information from the
>> > database
>> > onto the form when the user enters a paramter. The problem is that I
>> can't
>> > get it to display more than one form.
>> >
>> > Let say that the user wants all information from a certain company on
>> > the
>> > form such as employees. The user enters the company name as parameter,
>> and
>> > then click view. There are about 25 employees, and that should
>> > generate
>> 25
>> > forms.
>> >
>> > So can anyone point me to how to go about setting the form so that it
>> > will
>> > generate all 25 forms with each employee's information on that form?
>> >
>>|||Bruce,
I did as what you mentioned about creating the first report with just one
information and then create that query to have a parameter.
I then create the second report with just the parameter(employee id).
I then embedded the first report into the second report and went to the
properties of the embedded report(the first one) and set the parameter.
This is the error that i get:
"An error occurred while executing the subreport 'subreport1': The
expressoin referenced a non-existing field in the fields collection."
I got nothing in the subreport field...not sure what I did wrong. Please
advise.
Thanks.
"Bruce L-C [MVP]" wrote:
> Instead of using = use like and have the parameter value be %. Try it with
> the employee report.
> Bruce Loehle-Conger
>
> "chang" <chang@.discussions.microsoft.com> wrote in message
> news:57B79B63-0809-4FCB-AA90-9483EDEA7461@.microsoft.com...
> > Thank you Bruce. This works and saves me a lot of time trying to figure
> > it
> > out.
> >
> > If I wanted to say do the same thing, but now not using parameter. Do I
> > just set it like what you went over without the paramter part? The reason
> > is
> > I also need to create report that will allow the user to do a mass print
> > of
> > all employees information within all the companies.
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Read up on subforms.
> >> Do the following.
> >> 1.Create a report that just shows data for a single employee. Use a query
> >> parameter that accepts employee id. Test and make sure it works
> >> 2. Create a report that just lists the employee ids based on the company
> >> query parameter
> >> 3. Embed the first report as a subreport, right click on the embedded
> >> subreport and map the employee id parameter to employee id in the company
> >> report.
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "chang" <chang@.discussions.microsoft.com> wrote in message
> >> news:9CAFDA8D-84F0-45FA-AADF-E3403992D1F8@.microsoft.com...
> >> > I'm creating a form which will enter all the information from the
> >> > database
> >> > onto the form when the user enters a paramter. The problem is that I
> >> can't
> >> > get it to display more than one form.
> >> >
> >> > Let say that the user wants all information from a certain company on
> >> > the
> >> > form such as employees. The user enters the company name as parameter,
> >> and
> >> > then click view. There are about 25 employees, and that should
> >> > generate
> >> 25
> >> > forms.
> >> >
> >> > So can anyone point me to how to go about setting the form so that it
> >> > will
> >> > generate all 25 forms with each employee's information on that form?
> >> >
> >>
> >>
> >>
>
>|||Bruce,
I did what you have, and I shouldn't say it didn't work. It does work, but
I can only get one contact per a parameter.
If possible, I want to get the parameter to dynamically display all company
and the user can select that company to have it display all the employees.
Thanks.
"chang" wrote:
> Bruce,
> I did as what you mentioned about creating the first report with just one
> information and then create that query to have a parameter.
> I then create the second report with just the parameter(employee id).
> I then embedded the first report into the second report and went to the
> properties of the embedded report(the first one) and set the parameter.
> This is the error that i get:
> "An error occurred while executing the subreport 'subreport1': The
> expressoin referenced a non-existing field in the fields collection."
> I got nothing in the subreport field...not sure what I did wrong. Please
> advise.
> Thanks.
> "Bruce L-C [MVP]" wrote:
> > Instead of using = use like and have the parameter value be %. Try it with
> > the employee report.
> >
> > Bruce Loehle-Conger
> >
> >
> > "chang" <chang@.discussions.microsoft.com> wrote in message
> > news:57B79B63-0809-4FCB-AA90-9483EDEA7461@.microsoft.com...
> > > Thank you Bruce. This works and saves me a lot of time trying to figure
> > > it
> > > out.
> > >
> > > If I wanted to say do the same thing, but now not using parameter. Do I
> > > just set it like what you went over without the paramter part? The reason
> > > is
> > > I also need to create report that will allow the user to do a mass print
> > > of
> > > all employees information within all the companies.
> > >
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > >> Read up on subforms.
> > >> Do the following.
> > >> 1.Create a report that just shows data for a single employee. Use a query
> > >> parameter that accepts employee id. Test and make sure it works
> > >> 2. Create a report that just lists the employee ids based on the company
> > >> query parameter
> > >> 3. Embed the first report as a subreport, right click on the embedded
> > >> subreport and map the employee id parameter to employee id in the company
> > >> report.
> > >>
> > >> --
> > >> Bruce Loehle-Conger
> > >> MVP SQL Server Reporting Services
> > >>
> > >> "chang" <chang@.discussions.microsoft.com> wrote in message
> > >> news:9CAFDA8D-84F0-45FA-AADF-E3403992D1F8@.microsoft.com...
> > >> > I'm creating a form which will enter all the information from the
> > >> > database
> > >> > onto the form when the user enters a paramter. The problem is that I
> > >> can't
> > >> > get it to display more than one form.
> > >> >
> > >> > Let say that the user wants all information from a certain company on
> > >> > the
> > >> > form such as employees. The user enters the company name as parameter,
> > >> and
> > >> > then click view. There are about 25 employees, and that should
> > >> > generate
> > >> 25
> > >> > forms.
> > >> >
> > >> > So can anyone point me to how to go about setting the form so that it
> > >> > will
> > >> > generate all 25 forms with each employee's information on that form?
> > >> >
> > >>
> > >>
> > >>
> >
> >
> >

repeating an insert statement

I want a insert statement to repeat X number of times (X will be a variable
passed from a user interface)...any hints on how to code the sql'
Thanks!!!Put it in a stored proc with a WHILE Loop.
CREATE PROC YourProc
@.Loop INT
AS
WHILE @.Loop > 0
BEGIN
INSERT INTO Table VALUES (x)
SET @.Loop = @.Loop - 1
END
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Gerry M" <GerryM@.discussions.microsoft.com> wrote in message
news:89A1C091-2DC5-485D-B652-6109C4BDA3D0@.microsoft.com...
>I want a insert statement to repeat X number of times (X will be a variable
> passed from a user interface)...any hints on how to code the sql'
> Thanks!!!|||And I might add that if X happens to be a large number, there may be a
need--for better performance--to control the number of INSERTs you want to
commit in a single transaction. By default, each INSERT commits as a single
transaction, which may not be most efficient if you are doing many
single-INSERT commits in a row.
Linchi
"Gerry M" wrote:
> I want a insert statement to repeat X number of times (X will be a variable
> passed from a user interface)...any hints on how to code the sql'
> Thanks!!!|||"Gerry M" <GerryM@.discussions.microsoft.com> wrote in message
news:89A1C091-2DC5-485D-B652-6109C4BDA3D0@.microsoft.com...
>I want a insert statement to repeat X number of times (X will be a variable
> passed from a user interface)...any hints on how to code the sql'
> Thanks!!!
What data do you want to insert? Perhaps you want all the integers from 1 to
X, in which case you can use a numbers table to help you:
INSERT INTO SomeTable (z)
SELECT num
FROM numbers
WHERE num BETWEEN 1 AND @.x -- your parameter ;
--
David Portas|||If it's SQL2005, you can do without a numbers auxiliary table. To insert the
same integer X times:
with tmp as (
select 1 as a, 1 as b
union all
select a, b+1 from tmp where b < 100 -- or @.x
)
insert junk(a)
select a from tmp;
To insert integers from 1 to @.x:
with tmp as (
select 1 as a
union all
select a + 1 from tmp where a < 100 -- or @.x
)
insert junk(a)
select a from tmp;
Linchi
"David Portas" wrote:
> "Gerry M" <GerryM@.discussions.microsoft.com> wrote in message
> news:89A1C091-2DC5-485D-B652-6109C4BDA3D0@.microsoft.com...
> >I want a insert statement to repeat X number of times (X will be a variable
> > passed from a user interface)...any hints on how to code the sql'
> >
> > Thanks!!!
> What data do you want to insert? Perhaps you want all the integers from 1 to
> X, in which case you can use a numbers table to help you:
>
> INSERT INTO SomeTable (z)
> SELECT num
> FROM numbers
> WHERE num BETWEEN 1 AND @.x -- your parameter ;
> --
> David Portas
>
>|||Hi Gerry!
You could try
INSERT INTO MyTable ( MyValue ) VALUES ( 1 )
GO 10;
This will loop through all statements in the batch 10 times. That's assuming
that you want identical copies of the same row to be inserted of course. And
it doesn't work with variables unfortunately, as they get re-declared and
re-assigned in every loop.
Regards,
Jan
"Gerry M" <GerryM@.discussions.microsoft.com> wrote in message
news:89A1C091-2DC5-485D-B652-6109C4BDA3D0@.microsoft.com...
>I want a insert statement to repeat X number of times (X will be a variable
> passed from a user interface)...any hints on how to code the sql'
> Thanks!!!|||> INSERT INTO MyTable ( MyValue ) VALUES ( 1 )
> GO 10;
The "GO n" method will work with SQL Server tools like SSMS or SQLCMD but
not from application code. GO is a batch terminator recognized only by the
SQL Server tools and is not actually sent to the server.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Jan Van der Eecken" <jkerner@.mweb.co.za> wrote in message
news:OBAl5ZaGIHA.4956@.TK2MSFTNGP06.phx.gbl...
> Hi Gerry!
> You could try
> INSERT INTO MyTable ( MyValue ) VALUES ( 1 )
> GO 10;
> This will loop through all statements in the batch 10 times. That's
> assuming that you want identical copies of the same row to be inserted of
> course. And it doesn't work with variables unfortunately, as they get
> re-declared and re-assigned in every loop.
> Regards,
> Jan
> "Gerry M" <GerryM@.discussions.microsoft.com> wrote in message
> news:89A1C091-2DC5-485D-B652-6109C4BDA3D0@.microsoft.com...
>>I want a insert statement to repeat X number of times (X will be a
>>variable
>> passed from a user interface)...any hints on how to code the sql'
>> Thanks!!!
>|||Andrew, how do I pass the variable to the stored proc? Do I use a select
statement to select it?...I want it all to fit into a single job...this is
what I have so far...but it only inserts a single record...
(In this example freeintfield_01 has a value of 100)
Select freeintfield_01
from absences
where type=206 and status=1 and freedatefield_05 is null
create proc sngen
@.freeintfield_01 int
as
while @.freeintfield_01>0
begin
insert into sngenerator (itemcode)
select itemcode
from absences
where type=206 and status=1 and freedatefield_05 is null and
freeintfield_01=@.freeintfield_01
set @.freeintfield_01=@.freeintfield_01-1
end
"Andrew J. Kelly" wrote:
> Put it in a stored proc with a WHILE Loop.
> CREATE PROC YourProc
> @.Loop INT
> AS
> WHILE @.Loop > 0
> BEGIN
> INSERT INTO Table VALUES (x)
> SET @.Loop = @.Loop - 1
> END
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Gerry M" <GerryM@.discussions.microsoft.com> wrote in message
> news:89A1C091-2DC5-485D-B652-6109C4BDA3D0@.microsoft.com...
> >I want a insert statement to repeat X number of times (X will be a variable
> > passed from a user interface)...any hints on how to code the sql'
> >
> > Thanks!!!
>|||Are you talking about a SQL Agent job? If so then like this:
DECLARE @.freeintfield_01 int
SET @.freeintfield_01 = (SELECT freeintfield_01
from absences
where type=206 and status=1 and freedatefield_05 is null )
EXEC dbo.sngen @.freeintfield_01
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Gerry M" <GerryM@.discussions.microsoft.com> wrote in message
news:819E8C07-8667-4865-BF86-D0AF005D3FC6@.microsoft.com...
> Andrew, how do I pass the variable to the stored proc? Do I use a select
> statement to select it?...I want it all to fit into a single job...this
> is
> what I have so far...but it only inserts a single record...
> (In this example freeintfield_01 has a value of 100)
> Select freeintfield_01
> from absences
> where type=206 and status=1 and freedatefield_05 is null
> create proc sngen
> @.freeintfield_01 int
> as
> while @.freeintfield_01>0
> begin
> insert into sngenerator (itemcode)
> select itemcode
> from absences
> where type=206 and status=1 and freedatefield_05 is null and
> freeintfield_01=@.freeintfield_01
> set @.freeintfield_01=@.freeintfield_01-1
> end
>
> "Andrew J. Kelly" wrote:
>> Put it in a stored proc with a WHILE Loop.
>> CREATE PROC YourProc
>> @.Loop INT
>> AS
>> WHILE @.Loop > 0
>> BEGIN
>> INSERT INTO Table VALUES (x)
>> SET @.Loop = @.Loop - 1
>> END
>>
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "Gerry M" <GerryM@.discussions.microsoft.com> wrote in message
>> news:89A1C091-2DC5-485D-B652-6109C4BDA3D0@.microsoft.com...
>> >I want a insert statement to repeat X number of times (X will be a
>> >variable
>> > passed from a user interface)...any hints on how to code the sql'
>> >
>> > Thanks!!!
>>|||Yes, the loop works fine but it does not insert the data (itemcode)100 times,
just once....?
"Andrew J. Kelly" wrote:
> Are you talking about a SQL Agent job? If so then like this:
> DECLARE @.freeintfield_01 int
> SET @.freeintfield_01 = (SELECT freeintfield_01
> from absences
> where type=206 and status=1 and freedatefield_05 is null )
> EXEC dbo.sngen @.freeintfield_01
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Gerry M" <GerryM@.discussions.microsoft.com> wrote in message
> news:819E8C07-8667-4865-BF86-D0AF005D3FC6@.microsoft.com...
> > Andrew, how do I pass the variable to the stored proc? Do I use a select
> > statement to select it?...I want it all to fit into a single job...this
> > is
> > what I have so far...but it only inserts a single record...
> > (In this example freeintfield_01 has a value of 100)
> >
> > Select freeintfield_01
> > from absences
> > where type=206 and status=1 and freedatefield_05 is null
> >
> > create proc sngen
> > @.freeintfield_01 int
> > as
> > while @.freeintfield_01>0
> >
> > begin
> >
> > insert into sngenerator (itemcode)
> > select itemcode
> >
> > from absences
> > where type=206 and status=1 and freedatefield_05 is null and
> > freeintfield_01=@.freeintfield_01
> >
> > set @.freeintfield_01=@.freeintfield_01-1
> > end
> >
> >
> > "Andrew J. Kelly" wrote:
> >
> >> Put it in a stored proc with a WHILE Loop.
> >>
> >> CREATE PROC YourProc
> >> @.Loop INT
> >>
> >> AS
> >>
> >> WHILE @.Loop > 0
> >> BEGIN
> >>
> >> INSERT INTO Table VALUES (x)
> >>
> >> SET @.Loop = @.Loop - 1
> >> END
> >>
> >>
> >> --
> >> Andrew J. Kelly SQL MVP
> >> Solid Quality Mentors
> >>
> >>
> >> "Gerry M" <GerryM@.discussions.microsoft.com> wrote in message
> >> news:89A1C091-2DC5-485D-B652-6109C4BDA3D0@.microsoft.com...
> >> >I want a insert statement to repeat X number of times (X will be a
> >> >variable
> >> > passed from a user interface)...any hints on how to code the sql'
> >> >
> >> > Thanks!!!
> >>
> >>
>|||If the loop is executing 100 times and the data is not being inserted you
must have an issue with the select statement.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Gerry M" <GerryM@.discussions.microsoft.com> wrote in message
news:F8F7A55F-0E1B-4351-B157-AAB90FA04F59@.microsoft.com...
> Yes, the loop works fine but it does not insert the data (itemcode)100
> times,
> just once....?
> "Andrew J. Kelly" wrote:
>> Are you talking about a SQL Agent job? If so then like this:
>> DECLARE @.freeintfield_01 int
>> SET @.freeintfield_01 = (SELECT freeintfield_01
>> from absences
>> where type=206 and status=1 and freedatefield_05 is null )
>> EXEC dbo.sngen @.freeintfield_01
>>
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "Gerry M" <GerryM@.discussions.microsoft.com> wrote in message
>> news:819E8C07-8667-4865-BF86-D0AF005D3FC6@.microsoft.com...
>> > Andrew, how do I pass the variable to the stored proc? Do I use a
>> > select
>> > statement to select it?...I want it all to fit into a single
>> > job...this
>> > is
>> > what I have so far...but it only inserts a single record...
>> > (In this example freeintfield_01 has a value of 100)
>> >
>> > Select freeintfield_01
>> > from absences
>> > where type=206 and status=1 and freedatefield_05 is null
>> >
>> > create proc sngen
>> > @.freeintfield_01 int
>> > as
>> > while @.freeintfield_01>0
>> >
>> > begin
>> >
>> > insert into sngenerator (itemcode)
>> > select itemcode
>> >
>> > from absences
>> > where type=206 and status=1 and freedatefield_05 is null and
>> > freeintfield_01=@.freeintfield_01
>> >
>> > set @.freeintfield_01=@.freeintfield_01-1
>> > end
>> >
>> >
>> > "Andrew J. Kelly" wrote:
>> >
>> >> Put it in a stored proc with a WHILE Loop.
>> >>
>> >> CREATE PROC YourProc
>> >> @.Loop INT
>> >>
>> >> AS
>> >>
>> >> WHILE @.Loop > 0
>> >> BEGIN
>> >>
>> >> INSERT INTO Table VALUES (x)
>> >>
>> >> SET @.Loop = @.Loop - 1
>> >> END
>> >>
>> >>
>> >> --
>> >> Andrew J. Kelly SQL MVP
>> >> Solid Quality Mentors
>> >>
>> >>
>> >> "Gerry M" <GerryM@.discussions.microsoft.com> wrote in message
>> >> news:89A1C091-2DC5-485D-B652-6109C4BDA3D0@.microsoft.com...
>> >> >I want a insert statement to repeat X number of times (X will be a
>> >> >variable
>> >> > passed from a user interface)...any hints on how to code the sql'
>> >> >
>> >> > Thanks!!!
>> >>
>> >>
>>|||Yes, I found it...thanks for your help!
Gerry
"Andrew J. Kelly" wrote:
> If the loop is executing 100 times and the data is not being inserted you
> must have an issue with the select statement.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Gerry M" <GerryM@.discussions.microsoft.com> wrote in message
> news:F8F7A55F-0E1B-4351-B157-AAB90FA04F59@.microsoft.com...
> > Yes, the loop works fine but it does not insert the data (itemcode)100
> > times,
> > just once....?
> >
> > "Andrew J. Kelly" wrote:
> >
> >> Are you talking about a SQL Agent job? If so then like this:
> >>
> >> DECLARE @.freeintfield_01 int
> >>
> >> SET @.freeintfield_01 = (SELECT freeintfield_01
> >> from absences
> >> where type=206 and status=1 and freedatefield_05 is null )
> >>
> >> EXEC dbo.sngen @.freeintfield_01
> >>
> >>
> >>
> >> --
> >> Andrew J. Kelly SQL MVP
> >> Solid Quality Mentors
> >>
> >>
> >> "Gerry M" <GerryM@.discussions.microsoft.com> wrote in message
> >> news:819E8C07-8667-4865-BF86-D0AF005D3FC6@.microsoft.com...
> >> > Andrew, how do I pass the variable to the stored proc? Do I use a
> >> > select
> >> > statement to select it?...I want it all to fit into a single
> >> > job...this
> >> > is
> >> > what I have so far...but it only inserts a single record...
> >> > (In this example freeintfield_01 has a value of 100)
> >> >
> >> > Select freeintfield_01
> >> > from absences
> >> > where type=206 and status=1 and freedatefield_05 is null
> >> >
> >> > create proc sngen
> >> > @.freeintfield_01 int
> >> > as
> >> > while @.freeintfield_01>0
> >> >
> >> > begin
> >> >
> >> > insert into sngenerator (itemcode)
> >> > select itemcode
> >> >
> >> > from absences
> >> > where type=206 and status=1 and freedatefield_05 is null and
> >> > freeintfield_01=@.freeintfield_01
> >> >
> >> > set @.freeintfield_01=@.freeintfield_01-1
> >> > end
> >> >
> >> >
> >> > "Andrew J. Kelly" wrote:
> >> >
> >> >> Put it in a stored proc with a WHILE Loop.
> >> >>
> >> >> CREATE PROC YourProc
> >> >> @.Loop INT
> >> >>
> >> >> AS
> >> >>
> >> >> WHILE @.Loop > 0
> >> >> BEGIN
> >> >>
> >> >> INSERT INTO Table VALUES (x)
> >> >>
> >> >> SET @.Loop = @.Loop - 1
> >> >> END
> >> >>
> >> >>
> >> >> --
> >> >> Andrew J. Kelly SQL MVP
> >> >> Solid Quality Mentors
> >> >>
> >> >>
> >> >> "Gerry M" <GerryM@.discussions.microsoft.com> wrote in message
> >> >> news:89A1C091-2DC5-485D-B652-6109C4BDA3D0@.microsoft.com...
> >> >> >I want a insert statement to repeat X number of times (X will be a
> >> >> >variable
> >> >> > passed from a user interface)...any hints on how to code the sql'
> >> >> >
> >> >> > Thanks!!!
> >> >>
> >> >>
> >>
> >>
>

Repeated Login failed for user SA in Event Log.

At regular intervals there are failed login message for User SA, User User,
User Root in the event log. This seems to have started after Security Patche
s
were applied.
How do I stop these failed logins occuring?
Thanks
--
John Franks MIScT, MIAP, MCSA, MCSE, MCDBACheck the Enterprise manager settings for configuration of SQL Agent.
Try changing SQL Agent to use Windows Authentication instead of Standard
Security.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thanks Kevin, we are already using Window authentication, any other
suggestions '
"Kevin McDonnell [MSFT]" wrote:

> Check the Enterprise manager settings for configuration of SQL Agent.
> Try changing SQL Agent to use Windows Authentication instead of Standard
> Security.
>
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>|||Otherwise, you could use SQL Profiler to capture failed login events to try
to find out what application is causing them, or run a network trace .
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Repeated Errors in SQL Server log file

I have hundreds of these errors saying 'Login failed for user 'Reporting' The user is not associated with a trusted SQL Server connection [CLIENT: ip address]

The ip address is that of the server that sql server is installed on.

Looking in my log file, all looks good until I get to Service Broker manager has started, then I get Error: 18452, Severity: 14 State: 1 then these two lines repeat about every minute, for the last 3 days!

I think I must have just missed a tick box somewhere, but where?

I have been into one of the databases, and input and checked data, both via an application I wrote and SQL Server Management Studio.

I am also having trouble connecting using my application to connect to the database, I can only connect if I use a Windows administrator account (this SQL Server 2005 running on a Windows 2003 Server, with the app on PC running Windows 2000)

Hello Graham,

did you find any solutions for that problem? I'm discovering a similar problem. The state of my error message is 5. According to the following source http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx this means the user is not known. This is correct. Neither the SQL-Server nor the Windows system has such a userid.

The faulty user name is 'Reporting'. What is that user used for? I have set up other SQL Server 2005 servers but was never asked for such a name.

Greetings,

Frank

|||

Frank

No, but I haven't had much chance to chase this, too many other issues!

|||

I've run into the same problem. As far as I can tell the "Reporting" userid is coming from Symantec Reporting Server for Antivirus or Client Security. Everything seems to be functioning in the Reporting console in Symantec Client security just fine, yet I still get the error. I've tried most of what I can think of to resolve this, but will let you know if I find anything else out. Please do likewise.

Jim

Repeated Errors in SQL Server log file

I have hundreds of these errors saying 'Login failed for user 'Reporting' The user is not associated with a trusted SQL Server connection [CLIENT: ip address]

The ip address is that of the server that sql server is installed on.

Looking in my log file, all looks good until I get to Service Broker manager has started, then I get Error: 18452, Severity: 14 State: 1 then these two lines repeat about every minute, for the last 3 days!

I think I must have just missed a tick box somewhere, but where?

I have been into one of the databases, and input and checked data, both via an application I wrote and SQL Server Management Studio.

I am also having trouble connecting using my application to connect to the database, I can only connect if I use a Windows administrator account (this SQL Server 2005 running on a Windows 2003 Server, with the app on PC running Windows 2000)

Hello Graham,

did you find any solutions for that problem? I'm discovering a similar problem. The state of my error message is 5. According to the following source http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx this means the user is not known. This is correct. Neither the SQL-Server nor the Windows system has such a userid.

The faulty user name is 'Reporting'. What is that user used for? I have set up other SQL Server 2005 servers but was never asked for such a name.

Greetings,

Frank

|||

Frank

No, but I haven't had much chance to chase this, too many other issues!

|||

I've run into the same problem. As far as I can tell the "Reporting" userid is coming from Symantec Reporting Server for Antivirus or Client Security. Everything seems to be functioning in the Reporting console in Symantec Client security just fine, yet I still get the error. I've tried most of what I can think of to resolve this, but will let you know if I find anything else out. Please do likewise.

Jim

Repeated "Login failed for user 'sa'" entries in SQL Server log

I'm getting repeating "Login failed for user 'sa'" messages in my SQL Server
log - every 20 to 30 seconds. These are also being recorded to the Event
Viewer / Application log. This is a SQL Server 2000 SP4 instance inside the
firewall.
I'm running SQL Profiler and capturing as follows:
Events:
Security Audig - Audit Login Failed
Sessions - ExistingConnection
Stored Procedures - RPC:Completed
Data Columns: All columns
SQL Profiler is returning:
Application Name: OSQL-32
ClientProcessID: <differs>
DatabaseID: 1
Error: 18456
Hostname: <server name>
LoginName: sa
LoginSid: 0x01
StartTime: <differs>
Success: 0
TextData: Login failed for user 'sa'.
I don't see much useful information here that can help me track down where
this is coming from; all the other data columns are empty. Am I missing
something? Is there some other tool I could use to track this down?
I'm guessing it's something on the server, based upon the ApplicationName
and HostName values being returned. Could it be a monitoring agent, i.e. MO
M?
Thanks,
MikeIn most cases this is usually a drone (BotNet) PC hijacked and trying to gai
n
access to your SQL server using the sa account. Why Microsoft haven't
produced any useful tools to:
1. Track to the source
2. Automatically filter out traffic once the repeatative pattern has been
established and notify
But there again, I don't expect much from a company like Microsoft who's
moto is "just enough effort to get revenue and leverage the profit".
netstat should help you identify the IP (in your case it sounds like someone
behind your firewall has infested a PC with a BotNet -- since it happens
every 20-30 seconds it should be pretty clear which IP is the source.
You can also use ActivePorts (freeware) to identify the source connections.
Anyway, why these tools aren't built into SQL 2005 is beyond me -- but I
guess that just goes to show you Microsoft's true "commitment" to security
and why their OS/services are such a easy target when compared to *nix based
platforms.
"mikron2" wrote:

> I'm getting repeating "Login failed for user 'sa'" messages in my SQL Serv
er
> log - every 20 to 30 seconds. These are also being recorded to the Event
> Viewer / Application log. This is a SQL Server 2000 SP4 instance inside t
he
> firewall.
>
> I'm running SQL Profiler and capturing as follows:
> Events:
> Security Audig - Audit Login Failed
> Sessions - ExistingConnection
> Stored Procedures - RPC:Completed
> Data Columns: All columns
> SQL Profiler is returning:
> Application Name: OSQL-32
> ClientProcessID: <differs>
> DatabaseID: 1
> Error: 18456
> Hostname: <server name>
> LoginName: sa
> LoginSid: 0x01
> StartTime: <differs>
> Success: 0
> TextData: Login failed for user 'sa'.
> I don't see much useful information here that can help me track down where
> this is coming from; all the other data columns are empty. Am I missing
> something? Is there some other tool I could use to track this down?
> I'm guessing it's something on the server, based upon the ApplicationName
> and HostName values being returned. Could it be a monitoring agent, i.e.
MOM?
> Thanks,
> Mike
>

Repeate group values in Matrix

Hi,

I am using matrix to make a report. I have company name in the row group and user name in the details field. When I run the report I only see the company name once and each user of that company is displayed in a separate row. Then next company name and its users... I wanted to know if there is a way to display company name next to the user name? I know it can be done by using "table" but I can't use table because in this report there are other fields can only be done in a matrix. So, please let me know if there are any settings in matrix which I can use to display my company name next to each user of that company. Please ask me any thing if the question is not clear. Thanks a lot for the help.

-Rohit

If someone have any idea about this problem please let me know. I would really appreciate that. Thanks.|||

Hi Rohit,

it sounds like you have a row group based on CompanyName, and a nested row group based on UserName. You could do the following steps:

1. Clear out the expression in the matrix header of the company group (which would display the company name) and resize that header to be relatively small
2. Modify the matrix header expression of the user name group to e.g.: =Fields!CompanyName.Value & " - " & Fields!UserName.Value

This should result in the company name being shown for every user name.

-- Robert

|||

Hi Robert,

This sounds like a solution that I had also been looking for but my users want to export to excel and do some things from there. If I merge my two values in that cell won't it create problems for them?

|||Thanks a lot Robert.|||

I figured out how to do it w/o having to concatinate the two into one column. Follow all of the directions that Robert gave us--take expression out of first column and minimize as small as possible. Only put the company name in the second grouping column expression. Then go into view datasets and drag your user id directly after the second column. It will appear in a column by itsself. That way they are still in their own columns and not concatinated-yet you still have the same results.

repair_allow_data_loss Repair statement not processed. Database needs to be in single user

I have to repair a database with repair_allow_data_loss level, so I start
SQL Server on single-user mode with the following command
sqlservr.exe -c -m
and run the repair command:
dbcc checkdb ('blade', repair_allow_data_loss)
I get the following error that doesn't make sense, since I am already in
single user mode:
Server: Msg 7919, Level 16, State 2, Line 1
Repair statement not processed. Database needs to be in single user mode.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Anyone can help?You don't need to start the server in single user mode for the DBCC, just
place the *database* in single-user-mode. You can do this with ALTER
DATABASE:
ALTER DATABASE MyDaabase
SET SINGLE_USER
Note that it's usually better to restore from backup than resort to DBCC
CHECKDB ... REPAIR_ALLOW_DATA_LOSS. However, the option is useful if you
have no backup.
Hope this helps.
Dan Guzman
SQL Server MVP
"savvas" <savvas@.blade.com.cy> wrote in message
news:uI0sdJFLGHA.3944@.tk2msftngp13.phx.gbl...
>I have to repair a database with repair_allow_data_loss level, so I start
> SQL Server on single-user mode with the following command
> sqlservr.exe -c -m
> and run the repair command:
> dbcc checkdb ('blade', repair_allow_data_loss)
> I get the following error that doesn't make sense, since I am already in
> single user mode:
> Server: Msg 7919, Level 16, State 2, Line 1
> Repair statement not processed. Database needs to be in single user mode.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>
> Anyone can help?
>

Repair/Recreate MSDB

Hi,
in addition to my inconsistent user Db. The msdb is also inconsistent.
What's the easiest way to create a new msdb. Do I need the content of the
old one? (I don't worry about the maintenance plans. I can setup them again)
Thanks for any advice
Graham
Graham SmithHi
If you did a regular BACKUP of the system databases you can just perfom
RESTORE of MSDB.
If you did not , you are probaly about to install SQL Server and then
RESTORE all of your user databases.
"Graham Smith" <graham.smith@.bbank.com> wrote in message
news:OlP5niu3FHA.3260@.TK2MSFTNGP10.phx.gbl...
> Hi,
> in addition to my inconsistent user Db. The msdb is also inconsistent.
> What's the easiest way to create a new msdb. Do I need the content of the
> old one? (I don't worry about the maintenance plans. I can setup them
> again)
> Thanks for any advice
> Graham
> --
> Graham Smith
>|||Hi,

> RESTORE of MSDB.
do I have to consider something? Like setting the server into a special
mode?
Thanks again
Graham Smith