Ok this is a simple question and I am just starting out .When we deploy an GUI application buil in VB.NET that uses SQL SERVER EXPRESS EDITION, how do we embed it in the final installation pro...
I was trying to find the pros and cons of using this approach, but thought I would also ask everyone on here as well.
In Sql Server 2000 and 2005 I have used xml to perform multiple updates...
I tried to copy the resultset in sql server2005 to Excel.but i could copy only the results not the column names.can anyone tell me How to copy the result in mangement studio in sql server 2005...
Dear EE
I am working with Reporting Services 2005 and I want to limit the number of rows inside the report with either tabular report or Matrix report
How can I do that?
Please advise me w...
Dear Experts,
I wrote the query below a while back to select all products which are associated with an outlet.
I now wish to add in another layer which only selects a product when produc...
I have some .rld files that were used with SQL Reporting Services 2000. Now, I like to move them over to SQL 2005. What are the steps to do this? Do I need to install Reporting Services 2005? ...
I'm having a hard time getting CDO to work from T-SQL on a Win-2003 64 machine.
Getting a -2147220960 error on the Send method.
Tried both values 1 and 2 for "sendusing" with the same ...
I plan to resize my sql server 2005 memory from 16GB to 25GB, will this require restart of services or it just OJ if I change the value in sql server memory configuration properties
I have found where to get rid of the header information for my queries but I still get
(1 row(s) affected)
for example and I don't want this. Thanks
I have an audit table T with around 11 columns. Say FK, C1,C2,C3.... C10. Here FK is the guid of the corresponding row in the original table. Whenever any data changes in the original table, I...
what is the difference between the express edition of MS sql server 2005 and professioanl /developer/ec. editions? Explain please.
I wonder if setting of my physical memory like this, will this lock out my memory straight away to sql server or its all depends to need of sql server, which will increase according to sql wo...
I have very simple table that relates a customer (CIF) to an account.
CIF Account
-------------------
1 x
2 x
3 x
4 y
5 y
From this ta...
We are running SQL 2005 Standard Edition, with SP2 applied. I created a Maintenance Plan for our EOD process. You can see the outline in the attached JPG. For some reason it is not processi...
hi,
I get an error when I am trying to connect to ms sql server 2005.
sometimes, the error disappear by itself and everything going so fine, and sometimes it gives me an error when I am tryi...
my application is in vb6.0 and crystal report 9, when i am pressing print button from form, it was displaying the error (pic I attached for your reference). when i am registering this file, "...
Hello, I have a table called ASSETS that contains the following fields:
Bus_ID,Asset_Count, Type, Count_Date
I also have a table called BUSINESS_UNITS with the key of Bus_ID. What I wan...
We are deploying a new server that will be running SQL Server 2005 Enterprise Edition. The SQL will be used by a third party web-based application.
The new server is an HP ProLiant ML370 G...
Greetings all
I am workling (design stage) on an app that will involve lareg text volumes and have been asked to look into using external "file content" / text files for storing thr text, w...
My in house databse programmer wants to shift us to using SQL as our database instead of the foxpro dbf's were are currently using. He wants to stick with Visual Foxpro 9 since he's been doin...
We have new website coming up soon, the website is on our server but using the developer domain, so all the links are using their domain name, is it posible to run a script to change all the H...
I have created new database user and give him securityadmin and sysadmin server roles, but when I ran below query to verify it
EXECUTE AS LOGIN = 'dbtenUser';
exec sp_helplogins
revert
G...
our current Production SQL Server 2000 (Standard Edition) needs to be moved to a new host. We would like to incorporate an upgrade to SQL Server 2005 (Standard Edition) as a part of this tas...
MY requirement is to call an ssis package from C#. This ssis pacakge will take in an input parameter and should also return an output. SSIS pacakge will call a stored procedure with the given ...
I need to alter the server collation settings on an instance within SQL Server 2005 Express to "Latin1_General_CI_AS" from "Latin1_General_CI_AI".?
I have tried re-installing the instance b...
