SQL Trigger to create .csv file
I need to create a .csv file out of table A upon the insertion of a record into table B. It seems to me that this should be easy to accomplish, but the only answer I can get from anyone is to do a scheduled DTS package, which means we are dumping this table every couple of minutes all throughout...
I need to create a .csv file out of table A upon the insertion of a record into table B. It seems to me that this should be easy to accomplish, but the only answer I can get from anyone is to do a scheduled DTS package, which means we are dumping this table every couple of minutes all throughout...
0 pts.
Accessing Linked Server in SQL Server 2000 (Urgent)
I have a server named say 'SRVMAIN'. Using Enterprise Manager I added a linked server 'LNKDSRVR1' (existing server). I m able to access any database in 'LNKDSRVR1' by writing a query in query analyzer of 'SRVMAIN' as SELECT * FROM LNKDSRVR1.TESTDB.DBO.TESTTABLE Now if I have server as...
I have a server named say 'SRVMAIN'. Using Enterprise Manager I added a linked server 'LNKDSRVR1' (existing server). I m able to access any database in 'LNKDSRVR1' by writing a query in query analyzer of 'SRVMAIN' as SELECT * FROM LNKDSRVR1.TESTDB.DBO.TESTTABLE Now if I have server as...
Urgent!Please help: TOP 3 cities only returned based on count() - result
I have three tables: Country, City, Restaurant. I would like to have a query that first calculates how many restaurants are for each city. I would only want to return those three cities for each country which has the most number of restaurants. Country-table: countryid, countryname City-table:...
I have three tables: Country, City, Restaurant. I would like to have a query that first calculates how many restaurants are for each city. I would only want to return those three cities for each country which has the most number of restaurants. Country-table: countryid, countryname City-table:...
Database comparison
I know this is 'cheating' but i was wondering if anybody had a quick way to compare two SQL2000 databases at an object level. I need to check the design of tables, code in Sp's etc. I think this can be done using systables, however i was wondering if anybody had done this and how easy it was. All...
I know this is 'cheating' but i was wondering if anybody had a quick way to compare two SQL2000 databases at an object level. I need to check the design of tables, code in Sp's etc. I think this can be done using systables, however i was wondering if anybody had done this and how easy it was. All...
Can't register remote SQL 2000 server
We have fresh installs of XP Pro SP2 on several workstations in the same site and the same subnet done not from the image. We want to use TCP/IP to register the default instance of SQL 2000 server located behind the firewall, not in our site. Some of workstations have no problems registering the...
We have fresh installs of XP Pro SP2 on several workstations in the same site and the same subnet done not from the image. We want to use TCP/IP to register the default instance of SQL 2000 server located behind the firewall, not in our site. Some of workstations have no problems registering the...
Accessing MS SQL Server DB from iSeries
I am trying to find a way to execute a SQL statement on the IBM iSeries and access info in a MS SQL Server DB that is on a different server. Can someone point me in the right direction to find any info on this?? Thanks, Dave
I am trying to find a way to execute a SQL statement on the IBM iSeries and access info in a MS SQL Server DB that is on a different server. Can someone point me in the right direction to find any info on this?? Thanks, Dave
Defrag SQL Database
To my understanding, a normal defrag application will not defrag a SQL database. How would this be done, how would you defrag a SQL database? What applications could you use and/or what commands would you use? Kind Thanks.
To my understanding, a normal defrag application will not defrag a SQL database. How would this be done, how would you defrag a SQL database? What applications could you use and/or what commands would you use? Kind Thanks.
