RE: Roles as table owners
Hey,Didn't know that, cool! It's nice to have all tables linked to "db_owner", because the user "dbo" is linked to one login only. When sysadmin changes...
2004-02-13
PowerShell
RE: Import NTEXT fields to SQL from Remedy ODBC 4.5 using DTS
I have never seen this problem. Here are a couple thoughts.Try changing the SQL field from ntext to text. ntext is for Unicode data and text is for ANSI data.Another thought (again speculation): your source text may be Unicode and your Remedy ODBC 4.5 driver may not understand Unicode. Unicode puts a null before the […]
2004-02-12
1 reads
RE: MSDE Questions
It can be downloaded from Microsoft in various languages.go to http://www.microsoft.com/sql/ and follow the links to the downloads pages. It contains installation instructions as well for various languages.
2004-02-12
1 reads
RE: Question of the Day for 11 Feb 2004
I believe the "NOT" is the operable word that threw most of us. From the question, you can infer that only "All of the above" or "None of the above" would be accurate. Since the All answer would include the None answer, it cannot be the correct answer -- therefore I chose None.By having the […]
2004-02-11
1 reads
RE: Sysproperties table
Excellent! That certainly helps. Does anyone know what all the possible values sotred in the Type field are. So far I've seen the following values:3 - Diagram information4 - Table column description I hope I don't have to try and get a complete list through trial-and-error!Ben
2004-02-11
1 reads
Linked Server Delegation Setup
Does anyone in the forum has any experience with setting up delegation through impersonation for managing linked server security? In essence, we would like to use the windows domain accounts we use to connect to the SQL Server A to be used when we connect to a linked server B. This way each user will […]
2004-02-10
9 reads
RE: Rewrite Query with Nested Queries and Cross Join
Hmmm... Why do you say it is using too much tempdb? With all those subqueries I'm not surprised! As Ken stated it would be nearly impossible to do the analysis of this without knowing the data.Having said that. If you are doing this in a stored procedure I would certainly move some of it to […]
2004-02-09
Importing paradox memo field
In trying to import a paradox memo field to an SQL server table, I am getting the error "Data source for column is too large for the specified buffer size".I have imported this field many times before with no problem at all. Just wondering if anyone can tell me if there is a problem with […]
2004-02-09
11 reads
RE: AccessADP Design
Michael,Thanks so much for your patience. I also work for a government agency. I knew about the file scripting object. I just didn't know how to set the property of the ADP project so I could retrieve it using GetFileVersion.Would this be done from Windows Explorer or as a database property done inside of the […]
2004-02-06
RE: Very Large Transaction Logs
"Is there anything we can do on this end, from a front end application design, that will minimize the log size or is that something we will just have to live with and manage with the backing up and truncating of the log on SQL?" Something that you may want to consider adding to either […]
2004-02-06
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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