RE: Table Datatype with primary key
Oops, forget it. Reread it that you want it on both columns. Sorry.
2004-11-12
String
RE: Two fields into one
I am Sorry....... The table has two fields; Last Name, First Name.In the view I want Last name and first name into one field.Thanks
2004-09-03
RE: Problematic error messages - Diskkeeper and SQL Server
Can you reboot? I've seent he cursor message, but can't remember what it was. It was awhile ago and I think it cleared itself. As far as diskkeeper, do you exclude the SQL Files? I do and don't have any issues.
2004-05-11
RE: MSDE installation rolls back
Check that the server service is running, I had an installation that was continually rolling back, but it completed as soon as I started the server service
2004-03-31
RE: One-Many Relationship Help
You will need another column (I called it 'rid' ) in the residents table that will be incremented from 1 by one for each household. Each time a new household is entered, rid will begin with the value 1 and be incremented for each resident in the household that is added to the residents table.I […]
2004-03-05
RE: New publication does not initialize
If this is a dumb question, disregard it.Have you tried right clicking the Snapshot Agent and running it explicitly?I have found that even though you select "Run Snapshot Agent Immediately" in the Wizard, it often times out before connecting to the SQL Server Agent.Regards,Morpheus
2004-03-05
2004-02-12
RE: stored procedure creation error: already an object named xxx in the database
Ok. Paste your script into QA, Run it, get error, click the error and it will tell you which statement is wrong. Post that statement here.
2004-01-08
1 reads
2003-12-05
1 reads
RE: Dropping a PrimaryKey takes forever..
aha! Yes the PK is clustered..and on investigation I don't think it's a good candidate for it. I'll consider the non clustered approach for this key. Also, it was the first of all the index drops, so I've changed my code to drop all others first then lastly, the PK. Thanks for the advice.. I'll […]
2003-07-24
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers