belge aktar hatası

Katılım
17 Şubat 2008
Mesajlar
20
Excel Vers. ve Dili
2010
iyi calışmalar calışmalrını cok uzun zamandır hayretlerle izliyorum cok güzle şeyler yapıyorsunuz keşke bu kadar bilgi bide pazarlayabilsek neyse benim altaki yazdığım şekilde bi sorunum var yrd olursanız sevinrim şimdiden cok teşkkürler

USE [RSMAYKO2007]
GO
/****** Object: View [dbo].[MAYKO] Script Date: 07/17/2007 14:14:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[MAYKO]
AS
SELECT dbo.TBLFATUIRS.TIPI, dbo.TBLFATUIRS.FATIRS_NO, dbo.TBLFATUIRS.TARIH, dbo.TBLFATUIRS.CARI_KOD2, dbo.TBLFATUIRS.GENELTOPLAM,
dbo.TBLSTHAR.STHAR_GCMIK, dbo.TBLSTHAR.DEPO_KODU, dbo.TBLSTHAR.STOK_KODU, dbo.TBLCASABIT.CARI_ISIM AS Expr1,
dbo.TBLCASABIT.PLASIYER_KODU AS Expr2, dbo.TBLFATUIRS.CARI_KODU, dbo.TBLSTSABIT.STOK_ADI, dbo.TBLSTHAR.STHAR_GCKOD
FROM dbo.TBLSTSABIT INNER JOIN
dbo.TBLSTHAR ON dbo.TBLSTSABIT.STOK_KODU = dbo.TBLSTHAR.STOK_KODU CROSS JOIN
dbo.TBLCASABIT INNER JOIN
dbo.TBLFATUIRS ON dbo.TBLCASABIT.CARI_KOD = dbo.TBLFATUIRS.CARI_KODU

GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
Begin PaneConfigurations =
Begin PaneConfiguration = 0
NumPanes = 4
Configuration = "(H (1[40] 4[20] 2[20] 3) )"
End
Begin PaneConfiguration = 1
NumPanes = 3
Configuration = "(H (1 [50] 4 [25] 3))"
End
Begin PaneConfiguration = 2
NumPanes = 3
Configuration = "(H (1 [50] 2 [25] 3))"
End
Begin PaneConfiguration = 3
NumPanes = 3
Configuration = "(H (4 [30] 2 [40] 3))"
End
Begin PaneConfiguration = 4
NumPanes = 2
Configuration = "(H (1 [56] 3))"
End
Begin PaneConfiguration = 5
NumPanes = 2
Configuration = "(H (2 [66] 3))"
End
Begin PaneConfiguration = 6
NumPanes = 2
Configuration = "(H (4 [50] 3))"
End
Begin PaneConfiguration = 7
NumPanes = 1
Configuration = "(V (3))"
End
Begin PaneConfiguration = 8
NumPanes = 3
Configuration = "(H (1[56] 4[18] 2) )"
End
Begin PaneConfiguration = 9
NumPanes = 2
Configuration = "(H (1 [75] 4))"
End
Begin PaneConfiguration = 10
NumPanes = 2
Configuration = "(H (1[66] 2) )"
End
Begin PaneConfiguration = 11
NumPanes = 2
Configuration = "(H (4 [60] 2))"
End
Begin PaneConfiguration = 12
NumPanes = 1
Configuration = "(H (1) )"
End
Begin PaneConfiguration = 13
NumPanes = 1
Configuration = "(V (4))"
End
Begin PaneConfiguration = 14
NumPanes = 1
Configuration = "(V (2))"
End
ActivePaneConfig = 0
End
Begin DiagramPane =
Begin Origin =
Top = 0
Left = 0
End
Begin Tables =
Begin Table = "TBLFATUIRS"
Begin Extent =
Top = 6
Left = 255
Bottom = 114
Right = 448
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "TBLSTHAR"
Begin Extent =
Top = 2
Left = 481
Bottom = 110
Right = 658
End
DisplayFlags = 280
TopColumn = 12
End
Begin Table = "TBLCASABIT"
Begin Extent =
Top = 24
Left = 27
Bottom = 132
Right = 209
End
DisplayFlags = 280
TopColumn = 65
End
Begin Table = "TBLSTSABIT"
Begin Extent =
Top = 115
Left = 244
Bottom = 223
Right = 464
End
DisplayFlags = 280
TopColumn = 25
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
Begin ColumnWidths = 14
Width = 284
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
Width = 1500
End
End
Begin CriteriaPane =
Begin ColumnWidths = 11
Column = 1440
Alias = 900
Table = 1170
Output = 720
Append = 1400
NewValue = 1170
SortType = 1350
SortOrder =' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'VIEW', @level1name=N'MAYKO'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N' 1410
GroupBy = 1350
Filter = 1350
Or = 1350
Or = 1350
Or = 1350
End
End
End
' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'VIEW', @level1name=N'MAYKO'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'VIEW', @level1name=N'MAYKO'




------------------------------------------------------------------
--------------altttaki hatayı alıyorum nasıl düzletirim----------

------------------------------------------------------------------
Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'RSMAYKO2007'. No entry found with that name. Make sure that the name is entered correctly.
Msg 208, Level 16, State 1, Procedure MAYKO, Line 3
Invalid object name 'dbo.TBLSTSABIT'.
Msg 15135, Level 16, State 8, Procedure sp_addextendedproperty, Line 37
Object is invalid. Extended properties are not permitted on 'dbo.MAYKO', or the object does not exist.
Msg 15135, Level 16, State 8, Procedure sp_addextendedproperty, Line 37
Object is invalid. Extended properties are not permitted on 'dbo.MAYKO', or the object does not exist.
Msg 15135, Level 16, State 8, Procedure sp_addextendedproperty, Line 37
Object is invalid. Extended properties are not permitted on 'dbo.MAYKO', or the object does not exist.
 

Ekli dosyalar

Üst