Changing date fields in SQL Server Analysis Services
In SQL Server Analysis Services, can I change the date fields from (yyyy-mm-dd) to (dd-mm-yyyy) without turning the date field into varchar?

Answer Question   |  July 22, 2009  6:08 PM
SQL Server Analysis Services, SSAS

SQL Server Security Login does not work after restoring database on another computer
I backup the production database on server named SQL1 then restored the database on server named SQL2. SQL server security login name “user1″ has been created on both SQL1 and SQL2 servers. When I restore the database on SQL2 I have to re-map and give db_datareader access to the “user1″ user name again. How can [...]

Answer Question   |  July 21, 2009  8:59 PM
SQL Server, SQL Server security, SQL Server Security Login

Sql Query in AS400
I am trying to execute a Query String but I receive following error Query exceeded the specified time limit or storage limit however my query length is normal, nevertheless i have executed larger query too. How to solve this problem.

Answer Question   |  July 20, 2009  7:21 AM
SQL Query, SQL query optimization

File Level Identifiers
If we save and restore SQL generated files which were created under an old OS/400 system software will the Format Level Identifier be changed and how does this affect the file?

Answer Question   |  July 12, 2011  2:08 PM
File Level Identifier, OS/400, SQL generated files

Crystal Reports in vb.net
iam getting error while making connetion to sql server by OLEDB provider. The error is Sql server does not exit or access is denied ,sqlstate 08001

Answer Question   |  July 17, 2009  12:23 PM
Crystal Reports, Crystal Reports error messages, SQL Server, SQL Server error messages, VB.NET, VB.NET 2005, VB.NET 2005 Express Edition

SQL Server 2005 Query Very Slow in the first run
Hi, I have an sql query which takes 8 seconds in the first run. The next run there after takes 0.5 seconds and all consecutive runs take 0.5 seconds. Is the plan getting cached? How do i make this query run in 0.5 second in the first run itself? Please find the query below. select [...]

Answer Question   |  July 24, 2009  10:15 AM
SQL queries, SQL query optimization, SQL Server 2005

thanks
where do I go to say a big thank you to Mrdenny. im up and running with his suggestion

Answer Question   |  September 19, 2011  1:42 AM
ITKE, SQL Server

How to select 1 record in DB2
As usual, I often use: select top 1 * from table but in DB2, I can’t. I use the Toad tool to input SQL statement. Does anyone have a solution? Please share it with me. Tkanks a lot!

Answer Question   |  April 18, 2013  5:34 PM
DB2, SELECT statement

Crystal Reports to SSRS
There is a proposal to migrate existing CR(11) application to SSRS for speed of execution as well as more flexibilty. WE have JPEG2000 images in the database and these are neither getting rendered in Crystal Reports nor in SSRS. Any suggestions on how I can make these JPEG2000 images render in the reports ? Also [...]

Answer Question   |  July 18, 2010  4:44 PM
Crystal Reports, Crystal Reports XI, SQL Server Reporting Services, SSRS

SQL server 2005 to SQL server 2008
I am following using sql server 2008 but following some lessons written by BOB Taybor. Is MyCompany.mdf for 2005 abailable in 2008 format?

Answer Question   |  July 16, 2009  4:35 PM
SQL Express, SQL Server 2005, SQL Server 2008, SQL Server Training

Error connecting to a SQL database
I receive the following errors when I attempt to connect to a SQL Server database on my home computer: 1) Keyword not supported: ‘intigreted security’? 2) An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default [...]

Answer Question   |  July 21, 2009  3:22 PM
Connection Issues, SQL Database, SQL Database Connection Issues

Free Chapter – Beginning Spatial with SQL Server 2008
Another free chapter download is available on the IT Bookworm Blog. Written by: Alastair Aitchison Book: Beginning Spatial with SQL Server 2008 Overview: “Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the shape and position of objects in space. This is an interesting and [...]

Answer Question   |  July 16, 2009  12:09 PM
Alastair Aitchison, Apress, Free Chapters, SQL Server 2008, SQL Server Spatial Data

windows Server 2003
Hi, we are in the process of developing an SQL Server-based application for the purposes of monitoring historical server performance and baseline data. Which windows Server 2003 tool and specific data-gathering option would be best suited to obtaining this information?

Answer Question   |  July 16, 2009  11:07 PM
Server Performance, SQL Server, Windows Server 2003

sql in C#
How can I attach And detach a database file to sqlserver in C# code ? please give me an example of this

Answer Question   |  July 15, 2009  3:05 PM
C#, Database Files, SQL Server database

SQL Server error: Cannot find log file
I am receiving the error, “cannot find log file.” I detach the database and I am unable to reattach it because of the error. I created a new database and copied the MDF. When I restarted the SQL Server, I am told the database is suspect. What can I do to fix this error?

Answer Question   |  July 15, 2009  2:52 PM
MDF, SQL Server database, SQL Server error messages, SQL Server errors, SQL Server logs

search Button In vb.net 2005
The code is for searching entire sql database if i enter RegistrationNo which is primary key plz help.iam getting errors. If IsNull(TextBox1) Then MsgBox “Please Enter the RegistrationNo” End If If IsNull(Me.TextBox1) = False Then Me.Recordset.FindFirst “RegistrationNo= ‘” & Me.TextBox1.Text & “‘” Me!TextBox1 = Null If Me.Recordset.NoMatch Then MsgBox “RegistrationNo Not Found”, vbOKOnly + vbInformation, [...]

Answer Question   |  July 15, 2009  12:24 PM
SQL Database, VB.NET, VB.NET 2005

Default value of a Indicator data type
Hi, can you please temme, what is the default value of a Indicator data type (N) which is declared with ‘INZ’?

Answer Question   |  July 15, 2009  7:47 AM
Data Types, RPG, RPG/400

select parent where more than one child
I want to select a row from the parent table based on whether there are two or more rows in a child table. What is the best way to do that?

Answer Question   |  September 2, 2011  1:01 AM
SELECT statement, SQL, SQL queries

Variables in T-SQL
Hi, I want to know y does the following script run in SQL and not in T-SQL DECLARE @tblName varchar(30) SET @tblName = CONVERT(VARCHAR(20),GETDATE(),112) + ‘Table’ DECLARE @sql nvarchar(4000) SELECT @sql = ‘CREATE TABLE “‘ + @tblName + ‘” ( ID VARCHAR(15), Name VARCHAR(15) )’ EXEC(@sql) go it gives you the error Msg 170, Sev [...]

Answer Question   |  July 15, 2009  12:33 PM
SQL, T-SQL

SAP Implementation
Has SAP been iimplemented in Shipping Company? Who are the implementation partners. Is SAP ecc 6.0 ideal on oracle DB or SQL DB.?

Answer Question   |  July 15, 2009  6:04 AM
Oracle interoperability, SAP implementation, SAP interoperability, SQL Server interoperability