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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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