Viewing 15 posts - 766 through 780 (of 2,647 total)
You're going to need to paste the code you are using and a sample file. Something is probably wrong with the file. Is it uniformly formatted?
Jared
CE - Microsoft
June 6, 2012 at 11:35 am
When you assign a domain account to the service through SQL Server Configuration Manager or during installation, it grants the user the proper permissions by assigning it to a "virtual...
Jared
CE - Microsoft
June 6, 2012 at 11:29 am
Try highlighting just that select statement and running it. Does it run or do you get the syntax error? If it gives the error, copy and paste only...
Jared
CE - Microsoft
June 6, 2012 at 10:05 am
Ok, let's start with...
1. Why is this "delete from FicheirosImportar where sessaoinicio <> sessaofim and sessaoinicio <> 'T'" in the cursor?
2. @codrf should be varchar(5), not varchar(10)
But, your...
Jared
CE - Microsoft
June 6, 2012 at 7:41 am
What query is timing out? For example, are you trying to do this all at once or one table at a time? If it is only 1 table, how...
Jared
CE - Microsoft
June 5, 2012 at 1:21 pm
From BOL:
BULK INSERT can import data from a disk (including network, floppy disk, hard disk, and so on).
http://msdn.microsoft.com/en-us/library/ms188365.aspx
Jared
CE - Microsoft
June 5, 2012 at 12:45 pm
guerillaunit (6/5/2012)
Hi Sergei, I tested my data sources on my Reporting Service intranet and the tests were all successful. Any other idea on what might be causing this?
You still...
Jared
CE - Microsoft
June 5, 2012 at 11:52 am
DBA_SQL (6/5/2012)
Ya I just did that...but does the bcp won't take the files from network location..
I'm sorry, I don't understand the question.
Jared
CE - Microsoft
June 5, 2012 at 11:48 am
Daxesh Patel (6/5/2012)
Maybe you should read up on SQL Server Agent Alerts so you can see what they can do?
Here's a sample: http://msdn.microsoft.com/en-us/library/ms186385.aspx
Yes there are capabilities to setup...
Jared
CE - Microsoft
June 5, 2012 at 11:24 am
guerillaunit (6/5/2012)
What are you referring to by "solution"?
Sorry... It would be the Project in BIDS (Visual Studio for SSRS).
Jared
CE - Microsoft
June 5, 2012 at 11:21 am
Do you have 1 solution, or many that are used for creating all of these reports in BIDS?
Jared
CE - Microsoft
June 5, 2012 at 11:13 am
Gans (6/5/2012)
===================================
Exception has been thrown by the target of an invocation. (mscorlib)
------------------------------
Program Location:
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type,...
Jared
CE - Microsoft
June 5, 2012 at 10:58 am
Daxesh Patel (6/5/2012)
To know % free space we need to find something ouside of sql like perfmon, psinfo, wmi...
Jared
CE - Microsoft
June 5, 2012 at 10:55 am
bubby (6/5/2012)
Thanks,Bubby
Not trying to be a jerk, but in the future please restate the subject or question in the post instead of leaving it to the subject?
Jared
CE - Microsoft
June 5, 2012 at 10:51 am
Viewing 15 posts - 766 through 780 (of 2,647 total)