SQL Server

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...

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? Software/Hardware used: Windows PC, SQL Server 2005

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? Software/Hardware used: SQL Server 2005

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

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...

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 Software/Hardware used: SQL2005 Express, Windows 2008 Server

Converting a log file in C#

how to convert a log file in text format into sql database Software/Hardware used: c#.net

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...

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. Software/Hardware used: SQL Server 2005

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 Software/Hardware used: Visual C++, SQL Server

SQL Express used for SSIS?

Can sqlexpress be used for SSIS Software/Hardware used: DELL 750 Poweredge server

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 Software/Hardware used: 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? Software/Hardware used: i570

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...

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.%' ) ...

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...

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,...

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.

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

Tuning SQL query with hierarchy result through DB link

I have the below SQL query: /********************************************************************************************************/ SELECT tm_super.tm_nbr ,tm_super.tm_fname ,tm_super.tm_lname ,tm_super.super_tm_nbr ,tm_super.super_fname ...