Access Rights in SQL Server 2005
By default users won’t have access to any objects. If the user doesn’t have access to query a table then they will not be able to view the table.

View Answer   |  January 7, 2010  7:16 AM
SQL Server 2005, SQL Server permissions, SQL Server User Accounts, Windows Vista

bcp – clock time meaning
Someone anwered the question Clock Time (ms.) Total is the # of ms taken to execute the bcp…. select (Average)*(Clock Time (ms.) Total )/1000 = rows copied select 15281.25 *239.578 = 3661051

View Answer   |  January 6, 2010  8:00 PM
BCP Utility, SQL 2005, SQL Server 2005

Find a particular text from all tables in DB.
This gets a little involved, but if you break out the parts of this operation it isn’t too hard. > create a table to hold the results: tblnm = RESULTS cols = TBL_OWNR, TBL_NAME, COL_NAME, CNT, LITERAL > what we want to end up with is a list of queries, one qery for each column [...]

View Answer   |  January 6, 2010  5:04 PM
SQL Server, SQL Server database

SQL Dumper library failed to
What is the error message that you are getting? SQL Dumper shouldn’t stop you from logging into the Server.

View Answer   |  January 3, 2010  12:46 AM
SQLDUMPER

Mainframe access to SQL server data
Not sure if it will work from mainframe COBOL, but from WINTEL COBOL (MicroFocus), this works: EXEC SQL SELECT COLUMN_NAME INTO :VARIABLE_NAME FROM TABLE_NAME WHERE COLUMN 1 = :VARIABLE1 AND COLUMN 2 = ‘Hard Coded Value’ END-EXEC. ============================================================ Since Microsoft is the DB vendor, all you need to do is obtain the appropriate ODBC or [...]

View Answer   |  December 24, 2009  9:50 AM
SQL Server

Power builder 7.0 compatible with SQL 2005
It shouldn’t be a problem at all. Just put the SQL 2005 drivers on the machines with the powerbuilder app. If that becomes a problem, just continue to use the SQL 2000 driver. Of course you’ll want to test before hand a SQL 2000 to SQL 2005 is a very big upgrade.

View Answer   |  December 22, 2009  9:43 PM
PowerBuilder, PowerBuilder 7.0, SQL 2005

Will Visual Studio 2003 and SQL Server 2008
Yes you can connect an application written in Visual Studio 2003 to a SQL Server 2008 database without issue. As long as you have the correct driver installed on the machine you can connect just about anything to SQL Server.

View Answer   |  December 22, 2009  9:30 PM
SQL Server 2008, Visual Studio 2003

convert from msaccess to sql2005
You could use the <a href=”http://msdn.microsoft.com/en-us/library/ms187928.aspx”>CONVERT</a> function to format dates (although it could be more efficient to do that on the front-end), and the ‘+’ operator to concatenate strings.

View Answer   |  December 22, 2009  3:34 PM
Microsoft Access, Query Manager, SQL 2005

odbc data source
In ODBC data source System DSN Add new DSN Name = test Desc = test server = lksql Next user login id and password enterer by user check Connect to sql server to obtain default setting enter user name and pw next change the default database to: only has the default db the user is [...]

View Answer   |  December 21, 2009  5:27 PM
ODBC, ODBC Errors, SQL 2000, SQL 2008

Trigger SSRS report when particular table is updated in the database
Yes a data driven subscription is what you want to use.

View Answer   |  December 18, 2009  10:41 PM
SQL Server Reporting Services, SSRS, SSRS reports

SQL server production virtualization – to do or not to do
Typically large high transaction SQL Servers are not typically good candidates for virtualization. First when you virtualize a server you can’t assign as more cores to the VM as you currently have. The most cores you can assign are the number of cores on a single physical CPU. So if your VMware server has 4 [...]

View Answer   |  December 16, 2009  3:24 AM
Database, Database administration, Enterprise Virtualization, SQL Server Virtualization

32 and 64 Bit SQL 2005 on Same Server
Yes you can do this. No SQL 2008 wouldn’t fix this problem. The problem isn’t a problem with SQL Server, but a lack of 64bit Jet drivers. The Jet driver is the ODBC driver which you use to talk to the Access database. The Jet driver is only available in a 32bit driver at this [...]

View Answer   |  December 15, 2009  8:15 PM
MS Access, SQL Server, SQL Server 2005

Using Right() inside SQL Join
What hardware and software are you using? ———– Yes, you can do that on MySql. Remember that aplying functions to fields in the where clause, prevents the database system from using indexes. -CarlosDL

View Answer   |  December 15, 2009  5:06 PM
MySQL functions, RIGHT JOIN, SQL join

numeric test in SQL
Hi Sherry. Welcome back to ITKE. ISNUMERIC is a T-SQL function, and Oracle doesn’t have an equivalent. However, you can easily build your own. Something like this: <pre>CREATE OR REPLACE FUNCTION isnumeric(p_value IN VARCHAR) RETURN NUMBER IS l_value NUMBER; BEGIN l_value := p_value; RETURN 1; EXCEPTION WHEN value_error THEN RETURN 0; END; / </pre> After [...]

View Answer   |  December 14, 2009  7:42 PM
SQL error messages, SQL Testing, WINSQL Numeric Function

how to save file doc, xls, into database sql server 2000 in VB6
You’ll want to open up a binary stream and read that binary stream into a variable. Then take that variable and write the value into the table or stored procedure.

View Answer   |  December 14, 2009  8:04 AM
Microsoft Office, SQL Server 2000, VB6, Visual Basic

Stored Procedures on AS/400
It depends on how you measure efficiency. For example the generated C code is not as fast as well crafted code. However the user response time difference is likely to be trivial. For developer efficiency, I can build, test and deploy 3 SQL stored procedures in a half hour while an RPG developer takes 2 [...]

View Answer   |  December 14, 2009  1:52 AM
Application development, AS/400, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, RPG, RPGLE, SQL, SQL Server, Web development, Web development tools, WebSphere Studio

The most-watched IT questions this week: Dec. 1, 2009
Oh what a disappointment, there must be a lot more people curious about Foxpro than the AS/400. Phil What I feel is that if we start time limit in which a question can be answered, then we will have vastly reduced the effectiveness of this site.

View Answer   |  December 11, 2009  4:42 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

composite WHERE condition in SQL Server
Yes, you can. <pre>SELECT * FROM yourTable WHERE field1+field2 IN (’01XX’,’02YY’,’03ZZ’);</pre>

View Answer   |  December 10, 2009  3:39 PM
SQL Server development, SQL Server tables, WHERE condition

SQL question
You’ll want something like this. <pre>select * from Employee join (select Department, avg(Salary) Salary FROM Employee group by Department) a on Employee.Department = a.Department and Employee.Salary > a.Salary</pre>

View Answer   |  December 10, 2009  9:37 AM
SQL, SQL tables

SQL DTS package scheduling
A job would be used to run a DTS package by calling dtexec.

View Answer   |  December 8, 2009  6:09 AM
DTS package, SQL Jobs, SQL stored procedures