RE: Evaluating a string arithmatic expression
This is getting really interesting. We should make a competition from it. Who's next? Cheers, Frank
2003-05-28
career
RE: Database Size
Thank you very much to all of you. Yesterday the MDF file was reduced to 4.3 GB after executing DBCCSHRINK NOTRUNCATE and DBCC TRUNCATEONLY in 2 steps.
2003-05-27
RE: ER Diagramming Tool
You can try the Sybase PowerDesigner 7.5 or 8 to do your ER diagram, and it will seperate the phisical Model from the conceptual model as wanted tung Luani
2003-05-23
RE: unicode
You still need some manual works in my suggestion. 1. Backup database and rename it. 2. Generate scripts for all database objects. 3. Replace varchar with nvarchar in the scripts. 4. Create new database as you need. 5. Run above scripts to create objects. 6. DTS/Import data from old database.
2003-05-22
1 reads
RE: Can I modify a column value in a trigger?
quote: Have you looked at instead of triggers? It's possible that tkbr0wn meant to say, 'Have you looked at an Identity column instead of using triggers?' If this is so, you can use this column type to automagically get the next available integer value. If that won't work for you, you could use a SELECT […]
2003-05-21
RE: SQL server does not exist or access denied
Are you using Windows Authentication, SQL authentication or mixed mode?
2003-05-21
RE: Help! m_SizeRec>0 && mSizeRec<=MAXDATAROW
Think that's an MS internal directorys, sounds awfully familiar. Check this out http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20307973=.html John Zacharkan
2003-05-19
RE: DTS to Excel Spreadsheet
Could you explain about the requirement a little bit more?! If you have to import data from the EXCEL file to a table, you can do that. Or if you want to generate the an outfile from the appended data you can that as well.
2003-05-19
1 reads
RE: sending mail
To configure the email you must use a domain user to start both sql services (mssqlserver and sqlserveragent). Then you must log in to your server with that user, and create a mail profile with outlook with a valid email adress of that user. Then with EM, you select that email profile on SQL Server […]
2003-05-15
RE: DTSRUN.EXE Error
looks like it is not finding the dtsrun exe. Try to locate it, if not reinstall the SQL 2000 client
2003-05-14
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