Viewing 15 posts - 946 through 960 (of 1,231 total)
Lookup SQL Server Agent jobs in books online. It is fairly intuitive to do what you are requiring.
For database mail you need to create a profile or use a...
July 24, 2014 at 6:20 pm
If I run this
declare @salesperson table(pid int,name nvarchar(10),sales int)
insert into @salesperson
values (1,'gary',0),(2,'sam',0)
declare @salesHeader table(id int,pid int, sdate date,amt int)
insert into @salesHeader
values
(2,1,'2014-04-21',130),(1,1,'2014-05-29',100), (4,2,'2014-04-14 ',40), (3,2,'2014-05-29 ',90)
select * from @salesHeader...
July 24, 2014 at 6:04 pm
It doesn't seem to update the results the right way, at least from my understanding..
I get results as
pidnamesales
1gary 100 ...
July 24, 2014 at 5:54 pm
Have a look at this:
http://msdn.microsoft.com/en-us/library/ms187569(v=sql.105).aspx
Have you had a chance to configure distributed ad hoc queries to see if this helps?
July 22, 2014 at 2:38 pm
I did find something interesting on Books Online regarding CHECKDB : Just wanted to note here >
"databases that are created on SQL Server 2005 and later should never contain...
July 22, 2014 at 2:34 pm
Its possible, dont know if it will happen as we dont have DDL definitions and data here, for the two queries two produce the same execution plan on SQL Server....
July 22, 2014 at 2:07 pm
Are your reports calling stored procedures or using embedded SQL? Are there lots of joins in the code? Is all the data on the same machine?
If the sole purpose of...
July 22, 2014 at 1:42 pm
I've run dbcc checkdb(MyData) but that said 0 errors found 0 errors repaired.
Did you disconnect all users/connections from the database first?
http://msdn.microsoft.com/en-us/library/ms345598(v=sql.105).aspx
I imagine there are sections that dbcc...
July 22, 2014 at 1:06 pm
Out of curiosity why are you using subreports?
It could be he had these already existing and wanted to re use them.
Did you ever find a solution to this problem that...
July 22, 2014 at 12:34 pm
Because the data types in Excel do not fit snugly with those of SSIS. Also you have a General type (text) and can represent a number as well as a...
July 18, 2014 at 4:38 pm
The below might help:
Books online mentions the proc as "Returns aggregate performance statistics for cached stored procedures" Caching in RAM is a free for all thus anything in there would...
July 16, 2014 at 6:46 pm
I have seen older systems store all data as characters. In your initial ETL to the SQL Server I would encourage proper conversions (make date fields DATE or DATETIME2(n) ,...
July 16, 2014 at 6:29 pm
when i use the query in source as sql statement i can preview the list
Do you mean you can see the data in the preview of the data flow's source...
July 16, 2014 at 6:09 pm
Wont that just email the data from textboxes on the report - rather than a fuller underlying dataset?
Not sure what you mean here. Wouldn't you use a table or...
July 15, 2014 at 8:43 pm
Can you try doing this with Internet Explorer? Does this make a difference?
July 15, 2014 at 8:35 pm
Viewing 15 posts - 946 through 960 (of 1,231 total)