Off Topic Question?

Jun 20, 2003

Does anyone know if there is a way to set a screensaver to auto log off users?

thanks for your time.

Slightly Off-topic Topic

Feb 14, 2006

Hi,I wanted to know how actually a database converter works.I am working on a converter from DBF to MS SQL server 2000using Visual Basic 6.0. I wanted to know that once a legacy databaseis enterd in the program, how does it get normalised.I have aboout 40 tables in DBASE IV format. I want to convert theminto relational database and store them on server. But on conversion,how can the converted data be normalised by itself.Awaiting the replies,Thanks

View 2 Replies View Related

Emergency Topic 3.

Dec 4, 2006

I absolutely agree with you.

I managed to find the error, it was a typo.

Here is the code, if somebody is interested about it. It is oracle, not SQL server, but the idea is the same.

drop view a;
drop view b;
drop view figure5_9;

create view a
as
select d.donorID, dt.donortype, dt.donortargetq1
from donortype dt, donor d
where d.donortype=dt.donortype;

select * from a;

create view b
as
select a.donortype, sum(c.ContributionAmount) as amount
from Contribution c, a
where c.ContributionDate between '01-JAN-06' and '31-MAR-06' and a.donorID=c.donorID
group by a.donortype;

select * from b;

create view figure5_9
as
select b.donortype, a.donortargetq1, b.amount, b.amount/a.donortargetq1 as percentage
from a, b
where a.donortype=b.donortype
group by b.donortype, a.donortargetq1, b.amount;

select * from figure5_9;

Thanks for the help anyway ;-)

View 2 Replies View Related

MySQL To MS SQL(Not This Topic Again!! ;-))

Feb 26, 2008

Hi,

I am trying to extract data from a MySQL DB. I have installed the MySQL Connector (mysql-connector-odbc-3.51.23-win32), then set up an ODBC connector in the Control Panel > ODBC.

Then in BIDS I have setup a new ODBC connection in Connection Managers, and then used the ODBC connection I setup above so at that point everything looks cool.

Now what? Do I setup a Execute SQL Task or how do I get the data out and into a Data Flow Task?

Thanks

View 3 Replies View Related

Off Topic: Paul OOF Until 2nd October

Sep 14, 2006

I'm in China doing TechEds in Shanghai, Guangzhou, Beijing and Hong Kong - returning to the office Monday 2nd October.

There may be significant delays in my replies to any topics on this forum. Just fyi so you don't sit waiting for me to respond.

Thanks

Paul Randal
Lead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

View 4 Replies View Related

Off Topic: Paul OOF Until January

Dec 13, 2006

It's been pretty quiet here recently - hopefully people either aren't experiencing corruptions or they're finding what they need in the previous threads.

Just a quick note to say that I'll be totally offline from tomorrow until January - going diving in Indonesia (http://www.wakatobi.com).

Happy holidays and may your pagers be silent throughout

Cheers

Paul Randal
Principal Lead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
http://blogs.msdn.com/sqlserverstorageengine/default.aspx

View 4 Replies View Related

How To Find My Previous Topic??

Jul 23, 2005

Plz helpHow to find my previous topic??CheersDishan

View 1 Replies View Related

Bit Off Topic: Street Name Database US

Sep 23, 2005

I'm thinking of doing some basic parsing of address. I want to seprateout the house number from the street name from the suffix. I have thesuffix's from the USPS, but I cant find a database of US street names.Anyone come across one or know where I can get one?TIARob/end off topic

View 2 Replies View Related

Off Topic - Calling Procedures From MS Access

Nov 15, 1999

Hi all!

Is there a possibility to call (and receive records) SQL Server (or other databases) procedure from MS Access?

View 1 Replies View Related

My SQL Is Not Working!!! My Hair Is Gone Is The Topic - FK Creation Not Being Called And More

Aug 1, 2006

I have 2 problems:

1) When I run this, etch time I keep getting the error saying that constraint isn't found when I try to drop because my creation of the constraint at the end for some reason isn't creating it or being run

2) The first insert doesn't insert anything, although I get no errors

ALTER PROCEDURE Categories_I

3) I also get this when trying to run just the first 2 insert statements together

Msg 2627, Level 14, State 1, Line 7
Violation of PRIMARY KEY constraint 'Category_PK'. Cannot insert duplicate key in object 'Category'

ALTER     PROCEDURE [domainnamemyaccountname].[Categories_I]

AS
BEGIN

/* delete contents from Category table and reseed
   Cannot use truncate on a table which contains constraints therefore
   use DBCC to reset the seed and DELETE to clear the records
*/

DELETE dbo.Category
DBCC CHECKIDENT ('Category', RESEED, 0)

-- Now, insert the initial 'All' Root Record

ALTER TABLE dbo.Category DROP CONSTRAINT Category_Category_FK1
PRINT 'Dropped FK'
SET IDENTITY_INSERT Category ON

INSERT INTO dbo.Category
(CategoryId, ParentCategoryID, [Name], [Description], DisplayOrder, DisplayInExplorer, Keywords, Active, CreateDate, CreateUserID)
SELECT 1, 1, CategoryName, '', 1, 1, '', 1, GETDATE(), 1 FROM CategoriesStaging WHERE CategoryName = 'All'

PRINT 'Inserted All Record'

INSERT INTO dbo.Category
(CategoryID, ParentCategoryID, [Name], [Description], DisplayOrder, DisplayInExplorer, Keywords, Active, CreateDate, CreateUserID)
SELECT 2, 1, CategoryName, '', 1, 1, '', 1, GETDATE(), 1 FROM CategoriesStaging WHERE CategoryName = 'Store'

PRINT 'Inserted Store Record'

SET IDENTITY_INSERT Category OFF

/* Finally, insert the rest and match on the Parent
   Category Name based on the CategoryStaging table
*/

WHILE (@@ROWCOUNT <> 0)
BEGIN
INSERT INTO dbo.Category
(ParentCategoryID, [Name], [Description], DisplayOrder, DisplayInExplorer, Keywords, Active, CreateDate, CreateUserID, UpdateDate, UpdateUserID)
SELECT c.CategoryID, s.CategoryName, '', 1, 1, '', 1, GETDATE(), 1, GETDATE(), 1
FROM Category c INNER JOIN CategoriesStaging s ON c.[Name] = s.ParentCategoryName
WHERE NOT EXISTS (SELECT 1 FROM Category c WHERE s.[CategoryName] = c.[Name])
END
PRINT 'Inserted Rest of Category Records'

PRINT 're-create FK Call'
      ALTER TABLE dbo.Category
     ADD CONSTRAINT Category_Category_FK1 FOREIGN KEY
     (
          ParentCategoryID
     ) REFERENCES Category (
          CategoryID
     )
PRINT 'create FK2'
END

Other errors:

(1 row(s) affected)
Checking identity information: current identity value '2', current column value '0'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 3728, Level 16, State 1, Line 6
'Category_Category_FK1' is not a constraint.
Msg 3727, Level 16, State 0, Line 6
Could not drop constraint. See previous errors.
ALTER TABLE statement conflicted with COLUMN FOREIGN KEY SAME TABLE constraint 'Category_Category_FK1'. The conflict occurred in database 'Chefs2', table 'Category', column 'CategoryID'.

Schemas & Data:

http://www.webfound.net/category.bmp

http://www.webfound.net/category.sql
http://www.webfound.net/categoriesstaging.sql

http://www.webfound.net/stagingdata.txt

View 1 Replies View Related

Urgent: A Simple Question About The Most Asked Topic - DATE

May 7, 2004

Hi,

The subject say it all :)

I have a field which stores date which the datetime datatype... The problem is that I am also getting time information in this stored field.

I just want to extract the date part in dd-Mmm-yy format (e.g. 07-May-04). I tried convert (char (8), MyDateField, 112) but it gives me date in yyyymmdd format. How do I get the results in dd-Mmm-yy format instead?

Thanks.

View 7 Replies View Related