Conversaciones de Kalman Toth
Found 20 threads
-
9 Votos
"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 ...Respondida | 40 Respuestas | 200695 Vistas | Created by Doua - lunes, 9 de marzo de 2009 16:16 | Última respuesta por Naomi N - viernes, 28 de agosto de 2020 12:56
-
0 Votos
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 ...Respondida | 6 Respuestas | 59792 Vistas | Created by gk1393 - viernes, 16 de julio de 2010 0:25 | Última respuesta por Naomi N - martes, 11 de agosto de 2020 18:32 -
0 Votos
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 ...Pregunta | 8 Respuestas | 15294 Vistas | Created by JCEH - martes, 20 de noviembre de 2012 14:39 | Última respuesta por Erland Sommarskog - viernes, 7 de agosto de 2020 20:59 -
0 Votos
Msg 7357, Level 16, State 1, Line 1 OPENROWSET
hi, please help me , when i am exe below Query its give the above error ...Respondida | 8 Respuestas | 8162 Vistas | Created by kvraodba - sábado, 8 de diciembre de 2012 2:26 | Última respuesta por MarianSosa - viernes, 31 de julio de 2020 19:36 -
0 Votos
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 ...Respondida | 10 Respuestas | 22542 Vistas | Created by matthias1989 - lunes, 5 de marzo de 2012 12:28 | Última respuesta por Jeff Moden - jueves, 30 de julio de 2020 4:19 -
16 Votos
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 ...Respondida | 32 Respuestas | 14115 Vistas | Created by Larry Weiss - martes, 13 de mayo de 2014 15:04 | Última respuesta por Naomi N - viernes, 17 de julio de 2020 13:29 -
2 Votos
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 ...Respondida | 20 Respuestas | 18178 Vistas | Created by Chakravarthy - martes, 28 de febrero de 2012 9:53 | Última respuesta por ksoft001 - viernes, 3 de julio de 2020 0:03 -
0 Votos
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 ...Respondida | 7 Respuestas | 4544 Vistas | Created by mkl69 - viernes, 7 de noviembre de 2014 22:20 | Última respuesta por sandeep2005 - miércoles, 17 de junio de 2020 10:45 -
46 Votos
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 ...Respondida | 87 Respuestas | 393508 Vistas | Created by NoEgo - lunes, 20 de febrero de 2006 23:21 | Última respuesta por scott_morris-ga - viernes, 12 de junio de 2020 14:28 -
5 Votos
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 ...Respondida | 28 Respuestas | 190323 Vistas | Created by Sandip Maniar - martes, 29 de julio de 2008 20:51 | Última respuesta por Erland Sommarskog - viernes, 8 de mayo de 2020 8:59 -
1 Votos
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 ...Respondida | 16 Respuestas | 27316 Vistas | Created by Estefanía1 - martes, 8 de abril de 2008 10:51 | Última respuesta por Shivendoo Kumar Dubey - miércoles, 1 de abril de 2020 1:12 -
2 Votos
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 ...Respuesta propuesta | 19 Respuestas | 22445 Vistas | Created by sql9 - martes, 29 de noviembre de 2011 16:40 | Última respuesta por Jeff Moden - sábado, 28 de marzo de 2020 7:22 -
8 Votos
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 ...Respondida | 9 Respuestas | 25401 Vistas | Created by KODI_KODI - domingo, 16 de diciembre de 2012 13:51 | Última respuesta por Jeff Moden - sábado, 28 de marzo de 2020 6:58 -
1 Votos
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 ...Respondida | 17 Respuestas | 21985 Vistas | Created by Kalman Toth - miércoles, 21 de marzo de 2012 14:57 | Última respuesta por Jeff Moden - sábado, 28 de marzo de 2020 6:45 -
4 Votos
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 ...Respondida | 10 Respuestas | 10517 Vistas | Created by Santhosh Aryan - viernes, 2 de septiembre de 2011 13:48 | Última respuesta por Kalman Kiss - martes, 17 de marzo de 2020 10:25 -
1 Votos
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 ...Pregunta | 3 Respuestas | 8688 Vistas | Created by Dan112233 - martes, 8 de febrero de 2011 17:29 | Última respuesta por Ian.Fuller - lunes, 9 de marzo de 2020 19:15 -
2 Votos
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 ...Respondida | 14 Respuestas | 40895 Vistas | Created by mmw_pdx - viernes, 4 de febrero de 2011 16:59 | Última respuesta por TheBrenda - viernes, 6 de marzo de 2020 17:47 -
0 Votos
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 ...Respondida | 9 Respuestas | 8270 Vistas | Created by Kalman Toth - viernes, 23 de octubre de 2009 22:41 | Última respuesta por st9912345 - miércoles, 4 de marzo de 2020 2:30 -
1 Votos
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 ...Respondida | 8 Respuestas | 2429 Vistas | Created by Operation Insanity - miércoles, 30 de julio de 2014 22:16 | Última respuesta por Alexander Dickbauer - BOS - martes, 3 de marzo de 2020 10:14 -
2 Votos
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 ...Respondida | 2 Respuestas | 8038 Vistas | Created by ShajiManj - sábado, 14 de marzo de 2009 8:57 | Última respuesta por Blakelyjoy - miércoles, 19 de febrero de 2020 6:54 - Artículos 1 a 20 de 19404 Siguiente ›
