SQL-Using count and inner join in a single query
Hi Trying to retrive a report from the DataBase using left join on two tables. To get the count of resultant table, I’m using count. But the output shows error. If I comment count statement then the query executes successfully. I feel there is some error in the syntax of the count that I’m using. [...]

Answer Question   |  July 27, 2010  11:13 AM
SQL 2005, SQL 2005 Database, SQL generated files, SQL Query, SQL Server, SQL Server 2005

Master Data Services – Confused by mdm.tblStgMember
Hi, In Denny’s excellent blog on loading data into Master Data Services, he populated the staging tables as follows: INSERT INTO mdm.tblStgMember (ModelName, HierarchyName, EntityName, MemberType_ID, MemberName, MemberCode) VALUES (‘Adventure Works’, NULL, ‘FirstName’, 1, ”, 1), (‘Adventure Works’, NULL, ‘LastName’, 1, ”, 2), (‘Adventure Works’, NULL, ‘EmployeeId’, 1, ”, 3) INSERT INTO mdm.tblStgMemberAttribute (ModelName, EntityName, MemberType_ID, [...]

Answer Question   |  July 27, 2010  5:46 AM
Master data management, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2008 R2 Training

Database files in Oracle 9i
i had installed in my PC oracle 9i. i dont have time in practice in niit instutute. i had decided i will prctice in my home but problem is i dont used database file in oracle can u tell me setting about db files

Answer Question   |  November 8, 2010  5:40 AM
Database Files, Oracle, Oracle 9i, Oracle Database

Does Forefront Endpoint Protection support SQL Server 2008?
Does Forefront Endpoint Protection support SQL Server 2008? This question is from the Microsoft Live Chat which took place on July 13th.

Answer Question   |  July 27, 2010  8:11 PM
Endpoint security, forefront endpoint protection, forefront endpoint protection support, Microsoft Forefront Endpoint Protection, SQL Server 2008

Duplicate SQL Server 2005 database
What is the best way to duplicate a SQL Server 2005 database to another server as a standby machine? Can I do this with another installation and some scripting? I have a separate box with SQL 2005 already installed. Can I backup and restore from one machine to the other using scripts and no human [...]

Answer Question   |  July 26, 2010  1:59 PM
Backup, Backup and restore, SQL Server 2005, SQL Server 2005 backup, SQL Server 2005 Database

SQL SERVER 2005 Security use Kerberos instead of NTLM
How can I setup sql server 2005 to use kerberos authentication instead of NTLM?

Answer Question   |  July 27, 2010  8:53 PM
Kerberos, SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server authentication

sql 2008 export to txt for backup and incremental backup
Hi i have one db that i want to back up, so thought id export to txt file/flat file then back that up and then daily increments into that file? cant find the steps to do it..have the wizard..

Answer Question   |  July 23, 2010  10:34 AM
Backup, SQL 2008, SQL database replication, SQL Server, SQL Server 2008, SQL Server database

Help upgrading from SQL Server 1997 to SQL Server 2005
When upgrading from SQL Server 97 to SQL Server 2005, what needs to be done? Can I restore 97 backups to 2005? Do I need to install any other software? Is this an easy process? We have 6 databases with about 300 GB of data currently.

Answer Question   |  July 23, 2010  8:01 PM
SQL Server, SQL Server 2005, SQL Server 2005 upgrade, SQL Server migration, SQL Server Upgrade

What’s the optimum amount of memory on a Quad core xenon 3.4 ghz machine?
Should we load up a 64-bit OS for this machine? It will be SQL Server only. We want to have the best user experience so any help would be greatly appreciated.

Answer Question   |  July 21, 2010  7:37 PM
64-bit Servers, Memory management, quad-core processor, SQL Server

Mirroring SQL Server 2008 to a disaster recovery machine twice a day
I want to mirror my SQL Server 2008 to a disaster recovery machine two times a day. Is there any free software to do this on a running SQL Server? If not, are there any cheap alternatives? Can scripts be run to copy the files over while SQL is running? Can I use shadow copy [...]

Answer Question   |  July 21, 2010  1:59 PM
Disaster Recovery, Shadow Copy, SQL Server, SQL Server 2008, SQL Server backup, SQL Server database

Does SQL support nonlinear recursive queries?
does sql supports nonlinear recursive queries

Answer Question   |  July 21, 2010  10:15 AM
SQL, SQL Query, SQL Server, SQL Server Query, SQL Server query optimization

SQL Server 2005 information
What exactly does SQL Server 05 do and if I’m looking out for a job in this field, is there any exam which I have to take?. I’m new in this and have less knowledge about SQL. Please help. Thank you.

Answer Question   |  June 19, 2013  7:04 AM
SQL, SQL Server, SQL Server 2005, SQL Server career advice, SQL Server certifications

SQL Explorer Not Connected
Hi all My OS is WIN 7 , Oracle Server Installation (10g Express Edition) is Sucessful Oracle 10g Client Installation is sucessful ODBC connection is Sucessful. But SQL Expolrer – not connected Error is General SQL Error. Microsoft [ODBC Driver Manager] Driver is SQLallocHandle on SQL_HANDLE_ENV Failed Allias: ProfitDSN Profit DSN is ODBC Name This [...]

Answer Question   |  July 21, 2010  5:19 AM
Oracle, Oracle 10g, Oracle 10g Express, SQL error messages, SQL Server, Windows 7, Windows 7 in 2010

error in SQL workbench
ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 2 SQL Statement: CREATE  TABLE `cape codd`.`SKU_DATA` ( )   Does anyone know how to fix or workaround this? thanks Whitney Ferrante

Answer Question   |  July 21, 2010  1:29 AM
MySQL, SQL, SQL error messages, SQL Server, SQL Server 2005, SQL Syntax

.Net Application Routing Emails from SMTP to Exchange Server Error
Our .Net app works fine using current We.config settigs if we send emails to an external SMTP host. When we point it to our Exchange server it won’t work! Any ideas please help. Are there specific SMTP Server settings we need for this to work with Exchange, or any Exchange Server settings that might be [...]

Answer Question   |  July 22, 2010  12:47 AM
.Net Application, Exchange, Exchange errors, SMTP, SQL Server, Windows Server 2003

How can i connect database from sql explore
Hi all, My OS is Windows 7, I install Oracle 10g Express Edition then i install Oracle 10g client. Installation is Sucessful then i config ODBC setting.ODBC is Connection Sucessful.But SQL Explorer is Not Connected.How can i solve this Problem?Kindly Help.

Answer Question   |  July 20, 2010  5:11 PM
ODBC Oracle Access, Oracle 10g, Oracle 10g Client Version, Oracle 10g Express, Oracle installation, SQL Server, Windows 7, Windows 7 in 2010

cannot connect vb program with sql server 2005 in local machine
the simple program of fetching the data of table through vb.net program. i am retriving the data into DatagridView . i am writing following String str for connection :  Dim str As String = ” Data Source=COMP1SQLEXPRESS ; Initial Catalog=Atuldb; User Id=COMP1comp11;Password= ” my database name is “Atuldb”, I am using SQL SERVER MGT STDIO. [...]

Answer Question   |  January 21, 2012  2:34 PM
SQL Server, SQL Server 2005, SQL Server Management Studio 2005, VB.NET 2008, Visual Basic, Visual Basic .NET, Visual Basic 2008

Read Excel from Sql Server 2005/2008 SQLEXPRESS
How to read the excel data’s from Sql Server 2005/2008 SQLEXPRESS

Answer Question   |  July 20, 2010  11:30 AM
SQL Express, SQL Server 2005, SQL Server 2008, SQLEXPR

FreeRadius CentOS 5.5 Help
Hello, I have setup a freeradius server on CentOS with a SQL backend. I am unable to autenticate using NTRadPing to test a user conenction. Just need some help to debug and find out the cause. Thanks! Scott

Answer Question   |  July 20, 2010  9:43 PM
CentOS, CentOS administration, Radius Server, Server Architectures, SQL Server

Calling stored procedure in a database to query data in another database
Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData ‘some_remote_db_name’; and [...]

Answer Question   |  February 14, 2012  3:20 PM
SQL 2005, SQL Query, SQL Select, SQL Server, SQL Server 2005, SQL Server 2005 administration, SQL Server stored procedures, T-SQL