SqlServer-QA.net

Hi,  Lots of time I face the problem with dynamic sql that I cant get the temporary table with data created through dynamic sql. e.g. SET NOCOUNT ONDROP TABLE EmployeeCREATE TABLE Employee(EmpId INT, EmpName VARCHAR(50), Sal    DECIMAL(13,2))INSERT INTO Employee VALUES(1, 'Nishant', 30000)INSERT INTO Employee VALUES(2, ...

I am using ssma to migrate db from oracle 9i to sql server 2000. I successfully migrated oracle tables,views,procedures,functions etc.. But can you please help me on how to migrate packages,triggers and indexes? Here i can able to view the headings like''Triggers'', ''packages'', ''Indexes'' in SSMA. But none of my oracle objects are displaying ...

Recently when I had a task to identify the learning materials (free) and web resources for SQL Server Integration Services (SSIS), then first place I have used is MVP private newsgroups. You will appreciate the immediate help I received from fellow MVPs in getting the list swiftly, they are as follows: Books Online (updated) - As the ...

I have multiple access dbs that i would like to import into ms sql 2005 workgroup server with the eventual intent of creating reports by querying the import dbs. Any suggestions on how to begin such a project?  wannadba1

Here are some good resources for SQL Server beginners and new DBA(s) http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp http://www.academictutorials.com/sql/http://www.developer.com/db/article.php/718491 SQL Server Administration and best ...

I am an absolute beginner to the database world.  I have been thown into database testing and know nothing.  I have searched the internet for some of the key words I have heard our developers use, however, I need a good starting point (preferrably a book) that will go through the basics - what are the different types of queries, what are ...

Please post your basic questions about usage of SQL Server in your arena in order to help you get the directive of required information. Thanks