How can I call a trigger in a SQL Server stored procedure?
There is no way to manually fire a trigger. The only way triggers are executed is to run an insert, update or delete statement against the table which the trigger was created on.

View Answer   |  May 2, 2009  8:23 PM
SQL Server, SQL Server stored procedures, SQL Server triggers

Migrating SQL Reporting Services 2000 Reports to SRS 2005?
Have a look at the following Microsoft guide, to see if it helps. <a href=”http://technet.microsoft.com/en-us/library/ms143724(SQL.90).aspx”>Migrating Reporting Services</a>

View Answer   |  April 30, 2009  8:12 PM
SQL Server Reporting Services, SSRS 2000, SSRS 2005, SSRS Migration

Unable to backup sql database.
Without the details we cannot help you with this question. Please provide the details. Thanks. I am using backup exec.

View Answer   |  April 29, 2009  4:44 PM
SharePoint, SharePoint backup, SQL Database

Execute a view/query is slower in SQL Server 2005 than 2000
This could be because 2005 chooses a different execution plan than 2000. Have you had a look at the execution plans ? What is the service pack level of the 2005 server ? There were some situations in which 2005 used less optimal execution plans than 2000, but those bugs have been fixed in service [...]

View Answer   |  April 29, 2009  2:38 PM
SQL Server 2000, SQL Server 2005, SQL Server Query, SQL Server query optimization, VARCHAR

SQL Server Table and View Index
Yes, everything in the database is migrated. So tables, views, indexes, stored procedures are brought in. Anything that is stored in the system databases are not. So DTS packages, jobs, users, maintenance plans, etc are not copied over.

View Answer   |  April 28, 2009  4:26 PM
Index Scan, SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server upgrades, SQL Server views

how can i retrieve the data from sql-server2005 from multiple tables in two combo-boxes in vb6.0 using programming code
Here is an example, using ADO and an ODBC data source to connect to the database: <pre> Dim adoConnection As ADODB.Connection Dim adoRecordset As ADODB.Recordset Dim connectString As String ‘-Create a new connection – Set adoConnection = New ADODB.Connection ‘-Create a new recordset – Set adoRecordset = New ADODB.Recordset ‘-Build the connection string to use [...]

View Answer   |  April 28, 2009  1:49 PM
ComboBox, SQL Server 2005, VB 6.0

Small network setup
yes .. tell me the problem .. its to simple for me .. reply me as soon as possible take care of your self .. Allah hafiz

View Answer   |  April 28, 2009  5:30 AM
Network design, Networking, SQL Server, Windows Server 2003, Windows Vista

Linked SQLServer
If they are on the same server and same database instance then you can just reference the database by using … [DatabaseName].[DatabaseOwner].[TableName] If it is on another server then you will need to link the servers. To the best of my knowledge, and I am not a SQL expert, I think SQL Server may treat [...]

View Answer   |  April 27, 2009  9:37 PM
Linked SQL Servers, SQL Server 2005, SQL Server database, SQL Server Linked Server

Import AS/400 files into SQL server
Hi Yenyen If I remember correctly – and I never do. You need Client-Access installed on your server to get IBM’s ODBC. You need to set-up an ODBC source on your server into the 400 In SQLServer make a DTS and schedule it. Phil

View Answer   |  April 27, 2009  8:56 PM
AS/400 backup, AS/400 jobs, SQL Server 2005

Oracle 10g process each record exactly on time multiple processes
We probably need a little more info to fully answer this question, but here are some notes/suggestions: 1. If you are thinking of querying recent records based on the “processed flag”, the flag should be an integer or date/time value that is changed for every processed record – preferably a non-null column. If you use [...]

View Answer   |  April 27, 2009  6:51 PM
Oracle 10g, Oracle 10g administration, Oracle ROWNUM, SELECT statement, UPDATE statement

The difference between VARCHAR and NVARCHAR
Both types store variable-length character strings. NVARCHAR is a VARCHAR that supports Unicode (two-byte) characters. Unicode data types take twice as much space to store the string as a character string. This is because unicode characters require two bytes to character to be able to support the full possible set of characters. This is why [...]

View Answer   |  April 26, 2009  4:15 AM
NVARCHAR, SQL Server, VARCHAR

Alternatives to cursors in SQL Server
Answer The main purpose that cursors fulfill is traversing of the row set. Cursors can be best avoided by: a. Using the SQL while loop: Using a while loop we can insert the result set into the temporary table. b. User defined functions: Cursors are sometimes used to perform some calculation on the resultant row [...]

View Answer   |  April 26, 2009  4:13 AM
Cursor, SQL Cursors, SQL Server, SQL Server Cursors

Describe in brief authentication modes in SQL server.
The authentication modes are: Windows Authentication mode = enables Windows Authentication and disables SQL Server Authentication Mixed mode = meaning that the server will accept both Windows logins and/or SQL ones Windows Authentication is always available and cannot be disabled. ————– SQL Authentication requires that the user enter a username and password (or this information [...]

View Answer   |  April 26, 2009  4:06 AM
Authentication, SQL Server, SQL Server authentication

SQL Server enterprise manager
Right click on the folder and select Register Server. Fill in the connection details.

View Answer   |  April 26, 2009  3:59 AM
SQL Server Enterprise Manager, SQL Server Enterprise Manager Database Connection

Create a dialog between SQL Server Service Broker and Oracle Streams Advanced Queuing?
No there isn’t. The SQL Service Broker can only talk to other SQL Service Broker queues. I’ve got an <a href=”http://outsidequeue2sqlssb.codeplex.com/”>open source project setup</a> which I haven’t announced yet to work on this problem.

View Answer   |  April 26, 2009  3:48 AM
Oracle Streams, SQL Server, SQL Server Service Broker

Creating an 180,000 record database in SQL Server
The number of records being stored isn’t all that important at the moment. Without knowing more about the information to be stored there’s no way to help you design the database correctly.

View Answer   |  April 26, 2009  3:37 AM
SQL Server, SQL Server databases

Stored Procedure
I think this is what you need: <pre>SELECT t1.PurchaseOrderNo, SUM(t3.Cost) FROM table1 t1 JOIN table2 t2 ON t1.PurchaseOrderNo = t2.PurchaseOrderNo JOIN table3 t3 ON t2.WorkID = t3.WorkID GROUP BY t1.PurchaseOrderNo</pre>

View Answer   |  April 24, 2009  4:11 PM
SQL stored procedures, Stored Procedures

Left outer join
Can you post your query ? Is the meeting information the only one than could be missing ? What version of Sql Server are you using ? —————————

View Answer   |  April 24, 2009  3:02 PM
LEFT OUTER JOIN statement, SQL Left Outer Join, SQL Server, SQL Server tables

SQL in RPG (Error when TESTING (i.e. running under ISDB) RPG program which builds SQL statement and then uses PREPARE,DECLARE,OPEN,FETCH,CLOSE)
INVALID_CURSOR ORA-01001 SQLCODE= -1001 You made reference to a cursor that did not exist. This usually happens when you try to FETCH from a cursor or CLOSE a cursor before that cursor is OPENed. —————- Can you post your SQL statement, so we can have a look ?

View Answer   |  April 24, 2009  2:15 PM
RPG, SQL, SQL in RPG, SQL Testing

SQL login client not admin
In SQL Server 7.0 or later versions, you can maintain the mapping between the logins in the master database and the users in the user database by using the SIDs. This mapping is required to maintain correct permissions for the logins in the user databases. When this mapping is lost, the logins have permission issues [...]

View Answer   |  April 24, 2009  3:46 AM
SQL, SQL performance, SQL Troubleshooting