I'm planning to run MSSQL2005. Would anyone be able to point me to where I can find some information on the required hardware specifications?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21429456.html
Setting up Agent to send email is a pain for those of us not running exchange. Will we still have to muck about with setting up mail profiles at the Windows level?
How well Express handle mail t...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21448212.html
Hi...
Do you guys know a good tool that generates c# code to connect with stored procedures?
It's such a pain to add all taht parameters code... with the right dimentions and column types... ah...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_21818852.html
Zones:
C#Date Answered: 05/24/2006 Grade: A Views: 6
Hi
Can anyone help with this problem, I need to import data into a table column that has a constraint on it using SQL 2005 Import and Export wizard, problem is the insert fails due the the constra...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21926467.html
I have an Intranet homepage that has a TROUBLE TICKET asp.net/SQL2005 application. When someone creates a ticket, it emails the details of the ticket to the person it is assigned to. I would like t...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_22063878.html
I have a performance issue on my SQL 2005 sever and occaionally users complaint the server is very slow.
My problem is
1. How to identify the bottleneck in SQL 2005 (or Window 2003) ? There is ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2300...
I am currently using
select * from where columnname like '[0,30]' I need to get all the columns that are 0 or 30 using like. what is the correct syntax?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2301...
I currently have a pivot table that is working great but I need to add to it. The below code is giving me the total ServiceTime per date. I need to split this service time out depending on the s...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2313...
I am trying to write a stored procedure that will give me a SUM of service times for a given day. The problem I am having is that the user can select a date range of up to 16 days. This is where ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23142697.html
Hello,
I am importing .dat file which has double quotes (") as the text qualifier.I am able to successfully import the bulk data courtesy the msdn link "http://msdn2.microsoft.com/en-us/library/...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2321...