Using MS SQL Server

Security issues in SQL Server 2005
I cannot block user access to tables. I have restriced accounts at the server, database, group, schema, and table lavel and can still open tables right up. In other words, I have absolutely no security. Any ideas? ... 14 Dec 2006 18:03

Converting a varchar to int
I am struggling with converting a certain varchar column into an int. I have a table that has 2 fields - one field holds the loan number and the other field holds the codes associated with that loan number. Here's some example data: Loan# Codes 11111 24-13-1 22222 ... 12 Dec 2006 23:48

Laws and Myths of Usability & Interface Design
Introduction Usability and relevance have been identified as the major factors preventing mass adoption of Business Intelligence applications. What we have today are traditional BI tools that don't work nearly as well as they should, even for analysts and power users. The reason they haven't reached the masses... 12 Dec 2006 06:43

SQL 2000 Full Text Catalog problem.
We have a SQL Server 2000 server where we can't get into the "Full-Text Catalogs" section of Enterprise Manager for any database. It just freezes Enterprise Manager every time we try. After rebooting the DB server just to see if that would clear it up, we were able to get in again, but most of the catalogs (4 out... 6 Dec 2006 12:44

Import multiple .DBF files w/SSIS - OLE DB
Hi all, New to SQL Server - trying to create an SSIS package that will look for and import a series of Visual Foxpro tables (.DBFs) when they appear in a folder. The tables are/can be all different fields, field widths, etc. With quite a bit of overlap though. The end result should be table "ABC.DBF" is pul... 7 Dec 2006 10:05

...Contains more than the maximum number of prefixes. The maximum is 3.
Thanks for wasting even more of everyone's time by not indicating your mistake and having this useless thread replicated to dozens of other forums! From http://www.developmentnow.com/g/95_2005_10_0_0_614674/--Contains-more-than-the-maximum-number-of-prefixes-The-maximum-is-3-.htm Posted via DevelopmentNow.com G... 29 Nov 2006 14:34

Learn MS SQL with interactive tutorials at www.tutorialsdirect.com
Learn MS SQL with interactive tutorials at www.tutorialsdirect.com ... 27 Nov 2006 15:51

float vs decimal
select convert(float,'1.2334e+006') 1233400.0 select convert(decimal(20,2),'1.2334e+006') Server: Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to numeric. Is there any way around? Is there any set options? I tried arithabort or arithignore and they don't work. Thanks. ... 22 Nov 2006 10:09

Export SQL05 data to Access
I'm trying to help a client export some data from SQL 2005 to an Access database or even an Excel file. Either way I get an error like this: - Setting Destination Connection (Error) Messages Error 0xc0204016: DTS.Pipeline: The "output column "press_release_body" (1500)" has a length that is not valid. The length... 21 Nov 2006 12:12

SQL 2005 -- export table to a "fixed width" flat file -- Posting again
I am sorry, I am posting this message again, since I did not get any reply. I want to export a table into a "fixed width" file using SQL 2005 import export wizard. This is the version I have: SQL Server 2005 - 9.00.2047.00 For some reason it joins all the rows together. For EX: if the table is like ... 2 Nov 2006 13:56