Click here to Skip to main content
15,902,198 members
Home / Discussions / Database
   

Database

 
GeneralRe: Delete rows from a foxpro dbf file, that seems to be locked Pin
jkirkerx29-Dec-16 7:04
professionaljkirkerx29-Dec-16 7:04 
AnswerI got this working partially, but can't figure out why I can't delete by Invoice Number Pin
jkirkerx29-Dec-16 8:07
professionaljkirkerx29-Dec-16 8:07 
GeneralI got it working, not sure it will always work Pin
jkirkerx29-Dec-16 9:23
professionaljkirkerx29-Dec-16 9:23 
QuestionUpdating a FoxPro dbf file using VB.net Pin
jkirkerx22-Dec-16 11:32
professionaljkirkerx22-Dec-16 11:32 
AnswerRe: Updating a FoxPro dbf file using VB.net Pin
jkirkerx22-Dec-16 11:37
professionaljkirkerx22-Dec-16 11:37 
AnswerRe: Updating a FoxPro dbf file using VB.net Pin
jschell26-Dec-16 7:17
jschell26-Dec-16 7:17 
GeneralRe: Updating a FoxPro dbf file using VB.net Pin
jkirkerx27-Dec-16 7:09
professionaljkirkerx27-Dec-16 7:09 
QuestionDrop & Recreate the DB Pin
Kevin Marois21-Dec-16 12:48
professionalKevin Marois21-Dec-16 12:48 
I'm starting a new script. This is local on my machine and I'm the only user:
-- IF THE DATABASE EXISTS, DROP AND RE-CREATE IT
IF EXISTS (SELECT Name FROM master.dbo.sysdatabases WHERE name = N'Dashboard')
BEGIN
    ALTER DATABASE Dashboard SET SINGLE_USER WITH ROLLBACK IMMEDIATE
    DROP DATABASE Dashboard
END
CREATE DATABASE Dashboard

-- CREATE THE TABLES
GO
USE Dashboard
CREATE TABLE DashboardInfo
    (Id                 INT PRIMARY KEY NOT NULL,
     SiteId             INT NOT NULL,
     InstrumentId       INT NOT NULL,
     TowerLocation      INT NOT NULL)

The first time I run it all works fine. Any time I run it after that I get
Msg 3702, Level 16, State 3, Line 5
Cannot drop database "Dashboard" because it is currently in use.
Msg 1801, Level 16, State 3, Line 7
Database 'Dashboard' already exists. Choose a different database name.
Msg 2714, Level 16, State 6, Line 12
There is already an object named 'DashboardInfo' in the database.

If I close and re-open SSMS then it works ok again.

WTF is wrong here??????????
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.

AnswerRe: Drop & Recreate the DB Pin
Chris Quinn21-Dec-16 22:03
Chris Quinn21-Dec-16 22:03 
GeneralRe: Drop & Recreate the DB Pin
Kevin Marois22-Dec-16 4:37
professionalKevin Marois22-Dec-16 4:37 
QuestionRe: Drop & Recreate the DB Pin
Richard MacCutchan22-Dec-16 4:59
mveRichard MacCutchan22-Dec-16 4:59 
AnswerRe: Drop & Recreate the DB Pin
Kevin Marois22-Dec-16 4:59
professionalKevin Marois22-Dec-16 4:59 
AnswerRe: Drop & Recreate the DB Pin
Simon_Whale22-Dec-16 5:49
Simon_Whale22-Dec-16 5:49 
GeneralRe: Drop & Recreate the DB Pin
Kevin Marois22-Dec-16 5:54
professionalKevin Marois22-Dec-16 5:54 
QuestionSQL 2012 Restore Problem Pin
Kevin Marois21-Dec-16 4:46
professionalKevin Marois21-Dec-16 4:46 
AnswerRe: SQL 2012 Restore Problem Pin
Richard Deeming21-Dec-16 6:00
mveRichard Deeming21-Dec-16 6:00 
GeneralRe: SQL 2012 Restore Problem Pin
Kevin Marois21-Dec-16 6:02
professionalKevin Marois21-Dec-16 6:02 
Questionerror occurred while enabling mars for this connection Pin
Travelthrprog18-Dec-16 7:56
Travelthrprog18-Dec-16 7:56 
AnswerRe: error occurred while enabling mars for this connection Pin
Eddy Vluggen21-Dec-16 4:52
professionalEddy Vluggen21-Dec-16 4:52 
QuestionTrying to access ReadWrite and ReadOnly variables in Script Component's ProcessInputRow Pin
indian14310-Dec-16 14:35
indian14310-Dec-16 14:35 
QuestionJet OLE, multiple joins with a union, missing an operator or brackets Pin
jkirkerx9-Dec-16 6:16
professionaljkirkerx9-Dec-16 6:16 
AnswerRe: Jet OLE, multiple joins with a union, missing an operator or brackets Pin
Eddy Vluggen9-Dec-16 7:08
professionalEddy Vluggen9-Dec-16 7:08 
GeneralRe: Jet OLE, multiple joins with a union, missing an operator or brackets Pin
jkirkerx13-Dec-16 9:14
professionaljkirkerx13-Dec-16 9:14 
QuestionRun SSIS Package using Microsoft.SqlServer.Dts.Runtime or Sql Server Jobs Pin
indian1436-Dec-16 9:05
indian1436-Dec-16 9:05 
AnswerRe: Run SSIS Package using Microsoft.SqlServer.Dts.Runtime or Sql Server Jobs Pin
ZurdoDev6-Dec-16 10:10
professionalZurdoDev6-Dec-16 10:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.