Sponsor Post: Live Expert Chat 6/1: Drive Your Business Forward with SharePoint 2010
Join us for the next Microsoft Live Chat on Tuesday, June 1 at 11 am ET. SharePoint 2010 allows your company to quickly respond to changing business needs. Your people can share ideas and expertise, create custom solutions for specific needs and find the right business information to drive your business forward. Sign up for [...]

Answer Question   |  October 31, 2011  2:18 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, ITKE, ITKE Community, Linux, Lotus, Microsoft Live Chat, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

SQL Syntax Error SQL0104
I have to recreate a duplicate logical file, but I can’t use the crtdupobj command because it doesn’t recreate the correct library pointers. Using the dspfd command. I’m attempting to recreate the logical file in a different environment(library). Using the exact same commands (different library) I’m attempting to create the file in SQL using the [...]

Answer Question   |  May 26, 2010  6:37 PM
SQL, SQL error messages, SQL Statement Syntax Errors, Syntax errors

Linking Access to SQL Server
Hi ive got alot of linking tables in Ms Access and I want to link in onto Sql Server 2005.how to i do the liking part

Answer Question   |  November 9, 2010  6:52 AM
Linking Access and SQL Server, Microsoft Access, SQL Server, SQL Server 2005

File access restriction for users in Logmein
Hi, Please let me know whether logmein has a feature to restrict access of certain type of files for users. For example we have sql database having customer,account details etc.We need to restrict user who connects remotely to not to access account related files.

Answer Question   |  May 25, 2010  3:46 AM
LogMeIn, Remote access, Restricted User Group, SQL Database

Java Code to Copy AS400 file to SQL Server database/table
I need Java code to access and copy an AS400 file to SQL Server database/table. It must also copy a specific amount of records from the SQL Server side. 

Answer Question   |  May 26, 2010  7:24 PM
AS/400, Java, Java code, SQL Server, SQL Server database

SQL Server schema
Hi,    How can i get the user names assigned to the Schema through (T-SQL) Regards; Rino

Answer Question   |  May 25, 2010  10:51 AM
SQL Server, SQL Server schema, T-SQL

anybody can tell me that how to create setup which will accept database name & server name
anybody can tell me that how to create setup which will accept database name & server name trhough which i can create database in perticular server during setting up the application. i mean to say i don want create manually in sql Server, which should be created during sepup only

Answer Question   |  May 24, 2010  10:23 AM
.NET, Database name, Setup and deployment, SQL Server, SQL Server name

Data Warehouse Query Performance
We have a data warehouse with summary and detail level data with Cognos as the reporting tool.  If we have data for 100 large customers loaded in the fact tables and are trying to use Cognos Query Studio.  Here is the scenario:  one user has access to data for 5 customers through the security layer [...]

Answer Question   |  May 21, 2010  1:24 PM
Cognos, Data Warehouse Testing, SQL Server

alter database
HI, when i run the command alter database northwind set multi_user with rollback immediate the northwind database shows ACCESS denied and tagged as SINGLE USER i donot understand why it so .can u pls explain .

Answer Question   |  April 11, 2011  10:36 AM
Northwind sample database, Run Commands, SQL Server

change track in sql server 2008
HI, use Northwind Alter database [db_track] set change_tracking=on (change_retention=3 days,Auto_cleanup=on) i m running the above  command i m geting the ERROR AS Msg 5011, Level 14, State 5, Line 3 User does not have permission to alter database ‘db_track’, the database does not exist, or the database is not in a state that allows access [...]

Answer Question   |  May 25, 2010  7:16 AM
DB tracking, SQL Server, SQL Server 2008

Which tool is best in all aspects?
Which tool is best in all aspects – speed, performance, user friendly, to do all activities etc - PL/SQL Developer or SQL Developer or TOAD

Answer Question   |  May 20, 2010  6:38 AM
Oracle, PL/SQL Developer, SQL Developer, TOAD

Would using a table variable from a function be efficient?
We divided our tables from table zone_a, …_b, …_c to zone_z, these tables have the same attributes. We have divided this tables in this way so that any data that is under zone_a would only be on it’s specific table, and the same with the other remaining table. Since per table holds thousands of data [...]

Answer Question   |  May 19, 2010  7:16 AM
MSSQL, SQL tables, SQL variables

help me create trigger update column
CREATE  TRIGGER Trigger_UPDATE_BIENLAI_TIENNOP ON BIENLAI FOR UPDATE,INSERT,DELETE AS IF (@@ROWCOUNT = 0) BEGIN PRINT ‘ TABLE is null’ RETURN END IF UPDATE(TIENNOP) BEGIN UPDATE BL1 SET BL1.TIENNOP = BL3.TIENNOP FROM BIENLAI BL1,DELETED BL2,INSERTED BL3  WHERE BL1.SOBL = BL2.SOBL AND (BL3.TIENNOP < 300000)  PRINT ‘ finish update ‘ END /* trigger not check ‘ BL3.TIENNOP < 300000′ [...]

Answer Question   |  May 19, 2010  7:03 AM
MySQL, SQL Syntax, SQLite

Add an Active node to SQL Server Active Passive Cluster
how will i add an active node to an existing Active/passive SQL Server 2005 Cluster. so that when any active node fails the passive will be used.will there be a down time for the current cluster Jasina

Answer Question   |  December 9, 2010  8:35 AM
Active/Passive SQL Server 2005 Cluster, SQL Server 2005, SQL Server clustering

sql server 2008 backup and restore
can u get me the command to recover the database . my backup is in d:nor.bak . as i m running the command   >restore database ‘d:nor.bak’ it gives me the message as : Incorrect syntax near ‘d:nor.bak’. pls let me know how to reatore . Regards, Rino

Answer Question   |  May 19, 2010  6:46 AM
SQL Server, SQL Server 2008, Sql Server 2008 Backup, SQL Server 2008 error messages, SQL Server backup and restore

Looking for Backup solution for VMWare environment
We’ve started adding VMWare servers to our data center, and we need a backup solution that works. We’ll have a mix of ESX4.0 and ESX3.5 hosts along with vCenter 4.0. Host will have Windows 2003, Windows 2008, RedHat 4.x and 5.x. Some hosts will have MS SQL 2005 and Oracle DB. We have TSM deployed [...]

Answer Question   |  August 11, 2010  2:09 PM
ESX4, SQL 2005, TSM Backup, Veeam, Virtualization in 2010, VMware Server

how to save or export datareport from VB6 to PDF or JPG format ?
i make aproject using VB6 & SQL server 2000 and the project has some report like bills , data , i want to save / export  the report to pdf file pr photo format to send it from the mail to another one who can not modify in my report the save or export shouldnot [...]

Answer Question   |  May 17, 2010  10:29 AM
PDF conversion, SQL 2000, VB6

sql
can i download vb., oracle and java for my practice?

Answer Question   |  May 14, 2010  6:44 AM
Java, Java vs Oracle, SQL Server, SQL Server Training

Report Server Install Best Practices
I am setting up my first Report server. Should the Data Engine and two databases that are automatically created reside on the Report Server or on another SQL Server machine?

Answer Question   |  May 13, 2010  6:47 PM
SQL Server 2008, SQL Server 2008 Report Server, SQL Server 2008 Reporting Services, SQL Server Data Engine, SQL Server Report Server

Can’t see step info in an existing job SQL Server
I recently got a new computer and I had to installed sql server on it. When using my old computer I was able to log into my SQL Server and see/modify jobs, but now, even though I can see the list of jobs under my sql server agent, I cannot see any information related to [...]

Answer Question   |  May 16, 2010  1:25 PM
SQL Server Agent, SQL Server Agent Jobs, SQL Server configuration