sqlserver2005 on windows vista home premium(32 bit)
i have sqlserver2005 wid service pack 2 installed,it gives server names as-’user-pcsqlexpress’&'user-pc’. But wen using visualstudio2008,if i give this as the server name during database connectivity it does not recognise and the error msg says that d server doesnt exists.Please give me a solution

Answer Question   |  August 24, 2009  7:42 AM
SQL Server 2005, SQL Server error messages, Vista, Windows Vista Home Premium 32-bit

how i do save picture in data base vb.net
iam using sql express to develop application which have i picture so i can try how a save picture inside data base and loading vb picture box can any one tell me please how i do thi?

Answer Question   |  January 23, 2010  7:58 PM
Access Database Attachments, SQL Express, Visual Basic

SQL auto increment by group with INSERT..
Is it possible to define an auto-incremental coloumn which increments by ‘group’ ? I want to create a version log for an old table (uniquely keyed ‘HOWTONO’) which contains records with ‘How to’ data in the form of short code-fields and some long fields with text.  I intend to trigger updates, inserts  and deletions from [...]

Answer Question   |  August 25, 2009  11:19 AM
AS/400, Incremental backup, SQL, SQL INSERT, V6R1

following error when logging into SQLPlus
When i try to log into Oracle SQL*Plus i get the following error ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist I’m using Oracle 9i Personal Edition

Answer Question   |  August 21, 2009  6:41 AM
ORA-01034, ORA-27101, Oracle SQL, SQL Plus

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