Thank you so much Chuck...I have one question... Could you please explain below columns...

Bytes Total -----Is this the total size of a table(I've multiple filegroup and it...

Here is the script from the job...

CREATE PROC [dbo].[SPTEST]

AS

DECLARE @CMD0 nvarchar(2000)

DECLARE @CMD1 nvarchar(2000)

DECLARE @CMD1A nvarchar(2000)

DECLARE @CMD2 nvarchar(2000) ...

Hi…. now I got into another error while migrating another db from access to sql. When I open access file I see only 4 tables but when I use ssma...

Thanks Corgi. Yes I had attached one of the 2 queries and its related tables in my last post.

Query:- qry_PI_reports

Errored out Query ( Table does not exist)

SELECT DISTINCT qry_PI_Reports.Func_Name...

What error do you see in the event log?

Thank you Corgi. As suggested below please find the table script and the Access Query .

Table Create Script and Insert Data Script--

CREATE TABLE [dbo].[tbl_PI_Associates](

[Assoc_Name] [nvarchar](50) NOT NULL,

[MgrName] [nvarchar](50)...

Thanks Corgi. I am just trying to understand your question here.. I have not created any proc to do this migration. I used SQL Server Migration Assistance for this task....

Thanks Corgi for your post. As suggested, I opened the query in the design mode and found 3 tables and yes those tables are already migrated.

When i open MS access file and i see there is a tab says queries and when click on that i see 8 queries and two of them are(qry_Reports and...

Hello Friends, Thank you so much for all you replies... I've a meeting next week with the Dev team and then i'll find out about these two queries and surly...

Thank you for your reply. I am still trying to figure out the issue here. After Modifying the queries now the error says that table does not exist... I checked...

Thank you for your reply. I am still trying to figure out the issue here. After Modifying the queries now the error says that table does not exist... I checked...

Hi Todd..As suggested, I ran below statement in the database but the result came out empty

corgi. thanks for your post. I am not trying to waste anyone's time. I am just trying to get the answer of my sql issue. I had a different question...

corgi. thanks for your post. I am not trying to waste anyone's time. I am just trying to get the answer of my sql issue. I had a different question...