Firele utilizatorului Kalman Toth
Found 20 threads
-
9 Voturi
"SELECT * INTO table FROM" a stored procedure? Possible?
I did a search and read a few solutions but they just don't make too much sense to me. Forgive my newbie-ness but I'm still pretty new when it comes to stored procedures. I'm still learning every ...Răspuns | 40 Mesaje | 229575 Vizualizări | Created by Doua - luni, 9 martie 2009 16:16 | Ultimul mesaj de la Naomi N - vineri, 28 august 2020 12:56
-
0 Voturi
How to change database back to NORECOVERY MODE FROM RECOVERY MODE
Hi Experts, I took full backup of "Practice" DB today at 6 PM EST and stored on D drive on the box(say box A, Practice.BAK), also I took 2 log backup at 6:30 PM & 7 PM ...Răspuns | 6 Mesaje | 70248 Vizualizări | Created by gk1393 - vineri, 16 iulie 2010 00:25 | Ultimul mesaj de la Naomi N - marți, 11 august 2020 18:32 -
0 Voturi
Update Excel spreadsheet using ACE driver (Microsoft.Ace.OLEDB.12.0) in 64bit environment.
Hi all, Well, I finally thought I'd try to ditch the dogleg through 32bit SQL Express and try to update spreadsheets (XLS) using the Microsoft.Ace.OLEDB.12.0 ...Întrebare | 8 Mesaje | 21951 Vizualizări | Created by JCEH - marți, 20 noiembrie 2012 14:39 | Ultimul mesaj de la Erland Sommarskog - vineri, 7 august 2020 20:59 -
0 Voturi
Msg 7357, Level 16, State 1, Line 1 OPENROWSET
hi, please help me , when i am exe below Query its give the above error ...Răspuns | 8 Mesaje | 12566 Vizualizări | Created by kvraodba - sâmbătă, 8 decembrie 2012 02:26 | Ultimul mesaj de la MarianSosa - vineri, 31 iulie 2020 19:36 -
0 Voturi
BULK INSERT .csv file error
hi, as my assignment I got a 32GIG .csv file, i need to get this file in sql server i use the new one 'denali'. I can't open the file cause it's so large, so i ...Răspuns | 10 Mesaje | 30619 Vizualizări | Created by matthias1989 - luni, 5 martie 2012 12:28 | Ultimul mesaj de la Jeff Moden - joi, 30 iulie 2020 04:19 -
16 Voturi
Can I use a COLLATE clause in a temp table definition?
Can someone provide an example of using a COLLATE clause when defining a temporary table? My goal is to get the temp table's definition to use the database_default value for collation so I don't ...Răspuns | 32 Mesaje | 29860 Vizualizări | Created by Larry Weiss - marți, 13 mai 2014 15:04 | Ultimul mesaj de la Naomi N - vineri, 17 iulie 2020 13:29 -
2 Voturi
How to Pivot tables in SQL 2000
Hi All, I've a query that is designed using PIVOT as discussed, http://j.mp/zV6tVa. Now this query has to be executed on SQL 2000. It is a known fact that pivot is not a ...Răspuns | 20 Mesaje | 22694 Vizualizări | Created by Chakravarthy - marți, 28 februarie 2012 09:53 | Ultimul mesaj de la ksoft001 - vineri, 3 iulie 2020 00:03 -
0 Voturi
WMI Error
Hello All, When i try to upgrade from Sql Server 2008 R2 SP2 to 2012 SP2 Everything installs fine except for the Reporting Services - Native. During the ...Răspuns | 7 Mesaje | 8030 Vizualizări | Created by mkl69 - vineri, 7 noiembrie 2014 22:20 | Ultimul mesaj de la sandeep2005 - miercuri, 17 iunie 2020 10:45 -
46 Voturi
The media set has 2 media families but only 1 are provided.
I made a backup of my database from ServerA (SQL 2000) and trying to restore it to ServerB (SQL 2005) and get this error below, even after configuring the log and data paths for the ...Răspuns | 87 Mesaje | 415899 Vizualizări | Created by NoEgo - luni, 20 februarie 2006 23:21 | Ultimul mesaj de la scott_morris-ga - vineri, 12 iunie 2020 14:28 -
5 Voturi
How to change SQL server 2008 collate after installation
Hi, On windows sever 2008 I've installed SQL server 2008 RC0. At the time of installation, I'd specified the collation as LATIN1_GENERAL_BIN, and now I want ...Răspuns | 28 Mesaje | 195452 Vizualizări | Created by Sandip Maniar - marți, 29 iulie 2008 20:51 | Ultimul mesaj de la Erland Sommarskog - vineri, 8 mai 2020 08:59 -
1 Voturi
Remote connection to Analysis Services
Open --> Analysis Services database..." I write the server name and I get the same error. Please I need your help. Do somebody know what might be ...Răspuns | 16 Mesaje | 31160 Vizualizări | Created by Estefanía1 - marți, 8 aprilie 2008 10:51 | Ultimul mesaj de la Shivendoo Kumar Dubey - miercuri, 1 aprilie 2020 01:12 -
2 Voturi
Remove 0x from binary values using t-sql
Hi All, How do I remove 0x from a binary value using t-sql. Input is 0x000000000000048B I need output to be ...Răspuns propus | 19 Mesaje | 28601 Vizualizări | Created by sql9 - marți, 29 noiembrie 2011 16:40 | Ultimul mesaj de la Jeff Moden - sâmbătă, 28 martie 2020 07:22 -
8 Voturi
DATE FORMAT MMYYYY for current date
Hi please help I need to get the current month and year Only from todays date (getdate) DATE FORMAT In MMYYYY for current date Thanks In ...Răspuns | 9 Mesaje | 31662 Vizualizări | Created by KODI_KODI - duminică, 16 decembrie 2012 13:51 | Ultimul mesaj de la Jeff Moden - sâmbătă, 28 martie 2020 06:58 -
1 Voturi
Is BULK INSERT faster than SSIS?
Quote from a recent forum thread: "On the processes i use now, im using SSIS (With the max tunning i can), but, even that way, bulk load by TSQL was extremely fast!...we load, every day, about ...Răspuns | 17 Mesaje | 26837 Vizualizări | Created by Kalman Toth - miercuri, 21 martie 2012 14:57 | Ultimul mesaj de la Jeff Moden - sâmbătă, 28 martie 2020 06:45 -
4 Voturi
Msg 8164, Level 16, State 1, Procedure sp_MSload_tmp_replication_status, Line 80 An INSERT EXEC statement cannot be nested.
I am trying to insert replication-publication status into temp table, but am facing issues. create table #1( publisher_db ...Răspuns | 10 Mesaje | 14710 Vizualizări | Created by Santhosh Aryan - vineri, 2 septembrie 2011 13:48 | Ultimul mesaj de la Kalman Kiss - marți, 17 martie 2020 10:25 -
1 Voturi
Powershell Security Issues
I'm not sure if this is the right forum for this, but I'm having a problem scripting with powershell. I'm trying to bind a SQL connection using Integrated Auth, but when I run the ...Întrebare | 3 Mesaje | 12040 Vizualizări | Created by Dan112233 - marți, 8 februarie 2011 17:29 | Ultimul mesaj de la Ian.Fuller - luni, 9 martie 2020 19:15 -
2 Voturi
BULK INSERT into "new" table possible?
Hello, I'm trying to find a way (outside of OPENROWSET) to import data into a SQL table where the source CSV file has varying column headers. Is it possible to ...Răspuns | 14 Mesaje | 52265 Vizualizări | Created by mmw_pdx - vineri, 4 februarie 2011 16:59 | Ultimul mesaj de la TheBrenda - vineri, 6 martie 2020 17:47 -
0 Voturi
SSIS 2008 - Make Selected Items (Boxes) Same Width In Control Flow & Design Flow
Make Same Size --> Width Same size as which box? When I resize the top one, select it, and select the others one by one holding down the CTRL key, it ...Răspuns | 9 Mesaje | 12232 Vizualizări | Created by Kalman Toth - vineri, 23 octombrie 2009 22:41 | Ultimul mesaj de la st9912345 - miercuri, 4 martie 2020 02:30 -
1 Voturi
How to start an sp_procoption "STARTUP" enabled Stored Procedure without restarting SQL Server?
Is there a way to "start" a stored procedure that has been configured for automatic startup via sp_procoption without having to restart SQL ...Răspuns | 8 Mesaje | 6282 Vizualizări | Created by Operation Insanity - miercuri, 30 iulie 2014 22:16 | Ultimul mesaj de la Alexander Dickbauer - BOS - marți, 3 martie 2020 10:14 -
2 Voturi
convert ANSI to unicode
Hi, I am trying to convert while uploading a text file from ANSI format text file to Unicode format text file. How can I do it in ...Răspuns | 2 Mesaje | 11993 Vizualizări | Created by ShajiManj - sâmbătă, 14 martie 2009 08:57 | Ultimul mesaj de la Blakelyjoy - miercuri, 19 februarie 2020 06:54 - Items 1 to 20 of 19401 următor ›
