Automation of SQL Report
Hi, I need to automate a certain report which we take from 2 different databases and paste the data in the Excel and send it to certain email IDs? can someone help me??
Hi, I need to automate a certain report which we take from 2 different databases and paste the data in the Excel and send it to certain email IDs? can someone help me??
5 pts.
Creating a database on two nodes in a SQL Cluster
I have set up a SQL Cluster for three nodes, but I need to create a database on only two nodes. How would I do this?
I have set up a SQL Cluster for three nodes, but I need to create a database on only two nodes. How would I do this?
Creating SQL databases for customer data
I am creating an application that potentially has quite a lot of rows of data for hundreds of customers. Each set of customer data is only for that customer. There may be some future requirement to summarize the data for all customers, but that is not currently needed. Would it be better to place...
I am creating an application that potentially has quite a lot of rows of data for hundreds of customers. Each set of customer data is only for that customer. There may be some future requirement to summarize the data for all customers, but that is not currently needed. Would it be better to place...
VB.NET code ideas on a SQL Server
What VB.NET code would I use to populate a ComboBox with all SQL Server names and IDs in a network? Also, what VB.NET code would I use to backup my SQL database using parameters?
What VB.NET code would I use to populate a ComboBox with all SQL Server names and IDs in a network? Also, what VB.NET code would I use to backup my SQL database using parameters?
SQL Server 2005 within MS Access VBA
I have am MS Access (VBA) program where I need to create a table on a SQL Server database then append data to the table. I have the code that generates the update query but I need the ADO code that creates the connection to the SQL Server 2005 database then I need the code that will execute the...
I have am MS Access (VBA) program where I need to create a table on a SQL Server database then append data to the table. I have the code that generates the update query but I need the ADO code that creates the connection to the SQL Server 2005 database then I need the code that will execute the...
Setting database security to prevent restoring databases on other SQL Servers
Within a database in my SQL Server, I am able to control users from Alter Table and Alter SP, and a strong ‘sa’ password is also created. When I login to the backup of that database with a backup operator ID, the backup operator is able to restore the database, and his and others’ rights are...
Within a database in my SQL Server, I am able to control users from Alter Table and Alter SP, and a strong ‘sa’ password is also created. When I login to the backup of that database with a backup operator ID, the backup operator is able to restore the database, and his and others’ rights are...
Code differentiating between SQL Server 2000 and SQL Server 2005
If SQL Server 2000 and SQL Server 2005 run on the same server, how can your code differentiate which database to use? Can you give the new instance of SQL a different name?
If SQL Server 2000 and SQL Server 2005 run on the same server, how can your code differentiate which database to use? Can you give the new instance of SQL a different name?
Why might a maintenance plan fail to generate a SQL Server job?
I was reading the article “Use the database maintenance plan wizard” on SearchSQLServer.com and wanted to ask, why in some cases, a maintenance plan would fail to generate a SQL Server job. I currently have cases where a maintenance plan was saved but jobs were not created at all or, in one...
I was reading the article “Use the database maintenance plan wizard” on SearchSQLServer.com and wanted to ask, why in some cases, a maintenance plan would fail to generate a SQL Server job. I currently have cases where a maintenance plan was saved but jobs were not created at all or, in one...
Moving a SQL database from one host to another
I need to help out in a move of a site coded in ASP/VBScript from one host we're having major problems with to another host that has been highly reliable for us. They both offer all the same features needed for this site, but we don't know how to move the SQL database along with the site. Can...
I need to help out in a move of a site coded in ASP/VBScript from one host we're having major problems with to another host that has been highly reliable for us. They both offer all the same features needed for this site, but we don't know how to move the SQL database along with the site. Can...
How can I restore my old data into the new design in SQL Server 2000
The SQL Server 2000 application I was using was badly designed. Now that there has been a rework of my database design, so many more tables and columns are being added. How can I restore my old data into the new design?
The SQL Server 2000 application I was using was badly designed. Now that there has been a rework of my database design, so many more tables and columns are being added. How can I restore my old data into the new design?
Accessing MS SQL Server database from the iSeries
How to set up TCP/ IP on both ends( SQL server and AS/400)? I keep geting "host name not found" on as400. Thanks, Lan
How to set up TCP/ IP on both ends( SQL server and AS/400)? I keep geting "host name not found" on as400. Thanks, Lan
database sql,with vb coding,first time running not fast
we have an accounting package written in visual basic 6.0 and sql database,the problem is when we open the database the first time,it takes lot of time,but when we open it after, it will be very fast and remain fast ,even when we quit the application and restart it.
we have an accounting package written in visual basic 6.0 and sql database,the problem is when we open the database the first time,it takes lot of time,but when we open it after, it will be very fast and remain fast ,even when we quit the application and restart it.
