Additional SSL SSRS site within 2008 SSRS Integrated mode
We are installing OCS 2007 R2 that requires a secured (SSL – https) SSRS Site for their Monitoring piece.  We have an existing Windows 2008 Enterprise 64bit - SSRS 2008 Enterprise 64bit site that is integrated to Sharepoint 2007.  Could we use this environment for the additional SSL SSRS site?  Can two 2008 SSRS sites exist on the [...]

Answer Question   |  August 20, 2009  6:17 PM
OCS 2007, OCS 2007 R2, SSRS 2008

SQL Server transactions TSQL question.
Does a list of Transact SQL statements, that cannot be used within transactions, exist please? Is it available on the Web?

Answer Question   |  August 25, 2009  5:19 PM
SQL Server administration, T/SQL, Transition Packsaction

Bulk-Logged Recovery Model SQL Server 2005
If I change the recovery model on the database from full to bulk-logged to run DBCC CheckDB and Rebuild Indexes is changing the recovery model the correct thing to do?

Answer Question   |  August 22, 2009  5:06 PM
SQL, SQL Server 2005, SQL Server 2005 performance

Select into vs Insert into in SQL Server
Hi experts, What is better between Select into vs Insert into in SQL Server when it comes to performance? thx

Answer Question   |  September 1, 2010  4:36 PM
SQL INSERT, SQL performance, SQL Server 2000

SQL cursor question
hi, i’ve SQLRPGLe program in which i’m writing a cursor to select all records, order them by a field A (suppose employee number). And once all the rows fetched for an employee and printed, print the count at the bottom. Repeat this for all the subsequent employees…. i’m not sure how to handle the print count part…i.e. in SQL how [...]

Answer Question   |  August 20, 2009  2:24 PM
RPGLE, SQL, SQL Cursors

SQL 2005 Express installation on 2008 server 64 bit
I am trying the install the SQL 2005 Express on Windows 2008 64 bit OS. I keep getting the following warning message..” Failed to find the ASP.NET Registration”. Im a newbie to this..so any help would be appreciated. thxs

Answer Question   |  August 20, 2009  7:40 AM
SQL Express, SQL Express 2005, SQL Installation, Windows Server 2008

Converting a log file in C#
how to convert a log file in text format into sql database

Answer Question   |  August 20, 2009  6:07 AM
C# .NET, log file, SQL Database, SQL Log Files

SQL Certification
I am working on SQL server 2005 since last 8 months. i want to do certifications in sql. can anyone tell me for which certification i should go? and it’s details also if possible.

Answer Question   |  August 20, 2009  1:57 PM
Certification programs, Certifications, SQL certifications

Replication and using EMC Autostart
I am using EMC Autostart to monitor and mirror an application that uses a SQL 2000 DB. All worked well until I incorporated replication to keep certain tables synchronized with 2 other servers. The Autostasrt uses virtual names and IP’s for clients to connect no matter which server is acting as Primary. Autostart stop services [...]

Answer Question   |  August 20, 2009  3:19 PM
EMC Autostart, SQL 2000, SQL Database, SQL replication, Windows Server 2003

SQL Server Transaction Logs
If I change the recovery model on the primary database from full to simple and then change the primary database back to full again. Would that break the log chain? It seems the log shipping breaks after we do that.

Answer Question   |  August 18, 2009  2:11 PM
SQL Server 2005, SQL Server backup, SQL Server log shipping, SQL Server logs, SQL Server transaction logs

Data base with Visual C++
I am learning on Data Base management. I have installed Visual C++ and will use SQL server. But I don’t know which component else to install, and how to connect to and use SQL Server. Can somebody help me? Thanks a lot

Answer Question   |  April 3, 2012  9:22 AM
C++, SQL Server, SQL Server database, Visual C++

SQL Express used for SSIS?
Can sqlexpress be used for SSIS

Answer Question   |  August 20, 2009  12:18 PM
Dell PowerEdge, Dell PowerEdge 750, SQL Express, SSIS

SQL DB Manage/Admin
Any suggestions or ideas on DBA enterprise software for managing remote sqlservers??   Looking for tools to manage and administer from one main sqlserver.   Thanks

Answer Question   |  August 14, 2009  6:03 PM
SQL Server 2005, SQL Server Management, Windows Server 2008

Retreiving AS/400 SQL scripts
When I start sql on our iSeries, the system returns my previous scripts I have run. Which fle do these live in in the iSeries and can I report on them?

Answer Question   |  October 12, 2009  2:33 PM
i570, iSeries SQL, SQL commands, SQL scripts

comparing variable to a field with comma-separated values
"m trying to compare a variable (@item) to a field which has multiple item numbers separated by commas. I've used "LIKE" and "IN" to no avail. I've also tried appending wildcard characters to the variable (@item2), which also hasn't worked. Full-text indexing is not activated on the DB (SQL Server 2000), so I can't use [...]

Answer Question   |  August 15, 2009  2:00 PM
Comma Separated Values, SQL Server 2000, SQL Server development

SQL Developer: missing expression on insert into with select rownum
insert into TEMPLE_BDMS.TEMP_QSP values ( select rownum as uniqrownum, doc_id, doc_type, barcode2, barcode3, barcode4, routing_status, scan_date, assignee, scanner, scan_station, pfile_name, new_doc_id, new_doc_type, new_doc_type2 from TEMPLE_BDMS.QSP_SOURCE where pfile_name not like ‘%_0001.%’ ) I can run the select fine (it returns rows), but when I try to insert with the select, I get an ORA-00936 missing expression [...]

Answer Question   |  August 13, 2009  5:04 PM
ORA-00936, Oracle developers, SQL Developer

Reformatting SQL Data in a Field
Hi, I’m new to the whole SQL experience and need help converting some data.  In our Activity table, data was imported into the UF_4 field incorrectly.  We want to convert this data “from a Decimal format” to a “NonDecimal”.  Currently the data looks like 5234.000 and we want it to look like 5234 Thanks in advance [...]

Answer Question   |  August 13, 2009  3:42 PM
SQL, SQL 2005

ACCESS 2007 and SQL Server 2005 Schema Updates
We have several clients with access to reports (provided via Views). The reports for each client are separated by being under a different SQL Server 2005 Schema. Obviously we can get each client to link to their Views but the client wants things to work like an ADP – that is, as reports are added, [...]

Answer Question   |  August 13, 2009  2:56 PM
Access 2007, Microsoft Access, SQL Server 2005

PRINT statement in Stored Proc SQL Server 2005
Does PRINT statement in stored proc cause network traffic or any performance issues? Can i get some tips to write good store proc that gains performance.   Thanks.

Answer Question   |  August 12, 2009  6:27 AM
SQL Server 2005, SQL Server stored procedures

T-SQL query to ACESS 2007 database
I need examples of T-SQL queries running on SQL Server 2005 that retrieve data from a MS ACCESS 2007 Table. Any explanations are appreciated. Thanks

Answer Question   |  August 11, 2009  6:32 PM
Access 2007, Access Database, SQL Server 2005, T-SQL, T-SQL Stored Procedures