Capture SQL Server logged in db User name in Access 2007 Accdb
The SQL Server system function suser_sname() will return the username of the login used to connect to the SQL Server. Wouldn’t it be easier to have Access provide the NT Username of the person who opened the access file?

View Answer   |  August 25, 2009  3:15 AM
Access 2007, Access 2007 security, Microsoft Access, SQL Server 2005, SQL Server 2005 security, SQL Server security

SQL Server Database Restore
You would need to change the owner on the source system before you backup the database. You can’t make any changes to the database when it is in stand by /readonly mode.

View Answer   |  August 24, 2009  10:54 PM
SQL Server, SQL Server 2005, SQL Server administration, SQL Server database, SQL Server database restore

sqlserver2005 on windows vista home premium(32 bit)
You might find that you get a better response if you post the full error message that you are getting. Have you made sure that the MSSQLSERVER and MSSQL$SQLEXPRESS services are running on your computer?

View Answer   |  August 22, 2009  10:06 AM
SQL Server 2005, SQL Server error messages, Vista, Windows Vista Home Premium 32-bit

Select into vs Insert into in SQL Server
Select into is much much faster in terms of performance as it can run in minimally logged mode. For this, you need to have the database in Bulk-Logged recovery. When you use Bulk-Logged recovery, and when you execute a Select into command, it is considered a bulk operation. But you would lose the option of [...]

View Answer   |  August 21, 2009  3:51 PM
SQL INSERT, SQL performance, SQL Server 2000

following error when logging into SQLPlus
Please use the search feature here on ITKE. This question has been asked before, and hopefully you will find a solution in previous answers. If you don’t find the solution, please use the discussion section below to provide more details and tell us what you have tried so far, and what the results were. Thanks,

View Answer   |  August 21, 2009  1:37 PM
ORA-01034, ORA-27101, Oracle SQL, SQL Plus

Bulk-Logged Recovery Model SQL Server 2005
No, you should pretty much never change the recovery model of the database once you have it set to the model that you want to use. Changing it to run DBCC CHECKDB and to rebuild the indexes shouldn’t really do anything. DBCC CHECKDB doesn’t write anything to the log, unless you are running it in [...]

View Answer   |  August 20, 2009  8:31 PM
SQL, SQL Server 2005, SQL Server 2005 performance

SQL Server transactions TSQL question.
Pretty much every T/SQL statement can be used within an explicit transaction. I can’t think of any off the top of my head that can’t be used within a transaction, as every command that you run is executed within its own implicit transaction.

View Answer   |  August 20, 2009  8:27 PM
SQL Server administration, T/SQL, Transition Packsaction

Additional SSL SSRS site within 2008 SSRS Integrated mode
Yes you can do this. You can install a second instance of SSRS (SSRS supports named instances) on the servers. You will probably want to point this at a new ReportServer database so that it’s totally separate. You’ll need to assign the SSRS servers another IP so that the sites don’t conflict with each other, [...]

View Answer   |  August 20, 2009  8:26 PM
OCS 2007, OCS 2007 R2, SSRS 2008

SQL cursor question
Seems like it would look something like this. fetch next If FldA &lt;&gt; holdFldA // break on field change holdFldA = FldA Write TotLin Eval TotCnt = *zero endif Eval TotCnt += 1 … Phil Sorry the editor is having more fun with me <> above should be the symbols for not equal to Phil

View Answer   |  August 20, 2009  2:44 PM
RPGLE, SQL, SQL Cursors

SQL 2005 Express installation on 2008 server 64 bit
Try enabling the use of 32 bit applications in the application pools (IIS Manager).

View Answer   |  August 20, 2009  2:15 PM
SQL Express, SQL Express 2005, SQL Installation, Windows Server 2008

Converting a log file in C#
I’m not clear on what you are asking, but I’ll do my best here. If you are trying to convert the SQL Server Transaction Log into a text file, you don’t. There are a couple of applications you can use to view the data in the log file. If you have a text file you [...]

View Answer   |  August 20, 2009  7:14 AM
C# .NET, log file, SQL Database, SQL Log Files

SQL Certification
That would be the MCTS: SQL Server 2005. Once you have that certification you can look into either (or both) of the MCITP: SQL Server 2005 Database Administration or MCITP: SQL Server 2005 Database Development. The MCTS: SQL Server 2005 certification is a requirement before getting the MCITP certifications.

View Answer   |  August 19, 2009  8:18 PM
Certification programs, Certifications, SQL certifications

SQL Server Transaction Logs
Yes that would break the log chain. It shouldn’t break replication, as all the transactions which need to be replicated should be marked in the transaction log as such, and they shouldn’t be able to be removed from the log without being replicated, but I can see it causing problems. What errors is it causing [...]

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

Data base with Visual C++
Here is an example: <a href=”http://support.microsoft.com/kb/308510″>How to update a SQL Server database by using the SqlDataAdapter object in Visual C++ .NET</a> ——————–

View Answer   |  August 18, 2009  6:12 PM
C++, SQL Server, SQL Server database, Visual C++

SQL Express used for SSIS?
According to <a href=”http://msdn.microsoft.com/en-us/library/cc645993.aspx”>this Microsoft document</a>, with the express editions you get only the Import and Export Wizard, and the basic Integration Services features required by the wizard. Al other SSIS features are not included, so you would need standard or enterprise edition.

View Answer   |  August 17, 2009  2:53 PM
Dell PowerEdge, Dell PowerEdge 750, SQL Express, SSIS

comparing variable to a field with comma-separated values
<b><i>One way</i></b> to do it could be using a condition like this: WHERE (ItemString = @item OR ItemString LIKE @item + ‘,%’ OR ItemString LIKE ‘%,’ + @item + ‘,%’ OR ItemString LIKE ‘%,’ + @item)

View Answer   |  August 14, 2009  2:51 PM
Comma Separated Values, SQL Server 2000, SQL Server development

SQL Developer: missing expression on insert into with select rownum
When inserting from a query, you don’t have to use the VALUES clause. Your statement should look like this: <pre>insert into TEMPLE_BDMS.TEMP_QSP 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.%’ ;</pre>

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

Reformatting SQL Data in a Field
I’m assuming that the data type of the UF_4 field is varchar or similar. You will probably need something like this: <pre>UPDATE Activity SET uf_4 = cast(cast(uf_4 AS DECIMAL) AS INT);</pre> ——————————

View Answer   |  August 13, 2009  4:14 PM
SQL, SQL 2005

PRINT statement in Stored Proc SQL Server 2005
PRINT statements do use network traffic, but unless you have a lot of PRINT statements they won’t effect anything.

View Answer   |  August 12, 2009  7:16 AM
SQL Server 2005, SQL Server stored procedures

Connecting a SQL Server database with Visual C++ and .NET
Have a look at the following pages: 1. For Visual C++ 2. For .NET MSDN is not really that helpful, it has all the function definitions but no proper example. You can try the link below for a simple example that will get you started. Connecting To SQL Server Using C++ ODBC Example

View Answer   |  April 19, 2013  3:22 AM
.NET, SQL Server, SQL Server databases, Visual C++