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
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
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 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
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
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
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
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
Seems like it would look something like this. fetch next If FldA <> 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
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
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
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
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
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++
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
<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
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
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 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
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++