Search results for query: *

Thanks a lot for both answers. But issue was completely different. I still am not sure why error was pointing like backup cannot open device 'F:\SQLBACKUP\NBABackup\NBA_backup_2010_02_01_013001_9161301.bak' but after little more investigation I figure out that on my developer system I do not...

Hello! Is SQL Server 2008 backup on 64bit system possible to restore on Sql Server 2008 32bit. I think I read documentation that it is possible but earlier today I was getting error telling me that can not restore this is original error message I got. TITLE: Microsoft SQL Server Management...

Hello! I am running Windows Server 2003 Service pack 2 and it is installed as workgroup. Recently I started noticing strange behaving when I open explorer. When it is opened and clicked on a folder it takes few seconds to open it. Sometimes I have to click couple times on a folder till it gets...

In your connection string you can set Connection TimeOut=0; it should work.

I’d like to take one of MCTS: Microsoft Visual Studio and Microsoft .NET Framework technologies test. Does anyone know any good online school where I can learn and do exercise and eventually fill comfortable to take exam?

Hello! I am pretty new to this and strugling with basic stuff. Here is my problme. I have this XML document <?xml version="1.0"?> <?xml-stylesheet type="text/xsl" href="books.xsl"?> <!DOCTYPE BOOKS[ <!ELEMENT BOOKS (BOOK+)> <!ELEMENT BOOK (TITLE+,AUTHOR+,PUBLISHED+,DESCRIPTION*)> <!ELEMENT...

Hello, Is there anyone to help me out with simple but yet unsolved problem I got into? I tried to experiment with Crystal Reports 12.0.02 version by downloading trial for 30 days. Created simple report and then added that report to my Visual Studio project. Compiled VS project and placed it...

For couple years I’ve been creating applications using .NET to automatically import data from certain Web site into DB tables for statistical purposes. I usually did it using WebRequest and WebResponse objects to get those data in text format and with some logic extracting information I need...

Did you try to specify colum names you would like to populate in a list box. For example insted using this statement select * from Workstation_Bios_Information WHERE SystemModel IS NOT NULL ORDER BY SystemName ASC try this select distinct colum_name1, colum_name2 from...

This is what I am getting when trying to connect to olap database from an asp page: ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed. /Olap/Default.asp, line 4 This is peace of code I want to connect to: <Language=VBScript> <% set cn =...

Here is what you might use. #tbl temp. table is just your table from database so I just simulated by example and populated some data into that table. #tbl1 is temp. table you use in you query to get ranks. It looks like this: =================== --This table should be table name from your...

I am not sure if I fully understand you questions. But here is something you might want to try. I created two temp. tables and populated with some data and then created query which might be helpful for you. =============================== create Table #table_a(id integer, ss integer )...

You might want to use IsNull() function ........ declare @chPre as varchar(10) declare @int as integer set @chPre = 't' --null set @int = null select Isnull(@chPRe, 'P'), isnull(@int, 0)

Ok here is question, I have created procedure to check for ~ character in customers name and if there is one than take it out and flip last part of the name to the front. Should look like this, if name is in table like 'Ruzic~Predrag' procedure should return 'Predrag Ruzic' (character ~ is...