How to manage different input (Excel files) format

Hi all,

I have created a package which import data from excel file and do some technical & business validation on the data. My package has about 20 control flow items. Now I'm asked to handle a second (and probably more in the future) excel file format (columns name are different, some fields are murged in one single column...).

I definitely don't want to create a different package for each excel file format. But I can't find a way in the control flow to execute a particular DataFlow in one case and another DataFlow in other cases. Typically I would like to evaluate an expression an depending on the result execute a DataFlow or another one. Even in a given DataFlow I cant find a way to have a condition and process different Excel Source depending on an expression result. Or it would be good if I could say to my Excel Source to discover the columns name and types at runtime and let me manage the columns manually in the data flow. Is that possible ? I know SSIS manage metadata on the columns based on the data source is there any way to manage the metadata manually ? I coulnd't find anything about that in BOL.

I guess an easy workaround is to have a different package just to import the different excel files in a common staging table and each package calls a single package which contains all technical & business validation.

Any help will be appreciated.

Kind regards,

Sbastien.

Have you discovered the expressions on precedence constraints? They seems like ideal fit for your requirements.

Double click a precedence constraint line, select a condition and an expression.|||

Right! That's what I needed.

Thanks for your answer.

How to make self-backup log in msde?

Hi.
I am trying to automatically backup transaction log when error 9002
happened. So i have created appropriate job and alert to catch this error.
I have two instances of sql server under Windows 2000. One of them is full
SQL Server, another is msde.
When transaction log is full in full SQL Server error 9002 severity 17
state 2 is logged in sql server log and in Windows Application log. My
alert firing my job. All is fine.
But when transaction log is full in MSDE error 9002 severity 17 state 6 is
logged only in sql server log. It is not logged into Windows Application
log so my alert does not work.
So here is my questions:
1. Why MSDE does not log error into Windows Application log?
2. Why error 9002 has severity 19 in sysmessages table but is generated
with severity 17?
3. Why state of error 9002 differs under sql server and msde?

Thank you.

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/"Igor Solodovnikov" <igor@.helpco.kiev> wrote in message
news:opr5ullxv2fk7eds@.124-225.dialup.alfacom.net...
> Hi.
> I am trying to automatically backup transaction log when error 9002
> happened. So i have created appropriate job and alert to catch this error.
> I have two instances of sql server under Windows 2000. One of them is full
> SQL Server, another is msde.
> When transaction log is full in full SQL Server error 9002 severity 17
> state 2 is logged in sql server log and in Windows Application log. My
> alert firing my job. All is fine.
> But when transaction log is full in MSDE error 9002 severity 17 state 6 is
> logged only in sql server log. It is not logged into Windows Application
> log so my alert does not work.
> So here is my questions:
> 1. Why MSDE does not log error into Windows Application log?
> 2. Why error 9002 has severity 19 in sysmessages table but is generated
> with severity 17?
> 3. Why state of error 9002 differs under sql server and msde?
> Thank you.
> --
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

1. I've also set this up (MSDE2000 SP3a on Windows XP Pro SP1), and it works
correctly - error 9002 is logged in both the SQL log and the Windows event
log, and the alert executes a job. This post suggests that restarting SQL
Server may help:

http://groups.google.com/groups?hl=...%40cpmsftngxa08

If that doesn't work, then perhaps you can give more details about your
setup - which version of MSDE do you have? Have you installed the latest
servicepack? Also, if you execute RAISERROR ... WITH LOG to raise a test
error, is it logged in the Windows event log?

2. No idea, but 17 seems to be more correct, since it's the severity level
for insufficient resources.

3. State is not a fixed value - the process which raises the error can use
different states with the same error, to provide extra information about
exactly how the error was caused. In this case, it could be something like 2
for system databases and 6 for user ones, or 2 in Standard Edition, but 6 in
MSDE etc. I got state 6 with a user DB in MSDE.

Simon|||On Sat, 3 Apr 2004 12:37:08 +0200, Simon Hayes <sql@.hayes.ch> wrote:

> "Igor Solodovnikov" <igor@.helpco.kiev> wrote in message
> news:opr5ullxv2fk7eds@.124-225.dialup.alfacom.net...
>> Hi.
>> I am trying to automatically backup transaction log when error 9002
>> happened. So i have created appropriate job and alert to catch this
>> error.
>> I have two instances of sql server under Windows 2000. One of them is
>> full
>> SQL Server, another is msde.
>> When transaction log is full in full SQL Server error 9002 severity 17
>> state 2 is logged in sql server log and in Windows Application log. My
>> alert firing my job. All is fine.
>> But when transaction log is full in MSDE error 9002 severity 17 state 6
>> is
>> logged only in sql server log. It is not logged into Windows Application
>> log so my alert does not work.
>> So here is my questions:
>> 1. Why MSDE does not log error into Windows Application log?
>> 2. Why error 9002 has severity 19 in sysmessages table but is generated
>> with severity 17?
>> 3. Why state of error 9002 differs under sql server and msde?
>>
>> Thank you.
>>
>> --
>> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
> 1. I've also set this up (MSDE2000 SP3a on Windows XP Pro SP1), and it
> works
> correctly - error 9002 is logged in both the SQL log and the Windows
> event
> log, and the alert executes a job. This post suggests that restarting SQL
> Server may help:
> http://groups.google.com/groups?hl=...%40cpmsftngxa08
> If that doesn't work, then perhaps you can give more details about your
> setup - which version of MSDE do you have? Have you installed the latest
> servicepack? Also, if you execute RAISERROR ... WITH LOG to raise a test
> error, is it logged in the Windows event log?
> 2. No idea, but 17 seems to be more correct, since it's the severity
> level
> for insufficient resources.
> 3. State is not a fixed value - the process which raises the error can
> use
> different states with the same error, to provide extra information about
> exactly how the error was caused. In this case, it could be something
> like 2
> for system databases and 6 for user ones, or 2 in Standard Edition, but
> 6 in
> MSDE etc. I got state 6 with a user DB in MSDE.
> Simon

Thank you for answer. OS is Windows 2000 SP4. I have MSDE 2000 SP3a and
MSDE 2000 Release A instances. Both do not write error 9002 into Windows
error log identically. SQL 2000 instance in the same OS works fine.
I have rebooted computer few times. It does not resolved my problem. I
think rebooting computer is equivalent to restarting SQL Server. Am i
wrong?
I got state 2 overloading user DB in MSDE -> Windows error log is not
written
State 6 overloading identical user DB in SQL Server -> Windows error log
is written correct
I will try to execute RAISERROR...WITH LOG and will post its results later.

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/|||On Sat, 3 Apr 2004 12:37:08 +0200, Simon Hayes <sql@.hayes.ch> wrote:

> "Igor Solodovnikov" <igor@.helpco.kiev> wrote in message
> news:opr5ullxv2fk7eds@.124-225.dialup.alfacom.net...
>> Hi.
>> I am trying to automatically backup transaction log when error 9002
>> happened. So i have created appropriate job and alert to catch this
>> error.
>> I have two instances of sql server under Windows 2000. One of them is
>> full
>> SQL Server, another is msde.
>> When transaction log is full in full SQL Server error 9002 severity 17
>> state 2 is logged in sql server log and in Windows Application log. My
>> alert firing my job. All is fine.
>> But when transaction log is full in MSDE error 9002 severity 17 state 6
>> is
>> logged only in sql server log. It is not logged into Windows Application
>> log so my alert does not work.
>> So here is my questions:
>> 1. Why MSDE does not log error into Windows Application log?
>> 2. Why error 9002 has severity 19 in sysmessages table but is generated
>> with severity 17?
>> 3. Why state of error 9002 differs under sql server and msde?
>>
>> Thank you.
>>
>> --
>> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
> 1. I've also set this up (MSDE2000 SP3a on Windows XP Pro SP1), and it
> works
> correctly - error 9002 is logged in both the SQL log and the Windows
> event
> log, and the alert executes a job. This post suggests that restarting SQL
> Server may help:
> http://groups.google.com/groups?hl=...%40cpmsftngxa08
> If that doesn't work, then perhaps you can give more details about your
> setup - which version of MSDE do you have? Have you installed the latest
> servicepack? Also, if you execute RAISERROR ... WITH LOG to raise a test
> error, is it logged in the Windows event log?
> 2. No idea, but 17 seems to be more correct, since it's the severity
> level
> for insufficient resources.
> 3. State is not a fixed value - the process which raises the error can
> use
> different states with the same error, to provide extra information about
> exactly how the error was caused. In this case, it could be something
> like 2
> for system databases and 6 for user ones, or 2 in Standard Edition, but
> 6 in
> MSDE etc. I got state 6 with a user DB in MSDE.
> Simon

I have executed RAISERROR ... WITH LOG statement in my MSDE database. It
does not write into the Windows log. But i have found some warning
messages in Application log. Here is my application for today. May be you
can give me some advice about that warnings:

03.04.2004,19:53:27,MSSQLSERVER,Information,(2),17 055,S-1-5-21-1699048451-83243044-507081533-1009,W2000,The
description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: 8128; Using 'sqlmap70.dll'
version '2000.80.194' to execute extended stored procedure
'xp_get_mapi_profiles'.
..
03.04.2004,19:53:21,MSSQLSERVER,Information,(2),17 055,S-1-5-21-1699048451-83243044-507081533-1009,W2000,The
description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: 8128; Using 'xpstar.dll'
version '2000.80.194' to execute extended stored procedure
'sp_MSgetversion'.
..
03.04.2004,19:33:42,EventSystem,Warning,Firing Agent,4100,N/A,W2000,The
COM+ Event System failed to create an instance of the subscriber
{6295DF2D-35EE-11D1-8707-00C04FD93327}. CoCreateInstanceEx returned
HRESULT 8000401A.
03.04.2004,19:33:37,WinMgmt,Warning,None,41,N/A,W2000,WMI ADAP was unable
to create object index 1848 for Performance Library RSVP because no value
was found in the 009 subkey
03.04.2004,19:33:32,WinMgmt,Warning,None,41,N/A,W2000,WMI ADAP was unable
to create object index 2212 for Performance Library MSDTC because no value
was found in the 009 subkey
03.04.2004,19:33:31,SQLSERVERAGENT,Information,(2) ,101,N/A,W2000,The
description for Event ID ( 101 ) in Source ( SQLSERVERAGENT ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: The event log file is corrupt..
03.04.2004,19:33:30,SQLAgent$FAVGAME,Information,( 2),101,N/A,W2000,The
description for Event ID ( 101 ) in Source ( SQLAgent$FAVGAME ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: The event log file is corrupt..
03.04.2004,19:33:22,MSSQLSERVER,Information,(2),17 055,S-1-5-21-1699048451-83243044-507081533-1009,W2000,The
description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: 8128; Using 'xpsqlbot.dll'
version '2000.80.194' to execute extended stored procedure 'xp_qv'.
..
03.04.2004,19:33:14,MSSQLSERVER,Information,(2),17 055,N/A,W2000,The
description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: 17052; Recovery complete.
..
03.04.2004,19:33:10,MSSQLSERVER,Information,(2),17 055,N/A,W2000,The
description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: 3455; Analysis of database
'cashbasedmir' (10) is 100% complete (approximately 0 more seconds)
..
03.04.2004,19:33:06,SQLAgent$ALERT,Information,(2) ,101,N/A,W2000,The
description for Event ID ( 101 ) in Source ( SQLAgent$ALERT ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: The event log file is corrupt..
03.04.2004,19:33:04,EvntAgnt,Information,None,2018 ,N/A,W2000,The
description for Event ID ( 2018 ) in Source ( EvntAgnt ) cannot be found.
The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer. The
following information is part of the event: The event log file is corrupt..
03.04.2004,19:32:57,SceCli,Information,None,1704,N /A,W2000,Security policy
in the Group policy objects are applied successfully.
03.04.2004,19:32:50,SQLSERVERAGENT,Information,(2) ,101,N/A,W2000,The
description for Event ID ( 101 ) in Source ( SQLSERVERAGENT ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: The event log file is corrupt..
03.04.2004,19:32:45,MSSQLSERVER,Information,(2),17 055,N/A,W2000,The
description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: 17126; SQL Server is ready for
client connections
..
03.04.2004,19:32:45,MSSQLSERVER,Information,(2),17 055,N/A,W2000,"The
description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: 19013; SQL server listening on
192.168.0.4:1433, 127.0.0.1:1433.
.."
03.04.2004,19:32:45,MSSQLSERVER,Information,(2),17 055,N/A,W2000,"The
description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: 19013; SQL server listening on
TCP, Shared Memory, Named Pipes.
.."
03.04.2004,19:32:45,MSSQLServer,Warning,(8),19011, N/A,W2000,The
description for Event ID ( 19011 ) in Source ( MSSQLServer ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: (SpnRegister) : Error 1355.
03.04.2004,19:32:45,MSSQLSERVER,Information,(2),17 055,N/A,W2000,The
description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: 17834; Using 'SSNETLIB.DLL'
version '8.0.194'.
..
03.04.2004,19:32:43,SQLAgent$FAVGAME,Information,( 2),101,N/A,W2000,The
description for Event ID ( 101 ) in Source ( SQLAgent$FAVGAME ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: The event log file is corrupt..
03.04.2004,19:32:39,SQLAgent$ALERT,Information,(2) ,101,N/A,W2000,The
description for Event ID ( 101 ) in Source ( SQLAgent$ALERT ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: The event log file is corrupt..
03.04.2004,19:32:37,MSSQL$FAVGAME,Warning,(8),1901 1,N/A,W2000,The
description for Event ID ( 19011 ) in Source ( MSSQL$FAVGAME ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: (SpnRegister) : Error 1355.
03.04.2004,19:32:34,MSSQLSERVER,Information,(2),17 055,N/A,W2000,"The
description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: 17125; Using dynamic lock
allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
.."
03.04.2004,19:32:34,MSSQLSERVER,Information,(2),17 055,N/A,W2000,The
description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: 17124; SQL Server configured
for thread mode processing.
..
03.04.2004,19:32:34,MSSQL$ALERT,Warning,(8),19011, N/A,W2000,The
description for Event ID ( 19011 ) in Source ( MSSQL$ALERT ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: (SpnRegister) : Error 1355.
03.04.2004,19:32:33,MSSQLSERVER,Information,(2),17 055,N/A,W2000,The
description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: 17162; SQL Server is starting
at priority class 'normal'(1 CPU detected).
..
03.04.2004,19:32:32,MSSQLSERVER,Information,(2),17 055,N/A,W2000,The
description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: 17104; Server Process ID is
728.
..
03.04.2004,19:32:32,MSSQLSERVER,Information,(2),17 055,N/A,W2000,The
description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: 17052; Microsoft SQL Server
2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4)|||"Igor Solodovnikov" <igor@.helpco.kiev> wrote in message
news:opr5wgspdvfk7eds@.124-204.dialup.alfacom.net...
> On Sat, 3 Apr 2004 12:37:08 +0200, Simon Hayes <sql@.hayes.ch> wrote:
> > "Igor Solodovnikov" <igor@.helpco.kiev> wrote in message
> > news:opr5ullxv2fk7eds@.124-225.dialup.alfacom.net...
> >> Hi.
> >> I am trying to automatically backup transaction log when error 9002
> >> happened. So i have created appropriate job and alert to catch this
> >> error.
> >> I have two instances of sql server under Windows 2000. One of them is
> >> full
> >> SQL Server, another is msde.
> >> When transaction log is full in full SQL Server error 9002 severity 17
> >> state 2 is logged in sql server log and in Windows Application log. My
> >> alert firing my job. All is fine.
> >> But when transaction log is full in MSDE error 9002 severity 17 state 6
> >> is
> >> logged only in sql server log. It is not logged into Windows
Application
> >> log so my alert does not work.
> >> So here is my questions:
> >> 1. Why MSDE does not log error into Windows Application log?
> >> 2. Why error 9002 has severity 19 in sysmessages table but is generated
> >> with severity 17?
> >> 3. Why state of error 9002 differs under sql server and msde?
> >>
> >> Thank you.
> >>
> >> --
> >> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
> > 1. I've also set this up (MSDE2000 SP3a on Windows XP Pro SP1), and it
> > works
> > correctly - error 9002 is logged in both the SQL log and the Windows
> > event
> > log, and the alert executes a job. This post suggests that restarting
SQL
> > Server may help:
http://groups.google.com/groups?hl=...%40cpmsftngxa08
> > If that doesn't work, then perhaps you can give more details about your
> > setup - which version of MSDE do you have? Have you installed the latest
> > servicepack? Also, if you execute RAISERROR ... WITH LOG to raise a test
> > error, is it logged in the Windows event log?
> > 2. No idea, but 17 seems to be more correct, since it's the severity
> > level
> > for insufficient resources.
> > 3. State is not a fixed value - the process which raises the error can
> > use
> > different states with the same error, to provide extra information about
> > exactly how the error was caused. In this case, it could be something
> > like 2
> > for system databases and 6 for user ones, or 2 in Standard Edition, but
> > 6 in
> > MSDE etc. I got state 6 with a user DB in MSDE.
> > Simon
> I have executed RAISERROR ... WITH LOG statement in my MSDE database. It
> does not write into the Windows log. But i have found some warning
> messages in Application log. Here is my application for today. May be you
> can give me some advice about that warnings:

<snip
It looks like something is fundamentally wrong with your installation, if
you get so many DLL errors. Personally, I would completely remove all MSDE
instances on the server and reinstall it, instead of trying to identify each
error:

http://support.microsoft.com/defaul...3&Product=sql2k

By the way, the error 17055 suggests that you are truncating the log even if
the database is in full recovery mode. This isn't a good idea, because then
you can't recover your previous backups if you need to:

http://support.microsoft.com/defaul...2&Product=sql2k

Simon|||"Igor Solodovnikov" <igor@.helpco.kiev> wrote in message news:<opr5ullxv2fk7eds@.124-225.dialup.alfacom.net>...
> Hi.
> I am trying to automatically backup transaction log when error 9002
> happened. So i have created appropriate job and alert to catch this error.
> I have two instances of sql server under Windows 2000. One of them is full
> SQL Server, another is msde.
> When transaction log is full in full SQL Server error 9002 severity 17
> state 2 is logged in sql server log and in Windows Application log. My
> alert firing my job. All is fine.
> But when transaction log is full in MSDE error 9002 severity 17 state 6 is
> logged only in sql server log. It is not logged into Windows Application
> log so my alert does not work.
> So here is my questions:
> 1. Why MSDE does not log error into Windows Application log?
> 2. Why error 9002 has severity 19 in sysmessages table but is generated
> with severity 17?
> 3. Why state of error 9002 differs under sql server and msde?
> Thank you.

I do this by defining a Database Maintenance plan, but leaving the
jobs this generates disabled. I then use msdb.dbo.sp_start_job to call
the job when wanted. Not only does this method log to the msdb history
tables, but old backups, execution logs, etc are cleaned up per the
retention settings.

You may already be "losing data" when you get the 9002 error. Take a
look at performance alerts and set a threshold (say 70%) so the system
may be able to backup the log and recover space before transactions
fail because the log is full.

HTH
JIV

John W. Pollins IV
Readi Operations DBA
Equitable Resources Inc

How to make CR not avg sums

I have created a CR that pulls info from MAS90 for a 401(k) report that calculates the employer contribution and then "brings in" the employee contribution that was deducted from their pay.

These are in three columns including a total column adding the EE and ER amounts together for each employee.

My problem is the column totals (grand total) for these three columns at the bottom of the page are off by a few cents. If I manually add up the numbers, I get the correct amount. For some reason CR is averaging up or down instead of EXACT amounts.

I have checked my regional settings for Windows XP. I have tried a custom number setting in CR. Nothing is working.

I also tried doing a running total for each column - that didn't work either. Amounts were still off, but could see them in the running total(s).

Can anyone help, please? Thank you!
JulesI would guess that as your report calculates the contributions that the calculated value isn't exact to 2 decimal places but you are displaying it to 2dp.
Have you tried truncating the calculated values to 2dp and totalling on that?|||Jagan, how do I "truncate" the numbers?

Sorry I'm such a dummy here!

Jules|||Truncate(1.999)

Returns 1.

Truncate(12346.33, 1)

Returns 12346.3.

Truncate(12345.33, -2)

Returns 12300.00.

F1 it helps ... :-)

How to make auto-increment ID?

I've created a table. How do I modify the ID so that it isauto-increment? I'm using Microsoft SQL Server Management Studio toaccess my tables.You need to make the integer column an IDENTITY column. There is an option for that in the design mode for the table in SQL Server Management Studio.|||Thank you so much! I got it working now.

How to make aspnet DB use local time zone?

I created aspnet DB on SQL Server 2K using aspnet_regsql utility. Everything works fine except the DateTime fields in all tables are using a wrong time zone. How do I set it to use my local time zone?

Any help will be greatly appreciated.

All stored procedures in aspnetdb use UTC-based datetime fields. That's pretty normal practice for any database that might need to be accessed from multiple time zones.

How to make a portabol Database

I have a database that I am going to have to travel with for
presentations. I have never created a database that I needed to travel with;
does SQL Server 2005 Standard have a way to make your tables still work with
the ront end I created using VB.NET with ASP.NET OR just VB.NET?
Without having to install the complete SQL Server Database, just need
to make the tables I currently have portable. Please help, I have tried to
figure this out myself with know success.
Thanks, MikeWhy not just install SQL Server Express?
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Neogortex" <Neogortex@.discussions.microsoft.com> wrote in message
news:7E5759CA-D7CF-4CCA-A558-EADE428E1C9F@.microsoft.com...
> I have a database that I am going to have to travel with for
> presentations. I have never created a database that I needed to travel
> with;
> does SQL Server 2005 Standard have a way to make your tables still work
> with
> the ront end I created using VB.NET with ASP.NET OR just VB.NET?
> Without having to install the complete SQL Server Database, just need
> to make the tables I currently have portable. Please help, I have tried to
> figure this out myself with know success.
> Thanks, Mike|||Thanks, I'll try that, I'm not really familiar with SQL Server Express.
Thanks for the quick response, thanks for thenlink to the book, I am going t
o
have to get some books since I found out that I am going to be messing aroun
d
with SQL Server alot more.
Thanks, Mike
"Adam Machanic" wrote:

> Why not just install SQL Server Express?
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Neogortex" <Neogortex@.discussions.microsoft.com> wrote in message
> news:7E5759CA-D7CF-4CCA-A558-EADE428E1C9F@.microsoft.com...
>
>|||Just to expand a bit on Adam's answer:
No, the only application (that I know of) that will read SQL Server database
file is ... SQL Server.
Express is SQL Server, packaged and licensed very attractive for your scenar
io.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Neogortex" <Neogortex@.discussions.microsoft.com> wrote in message
news:761DD6C9-5280-4945-AADF-57DF21DF15F6@.microsoft.com...[vbcol=seagreen]
> Thanks, I'll try that, I'm not really familiar with SQL Server Express.
> Thanks for the quick response, thanks for thenlink to the book, I am going
to
> have to get some books since I found out that I am going to be messing aro
und
> with SQL Server alot more.
> Thanks, Mike
> "Adam Machanic" wrote:
>sql

How to make a portabol Database

I have a database that I am going to have to travel with for
presentations. I have never created a database that I needed to travel with;
does SQL Server 2005 Standard have a way to make your tables still work with
the ront end I created using VB.NET with ASP.NET OR just VB.NET?
Without having to install the complete SQL Server Database, just need
to make the tables I currently have portable. Please help, I have tried to
figure this out myself with know success.
Thanks, MikeWhy not just install SQL Server Express?
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Neogortex" <Neogortex@.discussions.microsoft.com> wrote in message
news:7E5759CA-D7CF-4CCA-A558-EADE428E1C9F@.microsoft.com...
> I have a database that I am going to have to travel with for
> presentations. I have never created a database that I needed to travel
> with;
> does SQL Server 2005 Standard have a way to make your tables still work
> with
> the ront end I created using VB.NET with ASP.NET OR just VB.NET?
> Without having to install the complete SQL Server Database, just need
> to make the tables I currently have portable. Please help, I have tried to
> figure this out myself with know success.
> Thanks, Mike|||Thanks, I'll try that, I'm not really familiar with SQL Server Express.
Thanks for the quick response, thanks for thenlink to the book, I am going to
have to get some books since I found out that I am going to be messing around
with SQL Server alot more.
Thanks, Mike
"Adam Machanic" wrote:
> Why not just install SQL Server Express?
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Neogortex" <Neogortex@.discussions.microsoft.com> wrote in message
> news:7E5759CA-D7CF-4CCA-A558-EADE428E1C9F@.microsoft.com...
> > I have a database that I am going to have to travel with for
> > presentations. I have never created a database that I needed to travel
> > with;
> > does SQL Server 2005 Standard have a way to make your tables still work
> > with
> > the ront end I created using VB.NET with ASP.NET OR just VB.NET?
> > Without having to install the complete SQL Server Database, just need
> > to make the tables I currently have portable. Please help, I have tried to
> > figure this out myself with know success.
> >
> > Thanks, Mike
>
>|||Just to expand a bit on Adam's answer:
No, the only application (that I know of) that will read SQL Server database file is ... SQL Server.
Express is SQL Server, packaged and licensed very attractive for your scenario.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Neogortex" <Neogortex@.discussions.microsoft.com> wrote in message
news:761DD6C9-5280-4945-AADF-57DF21DF15F6@.microsoft.com...
> Thanks, I'll try that, I'm not really familiar with SQL Server Express.
> Thanks for the quick response, thanks for thenlink to the book, I am going to
> have to get some books since I found out that I am going to be messing around
> with SQL Server alot more.
> Thanks, Mike
> "Adam Machanic" wrote:
>> Why not just install SQL Server Express?
>>
>> --
>> Adam Machanic
>> Pro SQL Server 2005, available now
>> http://www.apress.com/book/bookDisplay.html?bID=457
>> --
>>
>> "Neogortex" <Neogortex@.discussions.microsoft.com> wrote in message
>> news:7E5759CA-D7CF-4CCA-A558-EADE428E1C9F@.microsoft.com...
>> > I have a database that I am going to have to travel with for
>> > presentations. I have never created a database that I needed to travel
>> > with;
>> > does SQL Server 2005 Standard have a way to make your tables still work
>> > with
>> > the ront end I created using VB.NET with ASP.NET OR just VB.NET?
>> > Without having to install the complete SQL Server Database, just need
>> > to make the tables I currently have portable. Please help, I have tried to
>> > figure this out myself with know success.
>> >
>> > Thanks, Mike
>>

How to make a portabol Database

I have a database that I am going to have to travel with for
presentations. I have never created a database that I needed to travel with;
does SQL Server 2005 Standard have a way to make your tables still work with
the ront end I created using VB.NET with ASP.NET OR just VB.NET?
Without having to install the complete SQL Server Database, just need
to make the tables I currently have portable. Please help, I have tried to
figure this out myself with know success.
Thanks, Mike
Why not just install SQL Server Express?
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"Neogortex" <Neogortex@.discussions.microsoft.com> wrote in message
news:7E5759CA-D7CF-4CCA-A558-EADE428E1C9F@.microsoft.com...
> I have a database that I am going to have to travel with for
> presentations. I have never created a database that I needed to travel
> with;
> does SQL Server 2005 Standard have a way to make your tables still work
> with
> the ront end I created using VB.NET with ASP.NET OR just VB.NET?
> Without having to install the complete SQL Server Database, just need
> to make the tables I currently have portable. Please help, I have tried to
> figure this out myself with know success.
> Thanks, Mike
|||Thanks, I'll try that, I'm not really familiar with SQL Server Express.
Thanks for the quick response, thanks for thenlink to the book, I am going to
have to get some books since I found out that I am going to be messing around
with SQL Server alot more.
Thanks, Mike
"Adam Machanic" wrote:

> Why not just install SQL Server Express?
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Neogortex" <Neogortex@.discussions.microsoft.com> wrote in message
> news:7E5759CA-D7CF-4CCA-A558-EADE428E1C9F@.microsoft.com...
>
>
|||Just to expand a bit on Adam's answer:
No, the only application (that I know of) that will read SQL Server database file is ... SQL Server.
Express is SQL Server, packaged and licensed very attractive for your scenario.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Neogortex" <Neogortex@.discussions.microsoft.com> wrote in message
news:761DD6C9-5280-4945-AADF-57DF21DF15F6@.microsoft.com...[vbcol=seagreen]
> Thanks, I'll try that, I'm not really familiar with SQL Server Express.
> Thanks for the quick response, thanks for thenlink to the book, I am going to
> have to get some books since I found out that I am going to be messing around
> with SQL Server alot more.
> Thanks, Mike
> "Adam Machanic" wrote:

how to login in sql server with certification login

hi all,

i have created a login account using certificate.

--CREATE A CERTIFICATE--

CREATECERTIFICATE TEST_CERTIFICATE123

WITH SUBJECT ='CERTIFICATE IN TEST DATABASE',

START_DATE='06/04/2007',

EXPIRY_DATE ='02/02/2009';

GO

--CREATE LOGIN FRON THE CERTIFICATE

CREATELOGIN LALIT12301 FROMCERTIFICATE TEST_CERTIFICATE123;

GO

How can i use this login credential to login to microsoft sql server management studio.It is askin only for sql/windows authentication.There is no option for the certificate based login.

if i m passing this login id as sql server authentication then i m getting following error.

Login failed for user 'LALIT123'. (Microsoft SQL Server, Error: 18456)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

please do help me.....

It is not currently possible to login to SQL Server as a certificate Login.

These kinds of logins are used for signed modules and allow some finer grained access control to pieces of code because you can grant permissions to the certificate login, sign a procedure with the certificate and anyone who has execute permission on the procedure will have the additional permissions granted to the certificate login WHILE the procedure is executing.

HTH,

-Steven Gott

SDE/T

SQL Server

|||

Hi Steven

Thanks a lot..............

How to log in to SQL with a user other than sa

my connection string is
"Data Source=w2k3-std;Initial Catalog=CTrack;User Id=sa;Password=********;"
I have created extra users in both my database and the master database but if I change the userid and password as above they fail to connect.
Why?
Cheers
PaulHi, the answer to your question is going to depend upon the errormessage you are seeing. Please be sure to post exact errormessages. This will help others to help you.
For new users, you need to assign them permission to log in to theserver, and you need to grant them permission to access your Ctrackdatabase. If you are having trouble doing this, let us know ifyou are using osql, Enterprise Manager, or some other tool.
And, BTW, you are making an excellent decision to stop using the saaccount for your application. This account should never be usedto access the database from any application.
|||

here is teh error i get when i try to login as a user called paul, i have created the user via enterprise manager both in the master database and my ctrack database. authentication is set to sql & windows (is this the best?) and what hav eI d one wrong or more likely not done at all.
Paul
Login failed for user 'paul'.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details:System.Data.SqlClient.SqlException: Login failed for user 'paul'.
Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException: Login failed for user 'paul'.] System.Data.SqlClient.ConnectionPool.CreateConnection() +402 System.Data.SqlClient.ConnectionPool.UserCreateRequest() +147 System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +392 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 Web1.login.Button1_Click(Object sender, EventArgs e) +232 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1292

|||Are you sure that the password for user paul is correct? Have you tried resetting it to make sure?
|||yep, I have reset it twice now just to be absolutely sure, where should I create the user though in the master db or my db?|||Well, you're going to actually *create* the user for that instance ofSQL Server, but you'll need to give it permissions to yourdatabase. I'd say that the easiest way to test accounts onceyou've initially created them, is to use them to log into QueryAnalyzer and try to run SQL statements directly. That makes iteasy to see what permissions they do and don't have, without beingbound to only the SQL statements that you application needs to run, andit also rules out potential connection string problems.
|||

i logged into the server as user paul and ran query analyser and quiereied (?) my database without any trouble, authentication is set to sql server and windows any more ideas anyone?

|||

I deleted the user and recreated it using sql authentication rather than windows authentication and now I can connect, what is the differenc and does anyone why I could not connect with windows auth?

Paul

|||Because the User ID and Password attributes of the connection string are specific to SQL authentication.
|||

I knew it had to be me doing something stupid....

thanks all

How to Log Locks within a Database

I was wondering if there was a simple script that could be run or a way to h
ave an entry created in a log file whenever a SQL Lock occurs. Specifically
if it could also give the username of the user running the query that creat
ed the lock. Thank you.You could have a profiler trace running. But be aware that the locking
activity in SQL Server can be *very* high! Do a test first so you don't
overload the system with the logging.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Don" <anonymous@.discussions.microsoft.com> wrote in message
news:3A5B46FE-B873-4AD4-8078-27C7B2DC885D@.microsoft.com...
> I was wondering if there was a simple script that could be run or a way to
have an entry created in a log file whenever a SQL Lock occurs.
Specifically if it could also give the username of the user running the
query that created the lock. Thank you.|||Tibor, Thanks for the reply. I tried profiling but noticed the performance
decrease. All I really would like is basically something that alerts me via
either a log file I can check daily or a netsend message that tells me when
the database gets blocked
by a SPID and who it is that is causing the block. I don't actually need to
monitor every lock as I found out with the profiler. Thank you.|||INF: How to Monitor SQL Server 2000 Blocking
http://support.microsoft.com/defaul...kb;EN-US;271509
Also have a look at
INF: Troubleshooting Application Performance with SQL Server
http://support.microsoft.com/defaul...kb;EN-US;224587
HOW TO: Troubleshoot Slow-Running Queries on SQL Server 7.0 or Later
http://support.microsoft.com/defaul...kb;EN-US;243589
INF: Understanding and Resolving SQL Server 7.0
or 2000 Blocking Problems
http://support.microsoft.com/defaul...b;EN-US;Q224453
As well as these articles themselves, they contain links in them to lots
of other performace troubleshooting type articles. Lots of good stuff !
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Don" <anonymous@.discussions.microsoft.com> wrote in message
news:3A5B46FE-B873-4AD4-8078-27C7B2DC885D@.microsoft.com...
> I was wondering if there was a simple script that could be run or a way to
have an entry created in a log file whenever a SQL Lock occurs.
Specifically if it could also give the username of the user running the
query that created the lock. Thank you.

How to log in to SQL with a user other than sa

my connection string is
"Data Source=w2k3-std;Initial Catalog=CTrack;User Id=sa;Password=********;"
I have created extra users in both my database and the master database but if I change the userid and password as above they fail to connect.
Why?
Cheers
PaulHi, the answer to your question is going to depend upon the errormessage you are seeing. Please be sure to post exact errormessages. This will help others to help you.
For new users, you need to assign them permission to log in to theserver, and you need to grant them permission to access your Ctrackdatabase. If you are having trouble doing this, let us know ifyou are using osql, Enterprise Manager, or some other tool.
And, BTW, you are making an excellent decision to stop using the saaccount for your application. This account should never be usedto access the database from any application.
|||

here is teh error i get when i try to login as a user called paul, i have created the user via enterprise manager both in the master database and my ctrack database. authentication is set to sql & windows (is this the best?) and what hav eI d one wrong or more likely not done at all.
Paul
Login failed for user 'paul'.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details:System.Data.SqlClient.SqlException: Login failed for user 'paul'.
Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException: Login failed for user 'paul'.] System.Data.SqlClient.ConnectionPool.CreateConnection() +402 System.Data.SqlClient.ConnectionPool.UserCreateRequest() +147 System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +392 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 Web1.login.Button1_Click(Object sender, EventArgs e) +232 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1292

|||Are you sure that the password for user paul is correct? Have you tried resetting it to make sure?
|||yep, I have reset it twice now just to be absolutely sure, where should I create the user though in the master db or my db?|||Well, you're going to actually *create* the user for that instance ofSQL Server, but you'll need to give it permissions to yourdatabase. I'd say that the easiest way to test accounts onceyou've initially created them, is to use them to log into QueryAnalyzer and try to run SQL statements directly. That makes iteasy to see what permissions they do and don't have, without beingbound to only the SQL statements that you application needs to run, andit also rules out potential connection string problems.
|||

i logged into the server as user paul and ran query analyser and quiereied (?) my database without any trouble, authentication is set to sql server and windows any more ideas anyone?

|||

I deleted the user and recreated it using sql authentication rather than windows authentication and now I can connect, what is the differenc and does anyone why I could not connect with windows auth?

Paul

|||Because the User ID and Password attributes of the connection string are specific to SQL authentication.
|||

I knew it had to be me doing something stupid....

thanks all

how to locate the exact user name who owns a db object

hi all,
In sql 2000, how can you find out the exact user name who owns/created a db
object? They are generally recorded as 'dbo' in the sysobjects table, how
can we find out the specific user login name behind the 'dbo' entry?
many thanks,
JJThe 'dbo' user in a database is a special user that maps to the login
who owns the database (usually the login who initially created the
database). The system stored proc "exec sp_helpdb '<dbname>'" will tell
you who the owner of the database is and that login will be the one that
maps to the dbo user in the database.
Other, less Microsoft approved, ways of finding this info would be:
* "select * from master.dbo.sysdatabases" (the sid column is the
login that owns a given database, ie. that maps to the dbo user in
that database, and you can join that to master.dbo.syslogins to
get more info about that login)
* "select * from <dbname>.dbo.sysusers" (the dbo user in the
database is always uid 1; the sid column in that table will map
back to the master.dbo.syslogins table to tell you who owns the
database...unless the database user is an orphaned user (the sid
doesn't map back to any row in master.dbo.syslogins) which often
happens when you restore DBs from other servers because the other
server has different data in its master.dbo.syslogins table; this
can be corrected with sp_change_users_login)
* You could use the SUSER_SNAME() function with the sysusers table
like this:
select SUSER_SNAME(sid) from <dbname>.dbo.sysusers where uid = 1
Bear in mind, not every object in a DB has to be owned by the dbo user,
although this is quite normal. To find out which DB user owns a
specific object in the database you can use the OBJECTPROPERTY()
function like this:
select USER_NAME(OBJECTPROPERTY(OBJECT_ID('MyTa
ble'),'OwnerId'))
However, sp_helpdb is probably the easiest. Hope this helps.
*mike hodgson*
blog: http://sqlnerd.blogspot.com
JJ Wang wrote:

>hi all,
>In sql 2000, how can you find out the exact user name who owns/created a db
>object? They are generally recorded as 'dbo' in the sysobjects table, how
>can we find out the specific user login name behind the 'dbo' entry?
>many thanks,
>JJ
>|||JJ,
I think that would need to be accomplished by using a source control system
like Visual SourceSafe as many logins may have the ability to have dbo be
the owner of an object.
HTH
Jerry
"JJ Wang" <JJWang@.discussions.microsoft.com> wrote in message
news:73FC551C-3600-4E8F-8B37-B2BB9E890879@.microsoft.com...
> hi all,
> In sql 2000, how can you find out the exact user name who owns/created a
> db
> object? They are generally recorded as 'dbo' in the sysobjects table, how
> can we find out the specific user login name behind the 'dbo' entry?
> many thanks,
> JJ|||Hi,
the only wat i think for that is too tell your developers/DBAs to use full
name while creating db / objects .
Regards

How to load a talbe in SQL?

Dear dBforums memebers:

I want to know how to load a table in SQL*Plus environment.

I created a table called author(author_name char(30) ). Instead of using single INSERT statement. I want to load table with a datafile, or a script file.

Could someone tell me the procedure which will load a table using data file or a script file. My friend told me that SQL*Loader may do the job, but i couldn't find information on oracle website regrading this matter.

Can anyone can give me some suggestions. I appreciate your help:)

if possible, please show me a a detailed example, or web sources.

sjgrad03
12-20-03Your friend was correct, SQL*Loader is the right tool. See documentation at http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/part2.htm#436160

In order to access the documentation, you must login to the Oracle Technet web site. If you don't login, the URL will hang.

how to link multiple datasets's parameters?

I created three datasets. Every one has the same parameter and I need to link
them together. How to do it?
Thx.You can create a global report parameter and link it to the parameters in
your query. See the sample Sales Invoice report included in the RS samples.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Mia" <Mia@.discussions.microsoft.com> wrote in message
news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
>I created three datasets. Every one has the same parameter and I need to
>link
> them together. How to do it?
> Thx.|||Where do I find these sample reports?
I can't find any mention of global report parameters in BOL
"Teo Lachev [MVP]" wrote:
> You can create a global report parameter and link it to the parameters in
> your query. See the sample Sales Invoice report included in the RS samples.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Mia" <Mia@.discussions.microsoft.com> wrote in message
> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
> >I created three datasets. Every one has the same parameter and I need to
> >link
> > them together. How to do it?
> >
> > Thx.
>
>|||Install the sample reports that come with RS. With RS 2000, there should be
a link to the installer in the Reporting Services group. I called them
"global" because they are report-level parameters.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"David" <David@.discussions.microsoft.com> wrote in message
news:FF10B3A5-5E2E-487F-87A4-21CDD6C79F0D@.microsoft.com...
> Where do I find these sample reports?
> I can't find any mention of global report parameters in BOL
> "Teo Lachev [MVP]" wrote:
>> You can create a global report parameter and link it to the parameters in
>> your query. See the sample Sales Invoice report included in the RS
>> samples.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "Mia" <Mia@.discussions.microsoft.com> wrote in message
>> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
>> >I created three datasets. Every one has the same parameter and I need to
>> >link
>> > them together. How to do it?
>> >
>> > Thx.
>>|||OK, I have that report and opened it.
There is 2 datasets and each datasets as the same parameter name in the query.
Is the Global Report Paremeter, that you are refering to, this dialog box:
REPORT>REPORT PARAMETERS
If so, how do you go about linking this parameter to the parameters in your
query?
Normally, when you create the parameter in your query, it appears
automatically in this dialog box. But what do you do if it doesn't?
"Teo Lachev [MVP]" wrote:
> Install the sample reports that come with RS. With RS 2000, there should be
> a link to the installer in the Reporting Services group. I called them
> "global" because they are report-level parameters.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "David" <David@.discussions.microsoft.com> wrote in message
> news:FF10B3A5-5E2E-487F-87A4-21CDD6C79F0D@.microsoft.com...
> > Where do I find these sample reports?
> >
> > I can't find any mention of global report parameters in BOL
> >
> > "Teo Lachev [MVP]" wrote:
> >
> >> You can create a global report parameter and link it to the parameters in
> >> your query. See the sample Sales Invoice report included in the RS
> >> samples.
> >>
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> "Mia" <Mia@.discussions.microsoft.com> wrote in message
> >> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
> >> >I created three datasets. Every one has the same parameter and I need to
> >> >link
> >> > them together. How to do it?
> >> >
> >> > Thx.
> >>
> >>
> >>
>
>|||1. You use a placeholder for this parameter in your dataset query, e.g.:
WHERE (SOH.SalesOrderNumber = @.SalesOrderNumber)
2. You open the dataset properties and in the Parameters tab you link the
query parameter to the report-level parameter, like so:
Name Value
-- ---
@.SalesOrder Header =Parameters!SalesOrderNumber.Value
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"David" <David@.discussions.microsoft.com> wrote in message
news:168C68E8-B032-4668-9AB3-A52EBB4E3342@.microsoft.com...
> OK, I have that report and opened it.
> There is 2 datasets and each datasets as the same parameter name in the
> query.
> Is the Global Report Paremeter, that you are refering to, this dialog box:
> REPORT>REPORT PARAMETERS
> If so, how do you go about linking this parameter to the parameters in
> your
> query?
>
> Normally, when you create the parameter in your query, it appears
> automatically in this dialog box. But what do you do if it doesn't?
>
> "Teo Lachev [MVP]" wrote:
>> Install the sample reports that come with RS. With RS 2000, there should
>> be
>> a link to the installer in the Reporting Services group. I called them
>> "global" because they are report-level parameters.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "David" <David@.discussions.microsoft.com> wrote in message
>> news:FF10B3A5-5E2E-487F-87A4-21CDD6C79F0D@.microsoft.com...
>> > Where do I find these sample reports?
>> >
>> > I can't find any mention of global report parameters in BOL
>> >
>> > "Teo Lachev [MVP]" wrote:
>> >
>> >> You can create a global report parameter and link it to the parameters
>> >> in
>> >> your query. See the sample Sales Invoice report included in the RS
>> >> samples.
>> >>
>> >> --
>> >> HTH,
>> >> ---
>> >> Teo Lachev, MVP, MCSD, MCT
>> >> "Microsoft Reporting Services in Action"
>> >> "Applied Microsoft Analysis Services 2005"
>> >> Home page and blog: http://www.prologika.com/
>> >> ---
>> >> "Mia" <Mia@.discussions.microsoft.com> wrote in message
>> >> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
>> >> >I created three datasets. Every one has the same parameter and I need
>> >> >to
>> >> >link
>> >> > them together. How to do it?
>> >> >
>> >> > Thx.
>> >>
>> >>
>> >>
>>|||Thank You!
Thank You!
Thank You!
I have been having a hell of a time trying to figure out the solution top
this problem.
I was developing a report that had the WHERE clause hard code with a value.
Once I completed development, I change the hard code to a parameter. RS would
not recognize it as a parameter and kept telling my variables were unbound.
I was all over the net and this forum trying to find the answer.
"Teo Lachev [MVP]" wrote:
> 1. You use a placeholder for this parameter in your dataset query, e.g.:
> WHERE (SOH.SalesOrderNumber = @.SalesOrderNumber)
> 2. You open the dataset properties and in the Parameters tab you link the
> query parameter to the report-level parameter, like so:
> Name Value
> -- ---
> @.SalesOrder Header =Parameters!SalesOrderNumber.Value
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "David" <David@.discussions.microsoft.com> wrote in message
> news:168C68E8-B032-4668-9AB3-A52EBB4E3342@.microsoft.com...
> > OK, I have that report and opened it.
> >
> > There is 2 datasets and each datasets as the same parameter name in the
> > query.
> >
> > Is the Global Report Paremeter, that you are refering to, this dialog box:
> > REPORT>REPORT PARAMETERS
> >
> > If so, how do you go about linking this parameter to the parameters in
> > your
> > query?
> >
> >
> > Normally, when you create the parameter in your query, it appears
> > automatically in this dialog box. But what do you do if it doesn't?
> >
> >
> > "Teo Lachev [MVP]" wrote:
> >
> >> Install the sample reports that come with RS. With RS 2000, there should
> >> be
> >> a link to the installer in the Reporting Services group. I called them
> >> "global" because they are report-level parameters.
> >>
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> "David" <David@.discussions.microsoft.com> wrote in message
> >> news:FF10B3A5-5E2E-487F-87A4-21CDD6C79F0D@.microsoft.com...
> >> > Where do I find these sample reports?
> >> >
> >> > I can't find any mention of global report parameters in BOL
> >> >
> >> > "Teo Lachev [MVP]" wrote:
> >> >
> >> >> You can create a global report parameter and link it to the parameters
> >> >> in
> >> >> your query. See the sample Sales Invoice report included in the RS
> >> >> samples.
> >> >>
> >> >> --
> >> >> HTH,
> >> >> ---
> >> >> Teo Lachev, MVP, MCSD, MCT
> >> >> "Microsoft Reporting Services in Action"
> >> >> "Applied Microsoft Analysis Services 2005"
> >> >> Home page and blog: http://www.prologika.com/
> >> >> ---
> >> >> "Mia" <Mia@.discussions.microsoft.com> wrote in message
> >> >> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
> >> >> >I created three datasets. Every one has the same parameter and I need
> >> >> >to
> >> >> >link
> >> >> > them together. How to do it?
> >> >> >
> >> >> > Thx.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

How to know what schema was modified

Hello,

Is there a way in MSSQL server to find all the objects in the database
based on the modified date rather than the created date.

Thanks in advance
Kumuunfortunately, sqlserver does not store such info. so, you can't.

--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net

"kumu" <forlist2001@.yahoo.com> wrote in message
news:a44abd39.0311191320.6e962c15@.posting.google.c om...
> Hello,
> Is there a way in MSSQL server to find all the objects in the database
> based on the modified date rather than the created date.
> Thanks in advance
> Kumu