Viewing 15 posts - 1 through 15 (of 19 total)
I have the code in an SQL file.
We don't use source safe for SQL and do not have a build server.
March 16, 2016 at 2:27 am
Obtianing the script for creating the stored procedures is not the problem creating stored procedures unattended is.
March 16, 2016 at 2:26 am
ok so far this is what I have done
I've created a stored proc that will return 3 results sets.
Next I will call it from SSIS using a script control.
As far...
October 23, 2015 at 9:39 pm
Yes.
If i replace the top n with select * and leave the rest of the script the same I get a lot of records back.
The error exist only if i...
July 27, 2014 at 4:52 am
it's not a syntax or case error.
I dont' change the top select part of the statement.
I simply comment out the last table and the statement works.
As soon as i include...
July 24, 2014 at 5:39 pm
I'm calling the data through linked tables from SQL2008.
The method 'rownum' is not a SQL term.
If you try to use it in a select statement of data on SQL2008 to...
July 24, 2014 at 5:37 pm
Yeah it sees the SQL data templates are there for 2012 in
Data tools but to get the templates for SQL2012 you need to go into VS2010 and go to...
February 16, 2013 at 1:29 am
it's a shared server. I login to our database as a dbo through windows authentication
although i can't backup and restore to the servers backup folder I can...
May 21, 2010 at 5:51 pm
The error is "Cannot access the specified path on the server" when trying to set the backup file location.
When attempting a restore the same error occurs.
There must be some...
May 19, 2010 at 5:32 pm
Sanoj,
I used your script to return the FK which return [FK_tblProgFundingYearCategory_tblProgFundingCategory]
My new alter statement was then
ALTER TABLE [dbo].[tblProgFundingYearCategory] NOCHECK CONSTRAINT [FK_tblProgFundingYearCategory_tblProgFundingCategory]
after i ran
truncate table [dbo].[tblProgFundingCategory]
it i got...
September 30, 2009 at 5:16 pm
Yes i ran into all sort of issues with permission. I was reading, writing and deleting files in the operating system and at one point it even complain that...
August 16, 2009 at 9:18 pm
No ..it's not the results order that is the issue.
The list a paramater for the report. Users use it to select a suburb to filter the report on.
In design...
April 30, 2009 at 8:39 pm
Sorry I just noticed my embeded xml didn't get through so the message become nonsense.
Here is the story
I have a web services which returns data and stores it in an...
April 14, 2009 at 5:45 pm
do you mean db_dtsadmin role as i can't find a db_ssisadmin role
the db_dtsadmin is a default role
where can i find db_ssisadmin I score a blank on books online...is it...
April 9, 2009 at 1:06 am
No i have't yet. I ran into other issues
My package needs to read wsdl files and saves the web services data temporarily to a xml file.
I started getting access denied...
April 8, 2009 at 3:43 am
Viewing 15 posts - 1 through 15 (of 19 total)