Kalman Toth dizileri
Found 20 threads
-
9 Oylar
"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 ...
-
0 Oylar
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 ... -
0 Oylar
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 ...Soru | 8 Yanıtlar | 21557 Görünümler | Created by JCEH - 20 Kasım 2012 Salı 14:39 | Son Yanıt ile Erland Sommarskog - 7 Ağustos 2020 Cuma 20:59 -
0 Oylar
Msg 7357, Level 16, State 1, Line 1 OPENROWSET
hi, please help me , when i am exe below Query its give the above error ...Yanıt | 8 Yanıtlar | 12219 Görünümler | Created by kvraodba - 8 Aralık 2012 Cumartesi 02:26 | Son Yanıt ile MarianSosa - 31 Temmuz 2020 Cuma 19:36 -
0 Oylar
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 ...Yanıt | 10 Yanıtlar | 30274 Görünümler | Created by matthias1989 - 5 Mart 2012 Pazartesi 12:28 | Son Yanıt ile Jeff Moden - 30 Temmuz 2020 Perşembe 04:19 -
16 Oylar
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 ...Yanıt | 32 Yanıtlar | 28845 Görünümler | Created by Larry Weiss - 13 Mayıs 2014 Salı 15:04 | Son Yanıt ile Naomi N - 17 Temmuz 2020 Cuma 13:29 -
2 Oylar
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 ...Yanıt | 20 Yanıtlar | 22393 Görünümler | Created by Chakravarthy - 28 Şubat 2012 Salı 09:53 | Son Yanıt ile ksoft001 - 3 Temmuz 2020 Cuma 00:03 -
0 Oylar
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 ...Yanıt | 7 Yanıtlar | 7783 Görünümler | Created by mkl69 - 7 Kasım 2014 Cuma 22:20 | Son Yanıt ile sandeep2005 - 17 Haziran 2020 Çarşamba 10:45 -
46 Oylar
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 ...Yanıt | 87 Yanıtlar | 414201 Görünümler | Created by NoEgo - 20 Şubat 2006 Pazartesi 23:21 | Son Yanıt ile scott_morris-ga - 12 Haziran 2020 Cuma 14:28 -
5 Oylar
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 ...Yanıt | 28 Yanıtlar | 195129 Görünümler | Created by Sandip Maniar - 29 Temmuz 2008 Salı 20:51 | Son Yanıt ile Erland Sommarskog - 8 Mayıs 2020 Cuma 08:59 -
1 Oylar
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 ...Yanıt | 16 Yanıtlar | 30882 Görünümler | Created by Estefanía1 - 8 Nisan 2008 Salı 10:51 | Son Yanıt ile Shivendoo Kumar Dubey - 1 Nisan 2020 Çarşamba 01:12 -
2 Oylar
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 ...Önerilen Yanıt | 19 Yanıtlar | 28264 Görünümler | Created by sql9 - 29 Kasım 2011 Salı 16:40 | Son Yanıt ile Jeff Moden - 28 Mart 2020 Cumartesi 07:22 -
8 Oylar
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 ...Yanıt | 9 Yanıtlar | 31246 Görünümler | Created by KODI_KODI - 16 Aralık 2012 Pazar 13:51 | Son Yanıt ile Jeff Moden - 28 Mart 2020 Cumartesi 06:58 -
1 Oylar
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 ...Yanıt | 17 Yanıtlar | 26414 Görünümler | Created by Kalman Toth - 21 Mart 2012 Çarşamba 14:57 | Son Yanıt ile Jeff Moden - 28 Mart 2020 Cumartesi 06:45 -
4 Oylar
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 ...Yanıt | 10 Yanıtlar | 14436 Görünümler | Created by Santhosh Aryan - 2 Eylül 2011 Cuma 13:48 | Son Yanıt ile Kalman Kiss - 17 Mart 2020 Salı 10:25 -
1 Oylar
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 ...Soru | 3 Yanıtlar | 11800 Görünümler | Created by Dan112233 - 8 Şubat 2011 Salı 17:29 | Son Yanıt ile Ian.Fuller - 9 Mart 2020 Pazartesi 19:15 -
2 Oylar
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 ...Yanıt | 14 Yanıtlar | 51767 Görünümler | Created by mmw_pdx - 4 Şubat 2011 Cuma 16:59 | Son Yanıt ile TheBrenda - 6 Mart 2020 Cuma 17:47 -
0 Oylar
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 ...Yanıt | 9 Yanıtlar | 11976 Görünümler | Created by Kalman Toth - 23 Ekim 2009 Cuma 22:41 | Son Yanıt ile st9912345 - 4 Mart 2020 Çarşamba 02:30 -
1 Oylar
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 ...Yanıt | 8 Yanıtlar | 5900 Görünümler | Created by Operation Insanity - 30 Temmuz 2014 Çarşamba 22:16 | Son Yanıt ile Alexander Dickbauer - BOS - 3 Mart 2020 Salı 10:14 -
2 Oylar
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 ...Yanıt | 2 Yanıtlar | 11728 Görünümler | Created by ShajiManj - 14 Mart 2009 Cumartesi 08:57 | Son Yanıt ile Blakelyjoy - 19 Şubat 2020 Çarşamba 06:54 - Items 1 to 20 of 19401 sonraki ›
