Forum Replies Created

Viewing 15 posts - 1 through 15 (of 59 total)

  • RE: Year Function returns error in subquery

    That was the problem. Thanks!

  • RE: Parse Address Column

    I was afraid of that. Thanks for your help.

  • RE: Parse Address Column

    I was able to parse everything into its own column using the comma as the delimiter and I was also able to use the select I posted earlier to get...

  • RE: Export database into Excel

    To create an SSIS project, you need to use the Business Intelligence Project type in Visual Studio. Make sure you have selected Business Intelligence Projects under project types and then...

  • RE: Export database into Excel

    Are you creating an Integration Services project in Visual Studio?

    Using SSIS you would use the Data Flow Task and then on the Data Flow tab, create an OLE DB...

  • RE: Export database into Excel

    I just want to clarify my previous post that even if the new database wasn't in SQL Server, you could still use SSIS for data transformation using the Ole DB...

  • RE: Export database into Excel

    Is the new database in SQL Server? This sounds like a job for SQL Server Integration Services (SSIS). You can export the data from both the old SQL Server database...

  • RE: Move Report Parameters

    Thanks for your reply. I was wondering about moving the parameters around because my Google searches weren't providing any solutions. Your solution will do the trick.

    Thanks!

  • RE: SQL Agent Job Fails when domain user is owner

    Hi Deepak,

    I got it to work as you mentioned by keeping the job owner sa and then giving the necessary permissions to the directories to the SQL Server Agent service...

  • RE: File System Task Variable

    Were you able to figure out what the problem is. I'm receiving the same error and my variable is a read only in the script task.

    Error: 0xC0014054 at Script Task:...

  • RE: Transaction Log Won't Shrink

    I was able to fix my problem by doing the following:

    exec sp_removedbreplication 'dbname'

    Backup the log file

    Execute DBCC SHRINKFILE

    The log_reuse_wait_desc now says 'NOTHING' and I was able to shrink the log...

  • RE: Transaction Log Won't Shrink

    Yes, I did. I don't really understand what's going on here, but I did find these posts. Although it seems that the bug they're referring to was happening in RTM...

  • RE: Transaction Log Won't Shrink

    When I execute that stored procedure, I get the following message:

    Msg 18757, Level 16, State 1, Procedure sp_repldone, Line 1

    Unable to execute procedure. The database is not published. Execute the...

  • RE: DBCC Checksum Returned Error

    Unfortunately, we do not know how long this corruption has been there or what caused it. The most recent backup that we used to restore also had corruption and we...

  • RE: DBCC Checksum Returned Error

    Hi Sugesh,

    Thanks for the reply. I noticed that I had to run dbcc checkdb with the repair options but then the db has to be put into Single User Mode....

Viewing 15 posts - 1 through 15 (of 59 total)