Viewing 15 posts - 2,656 through 2,670 (of 3,738 total)
Your Data File still does not much your Table definition or contain the delimiters specified in your BULK INSERT Command.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2011 at 9:26 pm
Could you please post the DDL, INSERTS for Test Data, etc.
Check out the first link.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2011 at 9:09 pm
You have one column of data in your file but you have two columns in your table.
Refer to the follow URL on the BULK INSERT Command.
http://msdn.microsoft.com/en-us/library/ms188365.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2011 at 9:02 pm
sql2k8 (7/16/2011)
i have a table called Table a
CREATE TABLE [dbo].[TableA](
[ServerName] [varchar](100) NULL,
[DatabaseName] [varchar](100) NULL,
[LogicalFileName] [sysname] NOT NULL,
[PhysicalFileName] [nvarchar](520) NULL,
[FileSizeMB] [money] NULL,
[FreeSpaceMB] [money] NULL,
[UsedSpaceMB] [money] NULL,
[FreeSpacePct] [varchar](7) NULL,
[FileSizeGB] [money] NULL,
[FreeSpaceGB] [money]...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2011 at 8:45 pm
You are going to have to GRANT EXEC Permissions to the User Account that you are Executing the Stored Procedure from.
http://sqlblog.com/forums/thread/12431.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2011 at 6:37 pm
This post was initially created over 3 years ago. 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2011 at 12:49 pm
Jamie Thomson (7/17/2011)
Welsh Corgi (7/17/2011)
Did you by chance try her site?
I'm a fella, by the way.
opps. Sorry.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2011 at 11:56 am
What error are you getting?
Can you execute it interactively?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2011 at 10:36 am
What do you mean when you attempt to create a query? Could you be more specific on what you are doing that generates the error?
That is a .NET error.:-D
I would...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2011 at 10:26 am
opc.three (7/17/2011)
Seriously though,...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2011 at 9:51 am
I clicked on the link to the blog. It maxed out my PC to 100%.
After cliking on the link it started several Internet Explorer Processes. I tried to kill...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2011 at 5:06 am
Jamie Thomson (7/14/2011)
Koen Verbeeck (7/14/2011)
The most impressive feature for me is the whole new project deployment model with parameters (already present in CTP1). This revolutionizes the way we work with...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 16, 2011 at 8:50 pm
What is in the 240,000 row? Bad Data...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 16, 2011 at 8:20 pm
sqlnaive (7/14/2011)
Fellas
I did not know that everyone on this forum was a fellow? :hehe:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 16, 2011 at 8:00 pm
Why are you using the naming convention "tbl" as a prefix?
I don't know how many records you have in your table table you may want to reconsider the use of...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 16, 2011 at 7:41 pm
Viewing 15 posts - 2,656 through 2,670 (of 3,738 total)