SSRS 2000 Support Ending Date
Is there a data set when SSRS 2000 will no longer be supported?
Answer Question
| June 16, 2009 4:03 PM
SQL Server Reporting Services, SSRS, SSRS 2000, SSRS Support
Is there a data set when SSRS 2000 will no longer be supported?
Answer Question
| June 16, 2009 4:03 PM
SQL Server Reporting Services, SSRS, SSRS 2000, SSRS Support
Connecting to a SQL Server 2005 database through LAN
I am trying to connect to my SQL server 2005 database on my server. I open SQL server 2005 management studio and try to set the server name to IPADDRESSSERVER3 (the name of the server) but this doesnt work. I have also tried with connection strings in VB and these dont work either
Answer Question
| March 5, 2011 9:06 AM
SQL Database, SQL Server 2005, SQL Server 2005 connectivity, SQL Server Management Studio 2005
I am trying to connect to my SQL server 2005 database on my server. I open SQL server 2005 management studio and try to set the server name to IPADDRESSSERVER3 (the name of the server) but this doesnt work. I have also tried with connection strings in VB and these dont work either
Answer Question
| March 5, 2011 9:06 AM
SQL Database, SQL Server 2005, SQL Server 2005 connectivity, SQL Server Management Studio 2005
Replacement of CROSS APPLY statement
1. I am running query in which cross apply operator is used 2. That same query exceutes more than 10 times 3. Due to cross apply it increase the time to excute the report
Answer Question
| July 8, 2009 8:12 AM
CROSS APPLY statement, SQL Server 2005, SQL Server 2005 connectivity
1. I am running query in which cross apply operator is used 2. That same query exceutes more than 10 times 3. Due to cross apply it increase the time to excute the report
Answer Question
| July 8, 2009 8:12 AM
CROSS APPLY statement, SQL Server 2005, SQL Server 2005 connectivity
How to use an form field in a SQL from a combobox
I build an Ms-access application. In a form i selet project information based on project-nr. In that form I want to select in a combox records that are based on the project selected in the form. I think somethink like [forms]![<formname>]![<fieldname>] but it doesn’t work. what is the correct syntax to refer to a field [...]
Answer Question
| June 12, 2009 5:45 PM
Access 2003, Microsoft Access, SQL Forms
I build an Ms-access application. In a form i selet project information based on project-nr. In that form I want to select in a combox records that are based on the project selected in the form. I think somethink like [forms]![<formname>]![<fieldname>] but it doesn’t work. what is the correct syntax to refer to a field [...]
Answer Question
| June 12, 2009 5:45 PM
Access 2003, Microsoft Access, SQL Forms
Moving .MDF files from SQL Server 2000 to 2005
Is it possible to just copy and paste .MDF files from SQL Server 2000 to 2005 instead of going through the whole migration process? My company doesn’t have the time that a full migration requires, so we are thinking about just keeping the files and pasting them once we have SQL Server 2005 installed. Will [...]
Answer Question
| June 14, 2009 4:49 PM
.MDF files, SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server 2005 migration
Is it possible to just copy and paste .MDF files from SQL Server 2000 to 2005 instead of going through the whole migration process? My company doesn’t have the time that a full migration requires, so we are thinking about just keeping the files and pasting them once we have SQL Server 2005 installed. Will [...]
Answer Question
| June 14, 2009 4:49 PM
.MDF files, SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server 2005 migration
Running Crystal Reports with a SQL Server Login instead of a Network Login
I’m trying to run a Crystal Report using Crystal Runtime but I’m getting a “Logon Failed. Details: [Database Vendor Code: 18456]” After running a SQL Trace, I think I have found why. It appears as though it depends on how the user is logged on to the network as to whether or not they are [...]
Answer Question
| November 5, 2011 4:46 PM
Crystal Reports, Crystal Reports error messages, Crystal Runtime, SQL Server
I’m trying to run a Crystal Report using Crystal Runtime but I’m getting a “Logon Failed. Details: [Database Vendor Code: 18456]” After running a SQL Trace, I think I have found why. It appears as though it depends on how the user is logged on to the network as to whether or not they are [...]
Answer Question
| November 5, 2011 4:46 PM
Crystal Reports, Crystal Reports error messages, Crystal Runtime, SQL Server
Changing UNC paths
I have 138 rows of Universal Naming Convention (UNC) paths. Part of each path is constant and part is a variable. How do I change the constant portion of the UNC path and keep the variable intact? For example: •serverpathdir1dir11 •serverpathdir2 •serverpathdir3dir31 constant part “serverpath”
Answer Question
| June 16, 2009 4:26 PM
SQL Server, UNC, UNC path
I have 138 rows of Universal Naming Convention (UNC) paths. Part of each path is constant and part is a variable. How do I change the constant portion of the UNC path and keep the variable intact? For example: •serverpathdir1dir11 •serverpathdir2 •serverpathdir3dir31 constant part “serverpath”
Answer Question
| June 16, 2009 4:26 PM
SQL Server, UNC, UNC path
DTS Package completes successfully but doesn’t run batch file
I have a DTS package that creates and XML file and then FTP’s that file to a location. I run the package manually and it works fine. I’ve created a job for it, run the job and it completes successfully, but go to look and the ftp from the batch file doesn’t run. Obviously a [...]
Answer Question
| June 12, 2009 3:22 PM
Batch files, DTS Package Errors, DTS packages
I have a DTS package that creates and XML file and then FTP’s that file to a location. I run the package manually and it works fine. I’ve created a job for it, run the job and it completes successfully, but go to look and the ftp from the batch file doesn’t run. Obviously a [...]
Answer Question
| June 12, 2009 3:22 PM
Batch files, DTS Package Errors, DTS packages
Create a Stored Procedure using CL and RPGLE programs
I have an RPGLE program called from a CL program for database files overrides. I want to call the same programs from a stored prodecure on SQL Server from within a Web application. I am brand new to SQL Server but am pretty good on the AS400.
Answer Question
| August 26, 2009 3:17 PM
CL, CL Program, RPGLE, RPGLE Program, Stored Procedures
I have an RPGLE program called from a CL program for database files overrides. I want to call the same programs from a stored prodecure on SQL Server from within a Web application. I am brand new to SQL Server but am pretty good on the AS400.
Answer Question
| August 26, 2009 3:17 PM
CL, CL Program, RPGLE, RPGLE Program, Stored Procedures
How to automatically update Child Table with Insert Trigger and Table-UDF
I have SQL Server 2008 and Visual Studio 2008 and am trying to automatically insert new records into a child table based on new inserts into its parent table. I know that this should be simple: via an insert trigger. However, the complexity is that the new records into the child table need to be [...]
Answer Question
| June 12, 2009 3:14 PM
SQL Server 2008, SQL Server triggers, T-SQL 2008, UDF, Visual Studio 2008
I have SQL Server 2008 and Visual Studio 2008 and am trying to automatically insert new records into a child table based on new inserts into its parent table. I know that this should be simple: via an insert trigger. However, the complexity is that the new records into the child table need to be [...]
Answer Question
| June 12, 2009 3:14 PM
SQL Server 2008, SQL Server triggers, T-SQL 2008, UDF, Visual Studio 2008
ssrs interview questions and answers
ssrs interview questions and answers
Answer Question
| May 19, 2011 2:43 PM
Careers, SSRS, SSRS Careers
ssrs interview questions and answers
Answer Question
| May 19, 2011 2:43 PM
Careers, SSRS, SSRS Careers
FirstIAM page of a table in SQL Server 2005
Hi, Can you please explain how is the “FirstIAM page of a table” is calculated in the sysindex view, in SQL server 2005. Is is stored in some system table or is it calculated every time a table is accessed? Pardon me if this sounds to be a stupid question.I am new to SQL server [...]
Answer Question
| June 14, 2009 2:22 PM
SQL Server 2005, SQL Server tables
Hi, Can you please explain how is the “FirstIAM page of a table” is calculated in the sysindex view, in SQL server 2005. Is is stored in some system table or is it calculated every time a table is accessed? Pardon me if this sounds to be a stupid question.I am new to SQL server [...]
Answer Question
| June 14, 2009 2:22 PM
SQL Server 2005, SQL Server tables
SQL Server connectivity on V3R7 AS/400 server
Hello All, Can any tell me all the steps to coneect Sql Server to V3R7 version of AS/400. Thanks in advance.
Answer Question
| June 12, 2009 6:53 AM
AS/400 interoperability, SQL Server connectivity, SQL Server interoperability, V3R7
Hello All, Can any tell me all the steps to coneect Sql Server to V3R7 version of AS/400. Thanks in advance.
Answer Question
| June 12, 2009 6:53 AM
AS/400 interoperability, SQL Server connectivity, SQL Server interoperability, V3R7
SSRS Excel Reports
Hi, I have exported my ssrs report to excel.Everything seems to be fine regarding the alginment of columns etc. However, additional row or two appears colored below the complete table of the report. Can u please help me on removing this??
Answer Question
| June 17, 2009 5:18 AM
Microsoft Excel, SQL Server Reporting Services, SSRS 2005
Hi, I have exported my ssrs report to excel.Everything seems to be fine regarding the alginment of columns etc. However, additional row or two appears colored below the complete table of the report. Can u please help me on removing this??
Answer Question
| June 17, 2009 5:18 AM
Microsoft Excel, SQL Server Reporting Services, SSRS 2005
System hangout
I have client working on a HCL pc with 2GBram core2 processor he is working on SQL server the problem is that the performance goes down in the evening and hangoff and he even could not open his network drive can any one you could suggest some solution for this problem
Answer Question
| June 10, 2009 1:11 PM
HCL, SQL Server performance, SQL Server performance tuning
I have client working on a HCL pc with 2GBram core2 processor he is working on SQL server the problem is that the performance goes down in the evening and hangoff and he even could not open his network drive can any one you could suggest some solution for this problem
Answer Question
| June 10, 2009 1:11 PM
HCL, SQL Server performance, SQL Server performance tuning
Export SSRS Report to Microsoft Excel
Hi, I am a beginner in SSRS. Please guide me to export SSRS report i.e. .rdl report to an excel sheet.
Answer Question
| June 10, 2009 4:19 AM
Microsoft Excel import/export, SQL Server Reporting Services, SSRS
Hi, I am a beginner in SSRS. Please guide me to export SSRS report i.e. .rdl report to an excel sheet.
Answer Question
| June 10, 2009 4:19 AM
Microsoft Excel import/export, SQL Server Reporting Services, SSRS
Concatenation
I am using “substring(concat(’00′….” within my SQL select for a date query. However, the date 10 and higher is being overridden with “0″. How do I prevent this from happening?
Answer Question
| June 10, 2009 6:55 PM
Concatenate, SQL Query, SQL Select, Substring
I am using “substring(concat(’00′….” within my SQL select for a date query. However, the date 10 and higher is being overridden with “0″. How do I prevent this from happening?
Answer Question
| June 10, 2009 6:55 PM
Concatenate, SQL Query, SQL Select, Substring
SQL Server Management Studio
SQL Server management studio will no longer run on my client PC. It ran fine for about 12 months, but now warns with: Evaluation Period has expired….. I am only running the mgmt piece only. How do I get this ability back on my pc?
Answer Question
| June 10, 2009 5:23 PM
SQL Server administration, SQL Server Management Studio
SQL Server management studio will no longer run on my client PC. It ran fine for about 12 months, but now warns with: Evaluation Period has expired….. I am only running the mgmt piece only. How do I get this ability back on my pc?
Answer Question
| June 10, 2009 5:23 PM
SQL Server administration, SQL Server Management Studio
How do you add Name and mail to Address fields to a grouped report.
How do you add Name and Address fields to the body of a Grouped table report?
Answer Question
| June 8, 2009 2:53 PM
SQL Server Reporting Services, SSRS 2005
How do you add Name and Address fields to the body of a Grouped table report?
Answer Question
| June 8, 2009 2:53 PM
SQL Server Reporting Services, SSRS 2005
Transact SQL stored executed from AS/400 CL program.
How can I execute a Transact SQL stored procedure (actually in the database) on a SQL 2000 database from an AS/400 CL program.
Answer Question
| June 10, 2009 2:39 PM
554 transaction failure, AS/400, CL Program, SQL Database, SQL Server 2000, T-SQL Stored Procedures
How can I execute a Transact SQL stored procedure (actually in the database) on a SQL 2000 database from an AS/400 CL program.
Answer Question
| June 10, 2009 2:39 PM
554 transaction failure, AS/400, CL Program, SQL Database, SQL Server 2000, T-SQL Stored Procedures
