DB Triggers and JPA
Seems to me if the trigger is working using another program or utility it isn’t the trigger program logic that is wrong. I would check the authority you might be adopting in the new application to see if that is the cause. We use trigger programs here but they all run under adopted authority to [...]
View Answer
| November 8, 2007 5:47 PM
AS/400, iSeries, JPA, Spring, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Toplink, Triggers, XFire
Seems to me if the trigger is working using another program or utility it isn’t the trigger program logic that is wrong. I would check the authority you might be adopting in the new application to see if that is the cause. We use trigger programs here but they all run under adopted authority to [...]
View Answer
| November 8, 2007 5:47 PM
AS/400, iSeries, JPA, Spring, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Toplink, Triggers, XFire
7 SQL Servers working seperately need joining.
Hi, I think in your case SQL replication is very usefull.. you need to choose merge replication from snashotp,transactional etc.. go throught the SQL replication funcationlity and implement it. it will help you. Best Luck. Mehul Patel
View Answer
| November 7, 2007 7:35 AM
Networking, SQL Server 2000
Hi, I think in your case SQL replication is very usefull.. you need to choose merge replication from snashotp,transactional etc.. go throught the SQL replication funcationlity and implement it. it will help you. Best Luck. Mehul Patel
View Answer
| November 7, 2007 7:35 AM
Networking, SQL Server 2000
How to create a user login and password in Enterprised Manager in SQL server 2000
Under the server, open security, then logins. If it’s a SQL Login you can set the password here. If it’s a Windows login the password would be the domain password and has to be set by the user or the domain administrator.
View Answer
| November 2, 2007 5:01 AM
Enterprise Manager, Password, SQL Server 2000
Under the server, open security, then logins. If it’s a SQL Login you can set the password here. If it’s a Windows login the password would be the domain password and has to be set by the user or the domain administrator.
View Answer
| November 2, 2007 5:01 AM
Enterprise Manager, Password, SQL Server 2000
Question on JOIN Clause
You should get the same performance. JOIN is an INNER JOIN.
View Answer
| November 2, 2007 4:54 AM
JOIN statement, SQL Server 2000, SQL Server 2005
You should get the same performance. JOIN is an INNER JOIN.
View Answer
| November 2, 2007 4:54 AM
JOIN statement, SQL Server 2000, SQL Server 2005
oracle quires
Your target (custmaster) and source (tnjcust) must have the same number and types of columns when you construct an INSERT statement this way. Frankly, this construction is not a good programming practice. Instead you should list the columns: INSERT INTO custmaster(x,y,z) SELECT seccode,b,c FROM tnjcust WHERE seccode=’431′
View Answer
| October 29, 2007 3:12 PM
Oracle, SELECT statement
Your target (custmaster) and source (tnjcust) must have the same number and types of columns when you construct an INSERT statement this way. Frankly, this construction is not a good programming practice. Instead you should list the columns: INSERT INTO custmaster(x,y,z) SELECT seccode,b,c FROM tnjcust WHERE seccode=’431′
View Answer
| October 29, 2007 3:12 PM
Oracle, SELECT statement
How to write the query
please include rownum in the select statement in and then include rownum > 3. the result will display from 3rd row.
View Answer
| October 29, 2007 8:25 AM
Query, SQL Server 2000
please include rownum in the select statement in and then include rownum > 3. the result will display from 3rd row.
View Answer
| October 29, 2007 8:25 AM
Query, SQL Server 2000
Nested Selects in CLLE
Looks like you don’t have an ENDDO for WHEN (X=Y) tHEN(DO) Thanks for the help, I missed the EndDo statement. Once I properly placed the enddo it worked like a charm wmfsr
View Answer
| October 24, 2007 4:29 PM
CLLE, NESTED, SELECT statement
Looks like you don’t have an ENDDO for WHEN (X=Y) tHEN(DO) Thanks for the help, I missed the EndDo statement. Once I properly placed the enddo it worked like a charm wmfsr
View Answer
| October 24, 2007 4:29 PM
CLLE, NESTED, SELECT statement
Triggers in sql server 2005
Yes. You can do this using the insert trigger. Select the values from the inserted table that is available in the insert trigger and insert them in the ManageAndContact table.
View Answer
| October 24, 2007 4:22 PM
SQL Server, SQL Server 2005
Yes. You can do this using the insert trigger. Select the values from the inserted table that is available in the insert trigger and insert them in the ManageAndContact table.
View Answer
| October 24, 2007 4:22 PM
SQL Server, SQL Server 2005
Select from table where data row missing
I meant to say Data Corruption has necessitated that we find the above scenario.
View Answer
| October 15, 2007 9:35 PM
OUTER JOIN statement, SELECT statement
I meant to say Data Corruption has necessitated that we find the above scenario.
View Answer
| October 15, 2007 9:35 PM
OUTER JOIN statement, SELECT statement
RAID Levels on SAN
when you say VRAID1 and VRAID5 it sounds like you are talking about an HP EVA san, these sans virtualise all san volumes accross all disks within their own disk group, raid1 is faster than raid5 but not as fast as raid10. Das is fast but non useable by any other server or host as [...]
View Answer
| October 5, 2007 8:32 PM
RAID, RAID 1, RAID 5, SAN, SQL Server 2005, SQL Server Enterprise Edition, VRAID1, VRAID5
when you say VRAID1 and VRAID5 it sounds like you are talking about an HP EVA san, these sans virtualise all san volumes accross all disks within their own disk group, raid1 is faster than raid5 but not as fast as raid10. Das is fast but non useable by any other server or host as [...]
View Answer
| October 5, 2007 8:32 PM
RAID, RAID 1, RAID 5, SAN, SQL Server 2005, SQL Server Enterprise Edition, VRAID1, VRAID5
insert into system tables
I’m SQL 2005 you can’t actualy write to the system tables, because there are no system tables any more. You will need to generate dynamic code to run the sp_addextendedproperty procedure to add the extended property you are trying to add. You can lookup sp_addextendedproperty in Books OnLine to get the full syntax of the [...]
View Answer
| October 5, 2007 8:27 PM
SQL Server
I’m SQL 2005 you can’t actualy write to the system tables, because there are no system tables any more. You will need to generate dynamic code to run the sp_addextendedproperty procedure to add the extended property you are trying to add. You can lookup sp_addextendedproperty in Books OnLine to get the full syntax of the [...]
View Answer
| October 5, 2007 8:27 PM
SQL Server
SQL joins on encrypted data
If your encryption padds the encrypted value with filler data then yes, the join could fail as the values wouldn’t match. If you aren’t padding the encrypted value then your values should match and you should be able to do the join.
View Answer
| October 5, 2007 8:26 PM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server, Web site design & management
If your encryption padds the encrypted value with filler data then yes, the join could fail as the values wouldn’t match. If you aren’t padding the encrypted value then your values should match and you should be able to do the join.
View Answer
| October 5, 2007 8:26 PM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server, Web site design & management
SQL 2000 to Yukon Migration
You would either need to setup a new server running SQL 2005, or install a SQL 2005 instance leaving the SQL 2000 instance. Then detach the databases from the SQL 2000 instance and attach them to the SQL 2005 instance. Be sure to do full testing to make sure that there won’t be any issues [...]
View Answer
| October 5, 2007 8:18 PM
Access, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
You would either need to setup a new server running SQL 2005, or install a SQL 2005 instance leaving the SQL 2000 instance. Then detach the databases from the SQL 2000 instance and attach them to the SQL 2005 instance. Be sure to do full testing to make sure that there won’t be any issues [...]
View Answer
| October 5, 2007 8:18 PM
Access, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
Triggers
There is no way to write a trigger which will fire when reads are done. You can create a trace using SQL Profiler which will log all of the commands which are executed. You can have all this logged to a table, and then parse the field with the actuall command (called text) to get [...]
View Answer
| October 5, 2007 7:59 PM
SQL Server
There is no way to write a trigger which will fire when reads are done. You can create a trace using SQL Profiler which will log all of the commands which are executed. You can have all this logged to a table, and then parse the field with the actuall command (called text) to get [...]
View Answer
| October 5, 2007 7:59 PM
SQL Server
SQL Server Schema Best Practices
Yes you can do this within SQL Server. Make the user the owner of the schema, and grant them the control right over the schema. This will give them the ability to grant other users rights to objects within there schema, as well as give them the ability to create objects. You can also create [...]
View Answer
| October 5, 2007 7:56 PM
SQL, SQL Server
Yes you can do this within SQL Server. Make the user the owner of the schema, and grant them the control right over the schema. This will give them the ability to grant other users rights to objects within there schema, as well as give them the ability to create objects. You can also create [...]
View Answer
| October 5, 2007 7:56 PM
SQL, SQL Server
database sql,with vb coding,first time running not fast
This will be because the first time you connect the database has to be opened and the information that you are looking for loaded from disk into memory. This is called caching the data. SQL caches as much data as possible into it’s buffer. The more often the data is needed the longer it will [...]
View Answer
| October 5, 2007 7:52 PM
SQL Database, Visual Basic 6
This will be because the first time you connect the database has to be opened and the information that you are looking for loaded from disk into memory. This is called caching the data. SQL caches as much data as possible into it’s buffer. The more often the data is needed the longer it will [...]
View Answer
| October 5, 2007 7:52 PM
SQL Database, Visual Basic 6
I can update the dataset, but not the database
Have you called Update on the data adapter? e.g. customersTableAdapter.Update(northwindDataSet.Customers); from msdn
View Answer
| October 5, 2007 1:20 PM
Database, SQL Express, Visual Basic
Have you called Update on the data adapter? e.g. customersTableAdapter.Update(northwindDataSet.Customers); from msdn
View Answer
| October 5, 2007 1:20 PM
Database, SQL Express, Visual Basic
Accessing SBS 2003 Sharepoint and RWW On LAN Without Joining The Domain.
For Sharepoint try: https://Computername:444 or https://IP Address:444 For Remote Web Workplace: https://Computername/remote or https://IP Address/remote Thats how my non domained users access it. Hope this helps, Paul
View Answer
| July 17, 2007 2:18 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
For Sharepoint try: https://Computername:444 or https://IP Address:444 For Remote Web Workplace: https://Computername/remote or https://IP Address/remote Thats how my non domained users access it. Hope this helps, Paul
View Answer
| July 17, 2007 2:18 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Copy program with SQL database without data
It depends on your DBMS and OS. Can you be more specific?
View Answer
| July 17, 2007 1:57 PM
SQL Server
It depends on your DBMS and OS. Can you be more specific?
View Answer
| July 17, 2007 1:57 PM
SQL Server
Qeuestion on Cache….
Look at the cache_level series of function calls. Bob
View Answer
| July 17, 2007 12:01 PM
DataCenter, Desktops, Linux, Management, Microprocessors, Microsoft Windows, OS, Security, Servers, SQL Server
Look at the cache_level series of function calls. Bob
View Answer
| July 17, 2007 12:01 PM
DataCenter, Desktops, Linux, Management, Microprocessors, Microsoft Windows, OS, Security, Servers, SQL Server
