sql server express 2005 cannot see drive on my server (drive q)
Correct, it will not. This is by design. Network shares and mapped drives are not supported for putting your databases on.

View Answer   |  December 8, 2009  6:06 AM
SQL Server 2005, SQL Server Express, SQL Server Express 2005

What are the security risks of using hosted SQL
When you host your database server on the public internet and have no rules preventing the public internet from accessing it are the same no matter what platform you use. There is the risk of a brute force attack against the database using the administrator account. These admin accounts always have the same username (root [...]

View Answer   |  December 8, 2009  6:03 AM
Hosted servers, Hosted services, SQL Server, SQL Server Hosted Servers, SQL Server security

Implementing Encrypted SQL Server Database Columns
I posted some sample code on this <a href=”http://www.tek-tips.com/faqs.cfm?fid=5964″>FAQ</a> which shows how to use encryption in SQL 2005.

View Answer   |  December 6, 2009  10:53 PM
.NET 2.0, SQL Server 2005, SQL Server database, SQL Server encryption, VB6

SQL Server 2005 Performance optimiztion
How big are your databases? First SSRS won’t ever fly. Generating the reports takes a lot of time, especially with a lot of data. Do you only have a single dual core CPU? If so 1-2 files per filegroup is fine. Same for tempdb.

View Answer   |  December 3, 2009  10:14 PM
SQL 2005 Reporting Services, SQL Server 2005, SQL Server performance, Windows Server 2003

SQl Server 2008 Plain Text procedures results iin Encrypted Text within Profiler
I can see that. The flag saying that the code was encrypted would be set for the transaction so everything would probably report that flag. The easiest way around this would be to decrypt the procedure. There’s plenty of software on the net to do this.

View Answer   |  December 3, 2009  10:12 PM
SQL Encrypted Text, SQL Server 2008, SQL Server 2008 64-bit, SQL Trigger

How to restore Sql Server 2000 mdf and ldf data
This<a href=”http://itknowledgeexchange.techtarget.com/itanswers/attaching-mdf-and-ldf-files-to-sql-server-2005/”> previous answer</a> may help you

View Answer   |  December 3, 2009  3:31 PM
.MDF files, LDF, MDF, SQL Restore, SQL Server 2000

Color coding of Toad for Oracle-
in Toad (I’m using 9.6.11) Go to View -> Toad Options. Click Editor -> Behavior. There is a button called Syntax Highlighting. On the Highlighting Tab (opens by default) is a list of styles, clicking on the style will show the options selected for that style… For example in my setup (which is my install [...]

View Answer   |  December 2, 2009  2:40 PM
Oracle, SQL Editor, TOAD

SQL Server 2005 Log Shipping question
It will survive short gaps. The length of time it will survive is controlled by the amount of time the system keeps the transaction logs on the primary servers hard drive. Once they are deleted from there they are gone. You’ll need to do a full backup and restore it to the backup machine then [...]

View Answer   |  November 30, 2009  11:04 PM
Log Shipping, SQL Server 2000 Log Shipping, SQL Server 2005, SQL Server log shipping

Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime
By definition, procedures don’t return values. If you want to return the result of your query, you would need to use an output parameter. On the other hand, <a href=”http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executenonquery.aspx”>ExecuteNonQuery</a> returns the number of affected rows (for inserts, updates and deletes) or -1, and that’s why you are getting the casting error. In this case, [...]

View Answer   |  November 26, 2009  11:06 PM
SQL Server 2005, SQL Server 2005 Express, SQL Server stored procedures

How do I confirm all the data moved from Source to target for different tables
With SQL. use the Select COUNT(*) option for each of the tables in both the source and target system. That will tell you if your record count is correct. * If you want to get to the record level, you can do a EXCEPTION JOIN —————– kccrosser I commonly check two tables using either EXCEPT [...]

View Answer   |  November 25, 2009  11:26 PM
Data migration, SQL, SQL migration

SQLRPGLE Cursors and Recursion
I think that this is one of those cases where native I/O works better than SQL. Here is a subprocedure I wrote a while back for a BOM project. You should be able to modify it to work for you. <pre> ‚********************************************************************** ‚* SET COMPILER OPTIONS ‚********************************************************************** HNOMAIN HOPTION(*NODEBUGIO:*SRCSTMT) ‚********************************************************************** ‚* PROGRAM NAME: GETSTDCOMR ‚* [...]

View Answer   |  November 25, 2009  8:33 PM
iSeries, Recursion, SQL Cursors, SQLRPGLE

The IT Blog Top 10: Oct. 29, 2009
The most effective and informative <a href=”http://www.fifiland.pl/”>przedszkole Szczscin</a> for finland. Here you can find the impressive information which is helpful for you to select your desire goal.

View Answer   |  November 25, 2009  1:06 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, IT Blogs, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

The most-watched IT questions this week: Nov. 24, 2009
Is this a question? Is it relevant to post it here in Home > IT Answers > AS/400 > The most-watched IT questions this week: Nov…. just wondering!

View Answer   |  November 25, 2009  5:03 AM
AS/400, Channel, CIO, CRM, databse, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

hardware requirement for sql 2005.
Get a couple of dual core or quad core CPUs and as much RAM as you can afford. I would get no less than 4-8 Gigs.

View Answer   |  November 24, 2009  11:28 PM
SQL Server 2005, SQL Server databases, Windows Server 2003

Rename Sheet when report exported to excel
Hi Rachitha It is not possible to do this with SSRS out of the box. http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/4876ffe0-f0c0-413e-9890-0c85615b3edf/ But there is an work around by creating XSLT and attaching it to SSRS. Refer below link. http://spacefold.com/lisa/post/2007/10/03/Changing-the-Sheet-names-in-SQL-Server-RS-Excel-QnD-XSLT.aspx

View Answer   |  November 23, 2009  11:22 AM
Exporting SSRS to Excel, SSRS, SSRS reports

sql help
The way you cited, update table/detail set condition = ‘r’ where condition = ‘ ‘ and number_d = (select number_h from table/header where date between 050101 and 051231) is one way to do it. Here’s a more efficient way, especially if number_h is indexed: UPDATE table/detail d SET condition = ‘r’ WHERE condition=’ ‘ AND [...]

View Answer   |  November 22, 2009  11:22 AM
AS/400, SQL, SQL Server

What is correct syntax for SQL for Maxrecords in OS400/DB2?
I don’t believe that MAXRECORDS is part of the “SQL Standard”. I know a few databases (big ones included) have implemented it, but it’s not a part of DB2. I believe it can be set as a property on OLE and ADO DB providers. sorry =================================================== Your automatic generator doesn’t generate standard SQL. It generates [...]

View Answer   |  November 20, 2009  8:44 AM
AS/400, DB2 Universal Database, SQL Server

Msg 102, level 15, State 1, Line 14
Remove all the ‘GO’s that are inside the stored procedure body, and it should work.

View Answer   |  November 19, 2009  7:09 PM
CREATE TABLE statement, SQL, Stored Procedures

How to encrypt a big list of sp’s at once
No there isn’t. You have to do an ALTER PROCEDURE specifying the WITH ENCRYPTION option. Do keep in mind that this encryption is very easy to undo. There are plenty of freeware software packages out there to decrypt the procedures. It also makes things look very unfriendly to the DBA when you encrypt the procedures [...]

View Answer   |  November 18, 2009  1:46 AM
Encrypt, SQL, SQL stored procedures, Stored Procedures Optimization

MS SQL Server to Oracle Applications
Sounds like a perfect job for a SQL Server Integration Services package.

View Answer   |  November 18, 2009  1:00 AM
Oracle applications, Oracle migration, SQL Server