How do I import a file to a SQL Server table with dates before 1970?
I have a package created in SQL Server Integration Services (SSIS) to load data from three flat files to a table in SQL Server 2005. I use the loop to go through the folder. I need to make sure that I don’t insert rows where a date column includes a year before 1970 (the epoch). [...]
Answer Question
| April 2, 2008 9:12 PM
SQL Server 2005, SSIS
I have a package created in SQL Server Integration Services (SSIS) to load data from three flat files to a table in SQL Server 2005. I use the loop to go through the folder. I need to make sure that I don’t insert rows where a date column includes a year before 1970 (the epoch). [...]
Answer Question
| April 2, 2008 9:12 PM
SQL Server 2005, SSIS
Is firewall preventing SQL Server from showing up in the EM?
I have a corporate Dell Image laptop running SQL server 2000. Enterprise manager (EM) shows up without my registered SQL server (local or remote). When I try to re-register I see the other registered servers, however, they are grayed out. When I use the MMC Snap-In from computer management, I can see my local SQL [...]
Answer Question
| March 24, 2008 8:45 PM
MMC, SQL Server, SQL Server 2000, SQL Server Enterprise Manager, SQL Server security
I have a corporate Dell Image laptop running SQL server 2000. Enterprise manager (EM) shows up without my registered SQL server (local or remote). When I try to re-register I see the other registered servers, however, they are grayed out. When I use the MMC Snap-In from computer management, I can see my local SQL [...]
Answer Question
| March 24, 2008 8:45 PM
MMC, SQL Server, SQL Server 2000, SQL Server Enterprise Manager, SQL Server security
Can SQL Server 2003 provide CPU usage information by application?
I have a Windows Server 2003 Service Pack 1 (SP1) machine and need to find out how much of the central processing unit (CPU) each application is using. I am familiar with task list for Windows XP, but the only task list I see on the Windows 2003 machine is a command line tool and [...]
Answer Question
| March 23, 2008 8:39 PM
CPU usage, SQL Server 2003, SQL Server performance
I have a Windows Server 2003 Service Pack 1 (SP1) machine and need to find out how much of the central processing unit (CPU) each application is using. I am familiar with task list for Windows XP, but the only task list I see on the Windows 2003 machine is a command line tool and [...]
Answer Question
| March 23, 2008 8:39 PM
CPU usage, SQL Server 2003, SQL Server performance
Having problems converting SQL Server queries to stored procedures
I am using SQL Server queries as in-script and I have now decided to use the queries as stored procedures. However, I am facing some problems while converting the SQL Server queries into stored procedures. It’s a book search functionality based on book name and author name. My Old SQL query, which I was using [...]
Answer Question
| March 22, 2008 8:38 PM
SQL Query, SQL Server, Stored Procedures
I am using SQL Server queries as in-script and I have now decided to use the queries as stored procedures. However, I am facing some problems while converting the SQL Server queries into stored procedures. It’s a book search functionality based on book name and author name. My Old SQL query, which I was using [...]
Answer Question
| March 22, 2008 8:38 PM
SQL Query, SQL Server, Stored Procedures
How do I move all stored procedures to a new SQL server?
I recently moved a database from SQL Server 2000 to a new server running SQL Server 2005. Is it possible to move all of the stored procedures to the new server?
Answer Question
| March 22, 2008 7:01 PM
SQL Server 2000, SQL Server 2005, Stored Procedures
I recently moved a database from SQL Server 2000 to a new server running SQL Server 2005. Is it possible to move all of the stored procedures to the new server?
Answer Question
| March 22, 2008 7:01 PM
SQL Server 2000, SQL Server 2005, Stored Procedures
How do I integrate SQL Server Integration Services and Blaze Advisor?
I am a Microsoft Business Intelligence (BI) Developer and currently working on a Pharmaceutical BI project. The client wants to integrate his Blaze Advisor rule engine to SQL Server Integration Services (SSIS) so that he can change the rules in Blaze Advisor any time and see the effect of it on the source data. How [...]
Answer Question
| May 28, 2008 6:58 PM
Business Intelligence, SQL Server, SQL Server integration/interoperability, SSIS
I am a Microsoft Business Intelligence (BI) Developer and currently working on a Pharmaceutical BI project. The client wants to integrate his Blaze Advisor rule engine to SQL Server Integration Services (SSIS) so that he can change the rules in Blaze Advisor any time and see the effect of it on the source data. How [...]
Answer Question
| May 28, 2008 6:58 PM
Business Intelligence, SQL Server, SQL Server integration/interoperability, SSIS
Copy a SQL Server 2005 database into a SQL Server 2000 instance?
Hi, Greg. After an upgrade from SQL Server 2000 to SQL Server 2005, the application team would now like to go back to SQL Server 2005 without data loss. We have built a new SQL Server 2000 instance for them, but now need to get the user databases copied over or restored. What is the [...]
Answer Question
| April 1, 2008 5:03 PM
Copy programs, SQL Server 2000, SQL Server 2005
Hi, Greg. After an upgrade from SQL Server 2000 to SQL Server 2005, the application team would now like to go back to SQL Server 2005 without data loss. We have built a new SQL Server 2000 instance for them, but now need to get the user databases copied over or restored. What is the [...]
Answer Question
| April 1, 2008 5:03 PM
Copy programs, SQL Server 2000, SQL Server 2005
Stored Procedure Problem
Hi Greg, I am using SQL queries as in-script and now decided to use them as stored procedure. I am facing some problem while converting them into stored procedures. It’s a book search functionality based on book name and author name. My Old SQL query, which I was using with asp. SQL = “Select * [...]
Answer Question
| March 21, 2008 3:34 PM
SQL, Stored Procedure variables, Stored Procedures
Hi Greg, I am using SQL queries as in-script and now decided to use them as stored procedure. I am facing some problem while converting them into stored procedures. It’s a book search functionality based on book name and author name. My Old SQL query, which I was using with asp. SQL = “Select * [...]
Answer Question
| March 21, 2008 3:34 PM
SQL, Stored Procedure variables, Stored Procedures
SQL Stored Procedures
I am trying to return a count value from an SQL Stored Procedure in order to test if the record exists or not. I am calling the procedure from java as follows. CREATE PROCEDURE RTVSQL (IN LEVL CHARACTER(1), IN SYLL CHARACTER(4), INOUT FOUND INTEGER(2)) LANGUAGE SQL SELECT COUNT(*) INTO FOUND FROM EPYSTSTDTA/EPBSREP WHERE BSAICD = [...]
Answer Question
| July 31, 2008 9:31 AM
SQL, Stored Procedures
I am trying to return a count value from an SQL Stored Procedure in order to test if the record exists or not. I am calling the procedure from java as follows. CREATE PROCEDURE RTVSQL (IN LEVL CHARACTER(1), IN SYLL CHARACTER(4), INOUT FOUND INTEGER(2)) LANGUAGE SQL SELECT COUNT(*) INTO FOUND FROM EPYSTSTDTA/EPBSREP WHERE BSAICD = [...]
Answer Question
| July 31, 2008 9:31 AM
SQL, Stored Procedures
LAZY WRITER Process
Hi, We have Database production server with following configuration: Model: HP DL 585 G5 RAM: 64 GB Processors: Intel Xeon (R) CPU E7320 @ 2.13 GHz (16 processors) OS: Windows 2003 Server R2, SP2 SQL Server 2005 with SP2 LAZY WRITER 16 Process is running continuously, daily we will have to restart the sql server [...]
Answer Question
| May 14, 2008 5:29 AM
Lazy Writer, SQL Server 2005, SQL Server errors
Hi, We have Database production server with following configuration: Model: HP DL 585 G5 RAM: 64 GB Processors: Intel Xeon (R) CPU E7320 @ 2.13 GHz (16 processors) OS: Windows 2003 Server R2, SP2 SQL Server 2005 with SP2 LAZY WRITER 16 Process is running continuously, daily we will have to restart the sql server [...]
Answer Question
| May 14, 2008 5:29 AM
Lazy Writer, SQL Server 2005, SQL Server errors
SUB-QUERIES
Hi, Good you give me an best real example for using the sub query, correlation of sub query & Top analysis using subqueries. Thanks in Advance……………..
Answer Question
| March 19, 2008 4:53 AM
SQL Server, Subquery
Hi, Good you give me an best real example for using the sub query, correlation of sub query & Top analysis using subqueries. Thanks in Advance……………..
Answer Question
| March 19, 2008 4:53 AM
SQL Server, Subquery
How can I restore a database from .mdf file?
How can I restore a database from .mdf file? I only have .mdf backup file.
Answer Question
| April 19, 2013 12:01 AM
SQL Server backup, SQL Server database restore
How can I restore a database from .mdf file? I only have .mdf backup file.
Answer Question
| April 19, 2013 12:01 AM
SQL Server backup, SQL Server database restore
How to create a maintenance plan in SQL Server Management Studio Express
I’m running SQL Server 2005 Workgroup edition with SP2. I’m trying to create a new Maintenance Plan in Microsoft SQL Server Management Studio Express (MSSMSE) by right clicking on the Maintenance Plans object icon. The only option is Refresh – there’s no manual method or wizard. I’m logging in as sa and my server role [...]
Answer Question
| October 21, 2009 12:00 AM
Microsoft SQL Server Management Studio, MSSMSE, SQL Server 2005, SQL Server Express Edition
I’m running SQL Server 2005 Workgroup edition with SP2. I’m trying to create a new Maintenance Plan in Microsoft SQL Server Management Studio Express (MSSMSE) by right clicking on the Maintenance Plans object icon. The only option is Refresh – there’s no manual method or wizard. I’m logging in as sa and my server role [...]
Answer Question
| October 21, 2009 12:00 AM
Microsoft SQL Server Management Studio, MSSMSE, SQL Server 2005, SQL Server Express Edition
Is there a way to create a view in Master in SQL Server 2005 that is accessible from all databases?
In SQL Server 2000, you can use a backdoor to create your own view in INFORMATION_SCHEMA… In SQL Server 2005, I get a permissions error though. Is there a way to create a view in Master in SQL Server 2005 that is accessible from all databases like the INFORMATION_SCHEMA views? Thanks…
Answer Question
| September 20, 2008 11:55 PM
INFORMATION_SCHEMA views, SQL Server 2005, SQL Server schema
In SQL Server 2000, you can use a backdoor to create your own view in INFORMATION_SCHEMA… In SQL Server 2005, I get a permissions error though. Is there a way to create a view in Master in SQL Server 2005 that is accessible from all databases like the INFORMATION_SCHEMA views? Thanks…
Answer Question
| September 20, 2008 11:55 PM
INFORMATION_SCHEMA views, SQL Server 2005, SQL Server schema
How can I set the database password by the SQL Server Enterprise Manager?
How can I set the database password by the SQL Server Enterprise Manager?
Answer Question
| March 19, 2008 11:51 PM
SQL Server Enterprise Manager, SQL Server security
How can I set the database password by the SQL Server Enterprise Manager?
Answer Question
| March 19, 2008 11:51 PM
SQL Server Enterprise Manager, SQL Server security
How do I connect SQL Server 2005(mobile edition) to Visual Studio 2005?
How do I connect SQL Server 2005(mobile edition) to Visual Studio 2005? I tried the connection but the database is not found on the server.
Answer Question
| April 28, 2011 11:49 PM
Mobile, SQL Server 2005 Mobile Edition, SQL Server integration/interoperability, Visual Studio 2005
How do I connect SQL Server 2005(mobile edition) to Visual Studio 2005? I tried the connection but the database is not found on the server.
Answer Question
| April 28, 2011 11:49 PM
Mobile, SQL Server 2005 Mobile Edition, SQL Server integration/interoperability, Visual Studio 2005
SQL Server 2005 multi-instance cluster
I need to set up a 2 node multi-instance SQL Server 2005 cluster (active/active). Since each node will failover to the other, can I use SQL Server 2005 Standard Edition on each node or do I need to use Enterprise Edition?
Answer Question
| April 13, 2010 8:04 PM
SQL Server 2005, SQL Server administration, SQL Server clustering
I need to set up a 2 node multi-instance SQL Server 2005 cluster (active/active). Since each node will failover to the other, can I use SQL Server 2005 Standard Edition on each node or do I need to use Enterprise Edition?
Answer Question
| April 13, 2010 8:04 PM
SQL Server 2005, SQL Server administration, SQL Server clustering
Learning SQL 2005/2008
I would like to start from the grounds up in learning SQL 2005 and 2008. Any recomendations? I have been working with databases for sometime now including SQL 2000, but I have not jumped to anything newer. Thanks.
Answer Question
| March 19, 2008 7:21 PM
SQL Server 2005, SQL Server 2008, SQL Server career advice
I would like to start from the grounds up in learning SQL 2005 and 2008. Any recomendations? I have been working with databases for sometime now including SQL 2000, but I have not jumped to anything newer. Thanks.
Answer Question
| March 19, 2008 7:21 PM
SQL Server 2005, SQL Server 2008, SQL Server career advice
SQL Server – I would like a stored procedure that will take the name of a table as input.
I would like a stored procedure that will take the name of a table as input. What the procedure would do is drop all indexes on that table except any index that ends with U1 or P1, and save the information on the ones it drops. Then I would like another stored procedure that takes [...]
Answer Question
| March 18, 2008 3:18 PM
SQL Server, SQL Server performance, Stored Procedures
I would like a stored procedure that will take the name of a table as input. What the procedure would do is drop all indexes on that table except any index that ends with U1 or P1, and save the information on the ones it drops. Then I would like another stored procedure that takes [...]
Answer Question
| March 18, 2008 3:18 PM
SQL Server, SQL Server performance, Stored Procedures
I am using SQL Server 2005. How can I retrieve data from live server through the Internet using VB.Net 2005?
I am using SQL Server 2005. How can I retrieve data from live server through the Internet using VB.Net 2005?
Answer Question
| March 18, 2008 3:15 PM
SQL Server 2005, VB.NET 2005, Visual Basic 2005
I am using SQL Server 2005. How can I retrieve data from live server through the Internet using VB.Net 2005?
Answer Question
| March 18, 2008 3:15 PM
SQL Server 2005, VB.NET 2005, Visual Basic 2005
