2005-03-09
blocking
RE: Data Modeling Question
Sounds like you've already gotten some good advice. I would suggest that you might want to make your Broker & Assistant tables date sensitive, i.e., with a StartDate and EndDate. This way you don't loose any data when an Assistant is promoted to a Broker status you just record the EndDate as an Assistant and […]
2005-01-21
RE: Does Sql Server 2000 (Standard Edition - English) not respect regional settings?
Probably the "best" answer is to use one of the two generally accepted independent formats. You can read about it, for example, here:http://www.karaszi.com/sqlserver/info_datetime.asp
2004-12-08
XML Bulk Load & Truncating Data
I have a table with a number of columns type varchar(70), and a few others of specific sizes taking it up to the maximum row size.The data for the varchar(70) columns occasionally exceeds 70 characters, and I want this simply truncated, however I cannot do this in the application that creates the XML Files because this […]
2004-10-11
Disappearing distribution job
I am copying all data from a production database to a development counterpart (both SQL Server 7) weekly by means of snapshot replication, but I am mystified by the repeated disappearance of the distribution job. I use the Enterprise Manager wizard to create the push subscription on Friday, creating a distribution job in the SQL Server […]
2004-09-08
RE: Database recovery
Hi James,what do you mean with the database is corrupted ? What error does it give. Can you access the database ?If the status of the database is loading, check your settings in BackupExec. I know that older versions did leave the database in that status in order to restore Tlog backups. If you don't […]
2004-09-07
RE: Dynamically Build Table Data Type
That looks great, but am I correct in saying that it creates an actual new table. I only need the table inside the sproc and then I'm done with it. I'd like to avoid using a #temptable and make use of a table datatype. looks like that isn't going to happen.
2004-08-12
RE: Tsql Debugger - help please
In VS.Net 2003Right Click on the project in the Sloution Explorer then click properties.Select Configuration properties and then debugging.By Default it is set to false.
2004-07-29
RE: Passing variables
Hi Lane,Please check the length of the datatype you have used in ur stored proc(sp). I assume u have used varchar as ur datatype. If u have not given any length than it will take the first character of the string that u have passed as a parameter to u r sp.by the way please […]
2004-05-21
Error of no mapping between account names and security IDs was done
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-04-15
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