How To Verify Sp_recompile On Tables In A Database
Nov 29, 2007
UPDATE STATISTICS '
SP_RECOMPILE
i want to verify these 2 statements on the tables in a particular database..
how can i do this..
ADVERTISEMENT
How To Verify Whether All The Tables Have Inserted
Jan 23, 2015I am working on sql integrating with Hybris. Most of you are not aware of hybris as it was a new technology.
In hybris we will create some classes and in those classes we will insert some tables. These tables will be automatically inserted into the sql server. No need to manually insert them the hybris structure will insert it. So my doubt is, how can we find out whether all the records have been inserted into sql database or not how we can check that.
Is there any way?? We have those classes in wich we can see which tables are there. Or else from the data model itself we can see what are the tables avilable or shud be inserted into sql thru hybris.
Can we check by giving all the table names in a single query?? or is there any other way to find out. If we can check by giving all the table names in single query how we need to give it.
Verify If Database Exists
Nov 23, 2005Hi,Is there a simple way to verify if a database exists?I'm writing a stored procedure that will accept a database name as an inputparameter,and create the database if it does't already exist.--Message posted via http://www.sqlmonster.com
View 2 Replies View RelatedHow To Verify Database Backup Completed?
Jul 31, 2004Hello, everyone:
Does any baby offer command to verify if database backup is completed? In backup wazard, there is an option "Verify backup upon completion" . Is there the SQL command? Thanks.
ZYT
Using SqlCeEngine To Verify/Restore A Database
Jul 31, 2006I have a compact pc program that uses a sql server database (sdf file).
I want to check the database integrity when program starts so I added a call to veriy method of SqlCeEngine
string dbFullName = System.IO.Path.GetDirectoryName(
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "NessDB.sdf";
SqlCeEngine engine = new SqlCeEngine("Data Source = " + dbFullName);
engine.Verify();
The call to verify always returning false and when I call repair
string dbFullName = System.IO.Path.GetDirectoryName(
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "NessDB.sdf";
SqlCeEngine engine = new SqlCeEngine("Data Source = " + dbFullName);
engine.Repair(null, RepairOption.RecoverCorruptedRows);
the program crashes and I get an exception "The specified module could not be found"
Why this happen and how can I check database corruption.
Verify Multiple Database Backups Using Single Statement
Oct 25, 2007Hi all,
I have taken more than one database backups and i have an idea that we can verify single backup using "restore verifyonly from disk='<path>'" statement.
Now my question is Could we verify all(More than one backup) backups with single statement?
Any suggestion would be helpful to me:-)
Thanks in advance,
Sp_recompile
Aug 3, 2000Hello!
SQL Server 7.0
Is it true we don't need to run sp_recompile (all tables) on regular basis
as since SQL Server runs it automatically after UPDATE STATISTICS ....
...and SQL Server runs UPDATE STATISTICS automatically too?
So, SQL Server runs UPDATE STATISTICS automatically then (after that) SQL Server runs sp_recompile automatically ?
BOL says:
Microsoft® SQL Server™ automatically recompiles stored procedures and triggers when it is advantageous to do so.
Thank you.
Anny
Sp_recompile - Script ???
Apr 12, 2001Does anyone out there know if a script exists which will recompile all of the stored procedures in a database ? Any suggestions would be appreciated. Thanks
View 1 Replies View RelatedSp_recompile Errors
Mar 9, 2000We have a customer who indicates that a certain process in their financial application consistently fails each morning - after the update statistics and sp_recompile is run. They indicate that after this first failure, they are able to successfully run the process.
Has anyone ever heard of this - where a stored procedure will yield erroneous results when run the first time after an sp_recompile?
Many thanks in advance!
Sp_recompile Script/stored Procedure
Oct 18, 2007Folks:
I want to run sp_recompile on a weekly basis. Does anybody have a script / stored procedure which will get all the Stored Procedures and Tables from a database and do a recompile. I wrote this small script but it is giving me a error as "Incorrect syntax near 'sp_recompile'."
CREATE PROCEDURE usp_Recompile
AS
DECLARE @ObjName varchar(255)
DECLARE @Statement nvarchar(255)
DECLARE @Command varchar(255)
DECLARE ObjCursor CURSOR FOR
SELECT name FROM sys.objects
where type in ('P','U')
OPEN ObjCursor
FETCH NEXT FROM ObjCursor INTO @ObjName
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT 'RECOMPILING ' + @ObjName
sp_recompile (@ObjName)
--SET @Statement = 'UPDATE STATISTICS ' + @TableName + ' WITH FULLSCAN'
--EXEC sp_executesql @Statement
FETCH NEXT FROM ObjCursor INTO @ObjName
END
CLOSE ObjCursor
DEALLOCATE ObjCursor
Thanks !!
Merge Agent System Stored Procedures And Sp_Recompile
Jul 13, 2006Hello,
We are trying to be proactive and stop a potential performance issue by reducing the number of recompiles in our SQL 2000 database application. This database is replicated. After viewing output from Profiler and PerfMon it seems that over 90% of the recompiles are due to system stored procedures generated by replication merge agents. Can anything be done about this?
Thanks
Transact SQL :: Verify Inserted Values From One Table (in CSV File) With Another Table (in Database)
Aug 4, 2015I am looking for a Sql query to verify the inserted values from one table(in CSV file) with another table(in sql database)
For example: I have below Values column that is present in once CSV file, after my data migration the values get stored in Results table under Message column.
I need to very whether values(1X,1Y) are inserted in Message record "successfully inserted value 1X"
Values (CSV)
1X
1Y
Results Table(SQL)
CreatedDate                  Message
2015-08-04 08:45:29.203Â Â successfully inserted value 1X
2015-08-04 08:44:29.103Â Â TEst pass
2015-08-04 08:43:29.103Â Â successfully inserted value 1X
2015-08-04 08:42:29.203Â Â test point
2015-08-04 08:35:29.203Â Â successfully inserted value 1Y
2015-08-04 08:30:29.203Â Â Test Pass
2015-08-04 08:28:29.203Â Â successfully inserted value 1Y
If all values are inserted:
Output:
All values from values table are inserted successfully
Total count of values inserted: 2
If only few values are inserted, example only 1X from Values table is inserted in Message
Example:
Results Table CreatedDate    Message
2015-08-04 08:45:29.203Â Â successfully inserted value 1X
2015-08-04 08:44:29.103Â Â TEst pass
2015-08-04 08:43:29.103Â Â successfully inserted value 1X
2015-08-04 08:42:29.203Â Â test point
Output:
All values from values are not inserted successfully in result table.
Total count of values inserted: 1
Missing Values not inserted in results table are: 1Y
No Recompile After Sp_recompile Or WITH RECOMPILE Option
Aug 30, 2007I know that all the documentation always tells you that sp_recompile will force a stored procedure to recompile the next time it is executed. However, I am not seeing the recompiles in a SQL Trace, when capturing SP: Recompile events. I have tried this on many different database servers, using sp_recompile and also the WITH RECOMPILE option when creating the proc.
Can anyone explain this?
Solution!-Create Access/Jet DB, Tables, Delete Tables, Compact Database
Feb 5, 2007From Newbie to Newbie,
Add reference to:
'Microsoft ActiveX Data Objects 2.8 Library
'Microsoft ADO Ext.2.8 for DDL and Security
'Microsoft Jet and Replication Objects 2.6 Library
--------------------------------------------------------
Imports System.IO
Imports System.IO.File
Code Snippet
'BACKUP DATABASE
Public Shared Sub Restart()
End Sub
'You have to have a BackUps folder included into your release!
Private Sub BackUpDB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BackUpDB.Click
Dim addtimestamp As String
Dim f As String
Dim z As String
Dim g As String
Dim Dialogbox1 As New Backupinfo
addtimestamp = Format(Now(), "_MMddyy_HHmm")
z = "C:Program FilesVSoftAppMissNewAppDB.mdb"
g = addtimestamp + ".mdb"
'Add timestamp and .mdb endging to NewAppDB
f = "C:Program FilesVSoftAppMissBackUpsNewAppDB" & g & ""
Try
File.Copy(z, f)
Catch ex As System.Exception
System.Windows.Forms.MessageBox.Show(ex.Message)
End Try
MsgBox("Backup completed succesfully.")
If Dialogbox1.ShowDialog = Windows.Forms.DialogResult.OK Then
End If
End Sub
Code Snippet
'RESTORE DATABASE
Private Sub RestoreDB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
RestoreDB.Click
Dim Filename As String
Dim Restart1 As New RestoreRestart
Dim overwrite As Boolean
overwrite = True
Dim xi As String
With OpenFileDialog1
.Filter = "Database files (*.mdb)|*.mdb|" & "All files|*.*"
If .ShowDialog() = Windows.Forms.DialogResult.OK Then
Filename = .FileName
'Strips restored database from the timestamp
xi = "C:Program FilesVSoftAppMissNewAppDB.mdb"
File.Copy(Filename, xi, overwrite)
End If
End With
'Notify user
MsgBox("Data restored successfully")
Restart()
If Restart1.ShowDialog = Windows.Forms.DialogResult.OK Then
Application.Restart()
End If
End Sub
Code Snippet
'CREATE NEW DATABASE
Private Sub CreateNewDB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
CreateNewDB.Click
Dim L As New DatabaseEraseWarning
Dim Cat As ADOX.Catalog
Cat = New ADOX.Catalog
Dim Restart2 As New NewDBRestart
If File.Exists("C:Program FilesVSoftAppMissNewAppDB.mdb") Then
If L.ShowDialog() = Windows.Forms.DialogResult.Cancel Then
Exit Sub
Else
File.Delete("C:Program FilesVSoftAppMissNewAppDB.mdb")
End If
End If
Cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Program FilesVSoftAppMissNewAppDB.mdb;
Jet OLEDB:Engine Type=5")
Dim Cn As ADODB.Connection
'Dim Cat As ADOX.Catalog
Dim Tablename As ADOX.Table
'Taylor these according to your need - add so many column as you need.
Dim col As ADOX.Column = New ADOX.Column
Dim col1 As ADOX.Column = New ADOX.Column
Dim col2 As ADOX.Column = New ADOX.Column
Dim col3 As ADOX.Column = New ADOX.Column
Dim col4 As ADOX.Column = New ADOX.Column
Dim col5 As ADOX.Column = New ADOX.Column
Dim col6 As ADOX.Column = New ADOX.Column
Dim col7 As ADOX.Column = New ADOX.Column
Dim col8 As ADOX.Column = New ADOX.Column
Cn = New ADODB.Connection
Cat = New ADOX.Catalog
Tablename = New ADOX.Table
'Open the connection
Cn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Program FilesVSoftAppMissNewAppDB.mdb;Jet
OLEDB:Engine Type=5")
'Open the Catalog
Cat.ActiveConnection = Cn
'Create the table (you can name it anyway you want)
Tablename.Name = "Table1"
'Taylor according to your need - add so many column as you need. Watch for the DataType!
col.Name = "ID"
col.Type = ADOX.DataTypeEnum.adInteger
col1.Name = "MA"
col1.Type = ADOX.DataTypeEnum.adInteger
col1.Attributes = ADOX.ColumnAttributesEnum.adColNullable
col2.Name = "FName"
col2.Type = ADOX.DataTypeEnum.adVarWChar
col2.Attributes = ADOX.ColumnAttributesEnum.adColNullable
col3.Name = "LName"
col3.Type = ADOX.DataTypeEnum.adVarWChar
col3.Attributes = ADOX.ColumnAttributesEnum.adColNullable
col4.Name = "DOB"
col4.Type = ADOX.DataTypeEnum.adDate
col4.Attributes = ADOX.ColumnAttributesEnum.adColNullable
col5.Name = "Gender"
col5.Type = ADOX.DataTypeEnum.adVarWChar
col5.Attributes = ADOX.ColumnAttributesEnum.adColNullable
col6.Name = "Phone1"
col6.Type = ADOX.DataTypeEnum.adVarWChar
col6.Attributes = ADOX.ColumnAttributesEnum.adColNullable
col7.Name = "Phone2"
col7.Type = ADOX.DataTypeEnum.adVarWChar
col7.Attributes = ADOX.ColumnAttributesEnum.adColNullable
col8.Name = "Notes"
col8.Type = ADOX.DataTypeEnum.adVarWChar
col8.Attributes = ADOX.ColumnAttributesEnum.adColNullable
Tablename.Keys.Append("PrimaryKey", ADOX.KeyTypeEnum.adKeyPrimary, "ID")
'You have to append all your columns you have created above
Tablename.Columns.Append(col)
Tablename.Columns.Append(col1)
Tablename.Columns.Append(col2)
Tablename.Columns.Append(col3)
Tablename.Columns.Append(col4)
Tablename.Columns.Append(col5)
Tablename.Columns.Append(col6)
Tablename.Columns.Append(col7)
Tablename.Columns.Append(col8)
'Append the newly created table to the Tables Collection
Cat.Tables.Append(Tablename)
'User notification )
MsgBox("A new empty database was created successfully")
'clean up objects
Tablename = Nothing
Cat = Nothing
Cn.Close()
Cn = Nothing
'Restart application
If Restart2.ShowDialog() = Windows.Forms.DialogResult.OK Then
Application.Restart()
End If
End Sub
Code Snippet
'COMPACT DATABASE
Private Sub CompactDB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
CompactDB.Click
Dim JRO As JRO.JetEngine
JRO = New JRO.JetEngine
'The first source is the original, the second is the compacted database under an other name.
JRO.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Program
FilesVSoftAppMissNewAppDB.mdb; Jet OLEDB:Engine Type=5", "Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:Program FilesVSoftAppMissNewAppDBComp.mdb; JetOLEDB:Engine Type=5")
'Original (not compacted database is deleted)
File.Delete("C:Program FilesVSoftAppMissNewAppDB.mdb")
'Compacted database is renamed to the original databas's neme.
Rename("C:Program FilesVSoftAppMissNewAppDBComp.mdb", "C:Program FilesVSoftAppMissNewAppDB.mdb")
'User notification
MsgBox("The database was compacted successfully")
End Sub
End Class
Please Verify Syntax
Jun 15, 2007I haven't written any .net database updates before. I wrote the following code for a visual web developer application and it appears to work. There is no close function or anything. Will the adapter, builder, dataset, and row objects be cleaned up and disposed of properly? Please tell me if I need to include anything else. The connection object is made elsewhere. ThanksDim adapter As New Data.SqlClient.SqlDataAdapter("SELECT * FROM Inventory WHERE InUnique=" & ListValue.Value, connect)
Dim builder As New Data.SqlClient.SqlCommandBuilder(adapter)Dim dataset As Data.DataSet = New Data.DataSet()
adapter.Fill(dataset, "Inventory")Dim datarow As Data.DataRow = dataset.Tables(0).Rows(0)
datarow("InAgUnique") = Val(InAgUnique.Text)datarow("InTyUnique") = Val(InTyUnique.Text)
datarow("InName") = InName.Textdatarow("InPnUniquePrimary") = Val(InPnUniquePrimary.Text)
datarow("InPnUniqueSecondary") = Val(InPnUniqueSecondary.Text)datarow("InPnUniqueTertiary") = Val(InPnUniqueTertiary.Text)
datarow("InPnUniqueSupervisor") = Val(InPnUniqueSupervisor.Text)datarow("InDescription") = InDescription.Text
datarow("InProblemInstructions") = InProblemInstructions.Text
adapter.Update(dataset, "Inventory")
Verify User
Jan 1, 2008Hi, all!
I'm really confused about how to run a query on the database to check to see the CustomerID filed value already exists in the database.
If it’s true, I want to display a message: “Valid� the user to proceed with the next steps
Else
Display the customer number doesn’t exist in the database, and cancel.
I tried all sorts of things and I just can't get it to do it. Hopefully you can help. Thank you
How To Verify A DB Via OLEDB?
Jul 30, 2007I cannot find any OLE DB reference material for how to perform a "Verify" DB as advertised in the Documentation for SQL Server Mobile Edition.
The docs have a sample in C#, but nothing for OLD DB in C++.
Does anyone know how to do this?
Please Verify This SQL Fragment
Aug 24, 2007Will someone please help verify this SQL fragment?
I want to ensure that it produces the same results as the 'Group By' clause of the MS Access fragment below.
T-SQL:
Group By Case
When r.LICFAC In ('CR', 'GC') And f.SOPNO < 38 Then -1
Else 0
End
, Case
When r.LICFAC = 'MU' And f.SOSTS <> '05' Then -1
Else 0
End
MS Access:
GROUP BY IIf((([LICFAC]="CR" Or [LICFAC]="GC") And ([SOPNO]<38)),True,False)
, IIf(([LICFAC]="MU") And ([SOSTS]<>"05"),True,False)
Can I Export Tables So That Existing Tables In Destination Database Will Be Modified?
Jul 20, 2005I'm working on an ASP.Net project where I want to test code on a localmachine using a local database as a back-end, and then export it tothe production machine where it uses the hosting provider's SQL Serverdatabase on the back-end. Is there a way to export tables from oneSQL Server database to another in such a way that if a table alreadyexists in the destination database, it will be updated to reflect thechanges to the local table, without existing data in the destinationtable being lost? e.g. suppose I change some tables in my localdatabase by adding new fields. Can I "export" these changes to thedestination database so that the new fields will be added to thedestination tables (and filled in with default values), without losingdata in the destination tables?If I run the DTS Import/Export Wizard that comes with SQL Server andchoose "Copy table(s) and view(s) from the source database" and choosethe tables I want to copy, there is apparently no option *not* to copythe data, and since I don't want to copy the data, that choice doesn'twork. If instead of "Copy table(s) and view(s) from the sourcedatabase", I choose "Copy objects and data between SQL Serverdatabases", then on the following options I can uncheck the "CopyData" box to prevent data being copied. But for the "CreateDestination Objects" choices, I have to uncheck "Drop destinationobjects first" since I don't want to lose the existing data. But whenI uncheck that and try to do the copy, I get collisions between theproperties of the local table and the existing destination table,e.g.:"Table 'wbuser' already has a primary key defined on it."Is there no way to do what I want using the DTS Import/Export Wizard?Can it be done some other way?-Bennett
View 3 Replies View RelatedHow Can I Verify A GUID Number ?
May 13, 2004Dear SQL,
I need to SELECT something from a database that has a UNIQUEIDENTIFIER (GUID) field,
If the number is wrong (has some other than A-Z 0-9) than the ASP page just freaks out and gets "error converting from a character string to uniqueidentifier"
How can I check that the GUID is OK before I SELECT ?
this is the number format:
{7A9B5F81-4936-4A31-B4E2-9168AAB75A0}
I tried to cast this "error" number with no successs:
"WHERE Deceased_ID = cast('"& "---------4936-4A31-B4E2-9168AAB75A0" &"' as uniqueidentifier)"
Thanks in advance, Yovav.
Verify Sql 2005 Sp1 Installation
Jan 17, 2007How can I verify if the sp1 is installed on my sql server 2005 server ?
Cosimo
How To Verify If SQL Server Is Installed
Apr 1, 2008
Hi, guys,
I've to build a program that verify if SQL Server is installed. How can I verify that?
Thanks in advance.
Vagner
How Can I Verify The Availability Of An SQL Server
Nov 18, 2006Hello everyone,
I have an ASP application mainly connected to one SQL database that works great but now I am trying to add some functionality that requires to connect to another remote SQL server. Till now all is fine except that the remote SQL server is not always online and of course when this happens my ASP application stops with the following error:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found.
in my Global.asa I setup my session variables for DSN connections and in my pages I call my SQL connection as follow:
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open Session("MySQL")
SQL = "my SQL statement here;"
Set RS = Conn.Execute(SQL)
Every time the page hits the Conn.Open line I get the error if the remote SQL is not online!!!
Is there a way I can check a sort of returned error code holding the connection status before getting to the Conn.Open line???
Any help would be greatly appreciated.
Thx in advance
How To Verify Installed License
Mar 6, 2007I have inherited serveral SQL 2000 servers and need to know if there is a way to verify the license that was installed, per processor or Server + Cals.
Thanks,
Skip Berry
Verify SQL Server Setup
Jun 14, 2007How do you verify SQL Server setup?
For example: SQL Server is installed on a machine and you want to verify its setup to make sure everything is intact, what are the key things you go and look out for?
Is there a command to do this?
or a procedure to follow.
How To Drop An Identity Column From All Tables Tables In A Database
Mar 2, 2008Does anyone have a script that can drop the Identity columns from all the tables in a database? Thanks
View 1 Replies View RelatedHow To Check/verify SQL Login Credential
Nov 15, 2007Hi, I am making a module to backup SQL Db from webpage. I impersonate asp.net user to a given Windows Account and need to verify that account has required permission in SQL Server.I don't know how to verify the windows account credential for SQL Server login. Now what I am doing is to run SQL query against database to select row from some table, if it is successful, the user is valid SQL login. But I know it's not the way. Any idea? Thanks,
View 1 Replies View RelatedVerify Rows In Trigger After Update
Aug 17, 2004The Trigger must verify one field for eveery row updated and roll back any incorrect ones. I have tried different ways but I can't figure out how to make it work.
View 10 Replies View RelatedVerify Dynamically Specified Table Exists
Jul 23, 2005I need to write a stored procedure to verify that a table exists andalso that the user executing the stored procedure has access to thespecified table.Any user can call this publicly available procedure and pass a databasename, an owner name and a table name as parameters. The procedurereturns success if the table exists and the user has access to it, orfails if he doesn't. Here's a simplified version of what I have, butI'm wondering if there's a better way. Thanks.create procedure dumb asbegindeclare @myError int,@mytable varchar(128),@myquery varchar(128)select @mytable = '[Northwind].[dbo].[sysobjects2]'select @myquery = 'DECLARE @x int SELECT @x = count(1) from ' +@mytable + ' where 1 = 2'exec (@myquery)select @myError = @@ERRORif @myError != 0BEGINRAISERROR ('ERROR: The specified table %s cannot be accessed.', 10, 1,@mytable)RETURN 1endendgo
View 10 Replies View RelatedHow To Verify The Agent Is Up On A Remote Host?
Jul 20, 2005Hi,Somtimes the agent will just die on some computers...I'd like to have a job monitoring the agent every 20 minutes or so..Do you know of a way to tell if the agent is up or no using plain Tsql?ThanksGaspar
View 1 Replies View RelatedVerify SQL Server 2005 Installation
Sep 21, 2006Hi,
How can I verify whether the particular SQL Server 2005 installtion is 32-bit SQL Server 2005 or 64-bit SQL server 2005?
Thanks,
Ritesh
How Can We Verify The Clustering Algorithm Models?
Dec 5, 2006Hi, all here,
Since we are not able to use accuracy chart for Clustering algorithms there. So how can we verify the accuracy of clustering algorithm models here in terms of its classification and regression tasks?
Thank you very much in advance for your guidance and advices for that.
With best regards,
Yours sincerely,
Verify Parameter Values At Runtime
May 5, 2008I have a report that has three parameters. View, Tier and Manager. The View parameter has 3 possible choices: Company, Manager and Tier. If the user selects Company then they cannot select anything in the other two parameters. If the user selects Manager from the View parameter then they can only select something for the Manager parameter. Likewise, if they choose Tier from the View parameter they can only select something for the Tier parameter.
This is all working like I want it and provides the desired results. However, if a user selects Tier for the View parameter and then doesn't select anything for the Tier parameter it is just like selecting Company from the View parameter. What I'd like to do is have error checking so that if they do choose Tier from the View parameter and then try and run the report and Tier is still null have it indicate that they have to choose a tier.
To get the first part of this to work I had to create datasets that contained just a null and then default Manager and Tier to that dataset. Choosing the default of Null in the parameter set up didn't work.
I think the error checking could look something like this:
=IIf(Parameters!View.Value = "Tier" AND IsNothing(Parameters!tier.Value) , "Must Select Tier", Parameters!tier.Value)
Now, I just need to know where to put it. Is there something that it will look at before generating the report to check the values of parameters. Maybe like the NoRows property when no rows are returned?