POS.ldf file missing
do you have a pos.ldf file for this system? because i cannot attach your database to sql server because he will be looking for pos.ldf file. can you send it to me? heres my e-add [email protected].
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.
Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.
FOR YOUR OWN SAFETY, PLEASE:
1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
USE [master] GO /****** Object: Database [Pos] Script Date: 16-04-2013 14:51:20 ******/ CREATE DATABASE [Pos] CONTAINMENT = NONE ON PRIMARY ( NAME = N'Pos', FILENAME = N'd:\Pos.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'Pos_log', FILENAME = N'd:\Pos_log.ldf' , SIZE = 504KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%) GO ALTER DATABASE [Pos] SET COMPATIBILITY_LEVEL = 110 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) BEGIN EXEC [Pos].[dbo].[sp_fulltext_database] @action = 'enable' END GO ALTER DATABASE [Pos] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [Pos] SET ANSI_NULLS OFF GO ALTER DATABASE [Pos] SET ANSI_PADDING OFF GO ALTER DATABASE [Pos] SET ANSI_WARNINGS OFF GO ALTER DATABASE [Pos] SET ARITHABORT OFF GO ALTER DATABASE [Pos] SET AUTO_CLOSE OFF GO ALTER DATABASE [Pos] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [Pos] SET AUTO_SHRINK OFF GO ALTER DATABASE [Pos] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [Pos] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [Pos] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [Pos] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [Pos] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [Pos] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [Pos] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [Pos] SET DISABLE_BROKER GO ALTER DATABASE [Pos] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [Pos] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [Pos] SET TRUSTWORTHY OFF GO ALTER DATABASE [Pos] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [Pos] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [Pos] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [Pos] SET HONOR_BROKER_PRIORITY OFF GO ALTER DATABASE [Pos] SET RECOVERY SIMPLE GO ALTER DATABASE [Pos] SET MULTI_USER GO ALTER DATABASE [Pos] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [Pos] SET DB_CHAINING OFF GO ALTER DATABASE [Pos] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) GO ALTER DATABASE [Pos] SET TARGET_RECOVERY_TIME = 0 SECONDS GO ALTER DATABASE [Pos] SET READ_WRITE GO USE [Pos] GO /****** Object: Table [dbo].[usuario] Script Date: 16-04-2013 14:51:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[usuario]( [DATA] [nvarchar](50) NULL, [Nome] [nvarchar](50) NULL, [Datanasc] [nvarchar](50) NULL, [Passaport] [nvarchar](50) NULL, [filiacao] [nvarchar](50) NULL, [reparticao] [nvarchar](50) NULL, [nivel] [nvarchar](50) NULL, [DTB] [nvarchar](50) NULL, [Estado] [nvarchar](50) NULL, [Acesso] [nvarchar](50) NULL ) ON [PRIMARY] GO USE [Pos] GO /****** Object: Table [dbo].[Table_1] Script Date: 16-04-2013 14:51:09 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Table_1]( [hh] [DECIMAL](18, 0) NULL ) ON [PRIMARY] GO USE [Pos] GO /****** Object: Table [dbo].[Product_x] Script Date: 16-04-2013 14:51:05 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Product_x]( [Product_No] [nvarchar](50) NULL, [Product_Shortcode] [nvarchar](50) NULL, [Product_name] [nvarchar](50) NULL, [Unit] [nvarchar](MAX) NULL, [Barcode] [nvarchar](MAX) NULL, [Categoryname] [nvarchar](50) NULL, [Unit_Price] [money] NULL, [Price] [money] NULL, [Mincriticalstocklevel] [INT] NULL, [Createdby] [nvarchar](MAX) NULL, [Datecreated] [nvarchar](50) NULL, [Brand_name] [nvarchar](50) NULL, [Stock] [INT] NULL, [Impost] [NCHAR](10) NULL, [Stockcritico] [INT] NULL, [custo] [money] NULL, [USUARIO] [nvarchar](MAX) NULL, [data2] [INT] NULL, [data3] [INT] NULL, [temp] [nvarchar](50) NULL, [doc] [INT] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO USE [Pos] GO /****** Object: Table [dbo].[Product] Script Date: 16-04-2013 14:51:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Product]( [Product_No] [nvarchar](50) NULL, [Product_Shortcode] [nvarchar](50) NULL, [Product_name] [nvarchar](50) NULL, [Unit] [nvarchar](MAX) NULL, [Barcode] [nvarchar](MAX) NULL, [Categoryname] [nvarchar](50) NULL, [Unit_Price] [money] NULL, [Price] [money] NULL, [Mincriticalstocklevel] [INT] NULL, [Createdby] [nvarchar](MAX) NULL, [Datecreated] [nvarchar](50) NULL, [Brand_name] [nvarchar](50) NULL, [Stock] [INT] NULL, [Impost] [NCHAR](10) NULL, [Stockcritico] [INT] NULL, [custo] [money] NULL, [Data2] [INT] NULL, [Data3] [INT] NULL, [usuario] [nvarchar](50) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO USE [Pos] GO /****** Object: Table [dbo].[Numerario2] Script Date: 16-04-2013 14:50:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Numerario2]( [Ordem] [INT] IDENTITY(1000,1) NOT NULL, [Estado] [nvarchar](50) NULL, [DATA] [nvarchar](50) NULL ) ON [PRIMARY] GO USE [Pos] GO /****** Object: Table [dbo].[Numera_s] Script Date: 16-04-2013 14:50:45 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Numera_s]( [Ordem] [INT] IDENTITY(1000,1) NOT NULL, [Estado] [nvarchar](50) NULL, [DATA] [nvarchar](50) NULL ) ON [PRIMARY] GO