Viewing 15 posts - 46 through 60 (of 284 total)
This sounds more like an install problem to me. Can you delete and reinstall EM on your workstation and clear it up? DOes everyone get the error, regardless...
December 10, 2002 at 9:58 am
Sounds like you're looking for a ROWID() type function. There was a post a couple of days ago that did this by populating the column with a subselect. ...
December 10, 2002 at 9:54 am
INFO: When to Choose MSDE 2000 as the Database Engine for Your Application
Http://support.microsoft.com/default.aspx?scid=kb;en-us;321518
Got this today in the daily MS Propaganda note. A good overview of the different SQL engines...
December 10, 2002 at 9:22 am
What we really need for this is an ANSI-compliant way to generating sequentially increaseing numbers. Anyone here on the appropriate committee? Or know who/where to submit suggestions?
December 10, 2002 at 8:34 am
We created tables and views to solve this problem.
create table Phrase
(PhraseID int (PK)
PhraseName varchar(50)
)
create table LocalizedPhrase
(PhraseID int (pk, FK)
LanguageID int (pk)
Phrase varchar(3000)
)
We have a view that joins the...
December 10, 2002 at 8:16 am
quote:
Remember a byte by definition is not 8-bit but the space required to store 1 character.
December 10, 2002 at 8:13 am
Every instance is another executable task on the server. I'd probably go for one task and multiple data bases. Of course, I'd really just like to have the...
December 9, 2002 at 9:08 pm
quote:
The nature of business (address deduplication/matching)
you don't happen to work for a credit agency...
December 9, 2002 at 8:41 pm
quote:
In summary, everyone has to make their own decission about whether or not to use FKs and your experience should have some...
December 9, 2002 at 6:22 pm
Are you asking or playing "I've got a secret?"
We use the SQL Server client utility and set up an alias to the named instances. Then we can use that.
...
December 9, 2002 at 6:19 pm
Service packs apply to the full release of SQL Server. I'm not sure if MSDE has patches that are applied and/or created for it. It's a "test" bit...
December 9, 2002 at 3:08 pm
Anyone can create a package. Only the owner or system admin can execute it.
December 9, 2002 at 3:07 pm
Here's the BOL info:
The important point here is the local system account doesn't allow you to access any network resources.
Services Accounts
Use the Services Accounts screen in Setup to...
December 9, 2002 at 2:37 pm
I think you want to use OPENROWSET only when you CAN'T make your server a linked server for some reason. You can use 4-part names to access a linked...
December 9, 2002 at 2:25 pm
quote:
I will. I thought \t was the default statement for tab delimited though?
My bad. ...
December 9, 2002 at 11:35 am
Viewing 15 posts - 46 through 60 (of 284 total)