Apparently the query analyser of sql server does not recognise a database with a point in it, like mail.archive.mdf I receive the following error...

Prem

06-21-2006 04:54 PM
Erland Sommarskog

Dear all, Tables: COMPANY: COM_ID, COM_NAME, ..... PROPERTY: PRP_ID, PRP_NAME, PRP_DATATYPE_ID, PRP_DEFAULT_VALUE ( nvarchar) COMPANY_PROPERTY:...

Filips Benoit

06-21-2006 04:33 PM
Erland Sommarskog

Previously in Sql Server 2000, we would be in enterprise manager, you'd double click on a view, and a nice little dialog box opened with the...

CK

06-21-2006 02:34 PM
CK

Thanks Chris. You pointed me in the right direction. For reference this is how it worked (in VB6): Dim oSQLServer As New SQLDMO.SQLServer Set...

Alex

06-21-2006 10:55 AM
Alex

I have about 20 Ms Access Databases to need to be upload onto a SQL Server 2005. Currently the are on a network/server residing on a specific drive....

Anns via SQLMonster.com

06-21-2006 10:48 AM
Anns via SQLMonster.com

using the tools in Enterprise Manager (SQL) how do I pull the several ms access db (tbls) over to SQL BE? Does the import/export feature do...

Anns via SQLMonster.com

06-21-2006 09:30 AM
AT

Hi All, Does any body know how to use encryption in sql server 2005.Is it possible to encrypt a particular column in a table. thanks

shark

06-21-2006 08:28 AM
pb648174

I want to make more room available on my c: disk and discovered a FTDATA directory in sql that is full of (uncompressed) files, like pdf's and...

Prem

06-21-2006 08:06 AM
Prem

Hello, Since SQL Server has no sequence generator, I wrote my own. (I claim no ownership of it as it is closely modeled after earlier...

AT

06-21-2006 04:07 AM
Madhivanan

Relationships between tables disappear without explanation in the database diagram using SQL Server 2005. Many thanks for any thoughts/questions on...

AT

06-20-2006 05:30 PM
Erland Sommarskog

In the login properties on the Database Access tab, a user's name says dbo instead of his name. I do not want him to have dbo permissions. I cannot...

MK

06-20-2006 04:58 PM
Erland Sommarskog

How popular is this current set up? Web FE & SQL BE? Is it possible for a person to build a web site using (publisher, front page, etc) and once...

Anns via SQLMonster.com

06-20-2006 02:47 PM
Anns via SQLMonster.com

When issuing the below command on any of our databases, it just hangs forever. ALTER DATABASE DBName SET READ_COMMITTED_SNAPSHOT ON; I realize that...

pb648174

06-20-2006 07:21 AM
Cimode

Hi guys. I have a huge database file. When I run sp_spaceused this are the results: db_size 1337,31 Mb unallocated ...

Zvonko

06-20-2006 07:12 AM
Cimode

Hi We are planning to move over to SQL Server 2005 in near future. At the moment Website is on a seperate server then the Database. OS for both the...

AT

06-20-2006 06:54 AM
MVChauhan (AT) googlemail (DOT) com

Hi, I'm using Sybase driver under Linux and I'm trying to connect to MSSQL server 2000. But unfortunately connection fails. In Event Log on my Win...

Martin Lukasik

06-20-2006 05:53 AM
Mark T. Kennedy

Hello folks, Old programmer learning new tricks. I think similar issues have been posted, but I would like to ask some help with the following...

Sfj

06-20-2006 12:14 AM
AT

I have been tasked with copying data from our SQL Server to a local MySQL (windows). About 75 tables are involved. The data arrive in SQL Server...

Mike Husler

06-19-2006 02:09 PM
Mike Husler

Hi Folks, SQL Server 2000 SP3 on Windows 2000. I have a database on which I ran the command : dbcc dbreindex ('tablename') go for all tables in...

Raziq Shekha

06-19-2006 01:58 PM
GlennThomas5

hi, we were doing something and began to wonder which jobs/dts were affecting a certain table (we use SQL 2000)... is there anyway to...

metaperl

06-19-2006 07:26 AM
Stu

Hi, this is just to verify: I checked the documentation and it seems that SQL 2005 does not support hash partitioning on a number of columns. ...

Robert Klemme

06-19-2006 03:09 AM
Robert Klemme

Hi All, Quick question, I have always heard it best practice to check for exist, if so, drop, then create the proc. I just wanted to know why that's...

CK

06-18-2006 03:21 PM
AT

IPB WARNING mysql_connect() : Too many connections (Line: 131 of /ips_kernel/class_db_mysql.php) There appears to be an error with the...

AT

06-17-2006 01:53 PM
Erland Sommarskog

Hi All I am finding unexpected results when inserted into a newly created table that has a field of datatype int identity (1,1). Basically the...

AT

06-16-2006 05:40 PM
Mike C#

My MS-SQL 2000 Database have 50 more Stored Procedure . How to FAST and EASY ENCRYPTION ALL Stored Procedure in my MS-SQL Database?

AT

06-16-2006 04:48 PM
Erland Sommarskog

I am writing some code generation stuff and I am trying to get a script like this to work: IF (something) BEGIN CREATE PROCEDURE Whatever AS SELECT...

cmay

06-16-2006 04:21 PM
Erland Sommarskog

I am trying to generate some datasets with some queries... With a given series information, it should return PART_NOs that has STD = 1 and a unique...

AT

06-16-2006 10:28 AM
AT

Hi Dear Members, FOLLOWING R THE NEW JOBS OF THE DAY : Sales Manager Programmer(asp,.NET,C,JAVA) Faculty for Computer Application, DTP and WEB

AT

06-16-2006 03:46 AM
AT

how to convert number to string in sqlserver eg:- 10 -> ten display *** Sent via Developersdex http://www.developersdex.com ***

oviam packirisamy

06-15-2006 05:02 PM
Erland Sommarskog

This has got to be easier than I am making it out to be. I have a query that calls on two tables linked by unique ids. I would like to have the...

AT

06-15-2006 05:01 PM
Erland Sommarskog

Itemlookup table Field names : index_id (primary key), itemno, description. It has a child table, which is ItemPriceHistory table The relationship to...

TGEAR

06-15-2006 04:41 PM
Hugo Kornelis

Marc Filthaut (usenet_delete_for_reply (AT) filthaut (DOT) com) writes: I don't believe that. Add a len(nvarcharfield) to you query and you will...

Erland Sommarskog

06-15-2006 04:40 PM
Erland Sommarskog

I have an ItemSTDPriceHistory table as below and this is a child table of itemlookup table with one to many relationship. if exists (select * from...

TGEAR

06-15-2006 04:31 PM
Erland Sommarskog

Hello All, i was wondering what is the main difference between the windows authentication and mixed mode authentication?? according to security...

AT

06-15-2006 04:20 PM
Hugo Kornelis

Is there a way to set what global variables are displayed in the globals window by default? I would like to see @@rowcount in there but I have to...

Trevor Best

06-15-2006 04:43 AM
Trevor Best

We are running attendance system on SQL Server 2000. In order to reduce traffic on WAN, we are going towards replication. In order to...

perhiyar

06-15-2006 12:01 AM
perhiyar

I have a bit of a problem with regards an indexing strategy. Well, basically there is no indexing strategy on a set of data I have at work. Now, I...

Ryan

06-14-2006 05:35 PM
Mike C#

Hello, On the database we have stored procedure that loads couple thousands rows with information, it has to be done sequentially because...

Cray

06-14-2006 04:51 PM
Erland Sommarskog

I have an ItemSTDPriceHistory table as below and this is a child table of itemlookup table with one to many relationship. if exists (select * from...

TGEAR

06-14-2006 03:14 PM
TGEAR

I have a column which stores dates (datetime data type). I would like to fetch one data which is the most latest date among them. So if there are...

TGEAR

06-14-2006 02:58 PM
rudianus

I look after a database which is part of a third party CRM product. The users of the product complain of intermittant poor performance,...

Laurence Breeze

06-14-2006 06:12 AM
Laurence Breeze

I would like to create a stored procedure which creates a temp table to store some XML. The # of fields of XML is dependent upon the contents of...

pinney.colton (AT) gmail (DOT) com

06-14-2006 05:42 AM
Erland Sommarskog

Dear friends, If i want to specify the column name as "acc_no" then it total size is 6 it must get the first two letters as alphapets and...

gobiparthi

06-14-2006 05:03 AM
Madhivanan

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular database development tool: Database Workbench 2.8.7 has...

Martijn Tonies

06-14-2006 03:03 AM
Martijn Tonies

How to schedule backup of transaction log???

AT

06-13-2006 07:42 PM
DickChristoph

I am trying to run "select * from <table> where <columnname> = 0.0" in query analyzer <columnname> is a float I get the following error: Server:...

AT

06-13-2006 05:06 PM
Erland Sommarskog

In deploying SQL Express, how do I create a new server (INSTANCENAME) programmatically? What would be the best approach to accomplish this. Thank...

AT

06-13-2006 04:58 PM
Erland Sommarskog

Hi, We have enterprise manager for sql server 2000. I would like to store comments about my database schema somewhere in the database. I want...

metaperl

06-13-2006 04:55 PM
Erland Sommarskog

Hello, Could you explain me please the following error: "Database 'DemoDotNET' cannot be opened due to inaccessible files or insufficient memory or...

R.A.M.

06-13-2006 04:46 PM
Erland Sommarskog

There is itemlookup table, which stores item number and item description. Also there is a child table, pricehistory, of the itemlookup table, which...

HandersonVA

06-13-2006 03:09 PM
David Portas