Community Announcement: Cash in your Knowledge Points for an Amazon gift card
Ok for redeem my points now

View Answer   |  November 16, 2009  8:01 AM
AS/400, CIO, CRM, DataCenter, Development, Exchange, Giveaways, ITKE, Knowledge Points, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Security, SQL Server, Storage, Virtualization, VoIP

“map drive” IFS
So if I understand correctly… - You have created “shares” using iSeries Navigator? (i.e. a share named “root” for the / directory, a share named “test” for /home/jdoe/test, and so on) - And using “net use X: QS6555A8Aroot” or “net use Z: QS6555A8Atest” in a DOS box on a client PC doesn’t work? Very strange [...]

View Answer   |  November 14, 2009  12:44 PM
390, Access, AS/400, Backup & recovery, Data analysis, Database, DB2, DB2 Universal Database, Desktops, Development, Hardware, IBM, Mainframe, Management, Microsoft Office, Microsoft Windows, OS, RPG, Security, Servers, SQL Server, Storage, Tech support

Join our ITKnowledgeExchange.com LinkedIn group
<b> manual to use file server software </b>

View Answer   |  November 13, 2009  6:33 PM
AS/400, CIO, Database, DataCenter, Development, Exchange 2003, Linux, Lotus Domino, Mobile, Oracle, Security, SQL Server, Storage, Virtualization, VoIP, Windows

SA Password change for SQL
Password changes are done via the sp_password system stored procedure. <pre>exec sp_password ‘sa’, ‘YourNewPassword’</pre>

View Answer   |  November 13, 2009  12:35 AM
SA password, SQL 2005, SQL 2005 admin, SQL 2005 SP3

Passing data between two SQL Server databases
I’ve had to do stuff like this in the past. In my case it was a loan processing system, so the master number to work off of was the Account Id. So I created a table, and loaded up 10% of the Account Ids into the table. Then used the records in the table to [...]

View Answer   |  November 13, 2009  12:32 AM
Linked Server, Passing Data, SQL, SSIS, Stored Procedures

SQL Server 2005 on Windows 2008 64 bit SP2. Installation issue
Hello I am having the same issue! Has anyone come up with an answer yet? I’m quite frustrated by this and am also only finding discussions of the Web edition on-line. What’s the deal?

View Answer   |  November 13, 2009  12:14 AM
SQL Server 2005, SQL Server 2005 (64-bit), SQL Server installation, Windows Server 2008

pl/slq procedures – POSITIVE and POSITIVEN as IN OUT parameters
The POSITIVEN type is allowed for IN paramaters only, as the initial value of an OUT parameter is NULL by definition. You should use POSITIVE for the out paramter instead.

View Answer   |  November 12, 2009  9:06 PM
Data Types, Oracle, PL/SQL

Can we get sql server authenticated logins and passwords?
sp_help_revlogin can be used to export the logins and the encrypted passwords. Go can google for it and get the code from Microsoft’s site.

View Answer   |  November 12, 2009  6:45 AM
SQL Server authentication, SQL Server User Accounts

VB.NET code to search if a record already exists or not
If you are getting errors with the code you posted, please provide the exact error messages or tell us what the problem with that code is. If this code is working but you want to add the necessary logic to check if the record already exists before inserting it, you could put the insert into [...]

View Answer   |  April 19, 2013  2:28 PM
Database programming, Search string, SQL Database, VB .NET, VB.NET 2005, Visual Basic .NET, Visual Basic 2005

SQl Server Replication Internals
The basic process is that the row is inserted into the table. When this happens the transaction is logged into the transaction log. The log reader reads the log and gets the information from the transaction log and writes it to the distribution database. From there the distribution agent (or merge agent if you are [...]

View Answer   |  November 10, 2009  6:24 AM
SQL Server administration, SQL Server replication

Why is my logical disk usage enormous?
Usually this is caused by a lack of indexes in the database.

View Answer   |  November 10, 2009  6:20 AM
logical disk, performance tuning, SQL Server 2005

SQL select for month date range
Carlosdl 29360 pts. | Nov 9 2009 11:08PM GMT I’m wondering how is that running without errors. AFAIK, the DATEPART function retunrs an integer, so, here: <pre>[service date 1] between [new patient date] and datepart(m,[new patient date])+1</pre> You are mixing two different data types. I think you should try something like this: <pre>[service date 1] [...]

View Answer   |  November 10, 2009  12:24 AM
SQL, SQL Server

Refresh Reporting Services to view newly added sproc fields
You need to edit the report defination, then run the stored procedure. Then click the refesh button in the tool bar at the top. You can then edit the parameters and you should see the new parameters.

View Answer   |  November 8, 2009  9:40 AM
SQL Server Reporting Services, SSRS, SSRS 2008, SSRS reports

Setting up dbmail in SQL Server 2005 on Server 2003
When using dbmail you can use a Windows account or a local account. Dbmail uses SMTP to send email, it doesn’t use the account that SQL Server is running under. The receive connector can be left with the default settings. When you configure the dbmail settings you can give it a Windows account and password [...]

View Answer   |  November 8, 2009  9:29 AM
Database Mail, DB Connector, SQL Server 2005

Receiving undeliverable email we did not send
Spammers use your eMail return address to keep themselves from getting blocked. There is nothing you can do about this, unless someone figures out a way to handle the problem network-wide. Bob here – This is also a technique used to spread viruses and spam in general. The fact that your email address gets used [...]

View Answer   |  April 19, 2013  6:06 PM
Desktops, Exchange, Exchange security, Management, Microsoft Windows, OS, Security, Servers, Spam, SQL Server, TrendMicro

Stored procedure content
Depending on how the *SRVPGM was created, you may be able to get what you want with DEBUG. YOu can do a DSPSRVPGM on the main SRVPGM that has the modules. Then do a STRDBG on a program that calls one of the modules putting a break point at the point of the callp. Call [...]

View Answer   |  November 5, 2009  9:56 PM
AS/400 stored procedures, Stored Procedures

How to export/ import userschema in SQL server 2005?
Right click on the database, select all tasks, then Generate SQL Script. This will allow you to select all the objects and put everythng into a single script.

View Answer   |  November 4, 2009  10:35 PM
SQL Server 2005, SQL Server backup, SQL Server snapshot backup

Effective ways for retrieving millions of records from a table?
Are you just trying to export the data to a CSV file or something? If so then BCP, DTS, or SSIS will be your best bet.

View Answer   |  November 4, 2009  10:29 PM
Data Tables, Microsoft SQL Server, SQL tables

SQL Table Join when the name of a column in Table1 equals the value of a column in Table2
I had the same question and could not easily find any answers. Here is what I came up with. The sysobjects table stores each table name with a type = ‘u’ The syscolumns table stores the column name for each table. Each of these tables shares an ID column, which you can use to join [...]

View Answer   |  November 3, 2009  12:20 AM
Conditional JOIN, Conditional SQL statements, Conditional statements, DB2 SQL, JOIN statement, SQL

Date Time SQL Selection Criteria
Something like this should do the trick: <pre>SELECT * FROM tblTest WHERE DATEADD(ss,CAST(LEFT(time,10) AS INT),’01/01/1970′) BETWEEN ‘<some time>’ AND ‘<some time>’;</pre> —————– kccrosser While CarlosDL’s query will work, it will result in a full table scan on every call. A more efficient approach is to compute the time field’s min/max values and then run the [...]

View Answer   |  November 2, 2009  8:48 PM
Date Time, Selection Criteria, SQL Server, T/SQL