I think the problem is with your assumption that the system is set to have Sunday be the LAST day of the week and NOT the FIRST day.

Try running this...

Another way to tell is by looking at sp_who2 and look for something that says backing up.....

Depending on the amount of data it might even be beneficial to look at taking a BACKUP of your production and RESTORING it on DEV and then running a script...

It might help you to do research on CUBE building.  This might help you get what you want.  See BOL

I know that you have stated you can manipulate items/data using EM.  Is this using the same ID "Testing"?  Can you get into QA with "Testing" user?

Why not simply add another column that denotes SENT to Customer.  Make it a BIT flag and then everytime you send the report update the BIT to 1.  This way...

Another trick that I use is to create a table to house SQL statements VARCHAR(8000).  I string my SQL statement together and then write it to the table.  I ONLY...

Research Using RAND and NEWID in BOL.

If you are trying to use the UDF like a table why not use something like SELECT * FROM dbo.udf_MyTableFunction?

You can write a routine that reads an Access table and then creates TABLEDEFs for the tables and then connects those using an ODBC string that you also wrote in...

Does SA have the same password on both boxes?  Not very familiar with replication so if this is a no-brainer I apologize

Have you tried opening the .mdmp file with wordpad?

Nazri,

AFAIK IF you are changing the IDs you will have to create the links the old fashioned way MANUALLY....  unless you can figure out the NEWID and compare it...

What we have done here is add the DATETIME of file create to the filename.  Inherently, the files are read in the proper order (at least so far (knock on...

I would take the programming one first, have your company buy you books on SQL 2K and then convince them you need to take Admin class as well....