Go Premium for a chance to win a PS4. Enter to Win

x

Microsoft SQL Server 2005

71K

Solutions

25K

Contributors

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Share tech news, updates, or what's on your mind.

Sign up to Post

hi experts
I have a server that is already making the backup and I want to save it somewhere else (Shared Path), it is understood that I should create a folder and give the permissions to (NT SERVICE \ MSSQLSERVER), but it does not take it, because that I must be on my own PC or server, in these cases as it is done, since it is understood that the backup of the database must not be on the same server.
0
[Webinar] Cloud and Mobile-First Strategy
LVL 11
[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Hi Experts,

I have this bit of code:
Declare @NotUsedDays as int 
Set @NotUsedDays = 120

SELECT Distinct 
Name,
Path,
Convert(Date, [LastUsedDate], 120) as LastUseDate,
NotUsedsince=DATEDIFF(DD,LastUsedDate,GETDATE()),
Statuskey

  FROM [LSV].[BISL_SSRSLog].catalog C

  JOIN (

                SELECT ReportID,LastUsedDate= MAX(timestart), StatusKey 

                     FROM [LSV].[BISL_SSRSLog].[ExecutionLog]

                       WHERE RegionName = 'Region that is in charge of SharePoint'

                       and ReportLocation = 'Location'

                       and Environment = 'Production'

                       and SPVersion = 2013

                       and (DateKey like '2016%' Or Datekey like '%2017%')
					    and [USERNAME] Not In ('bah1', 'bah2')


                 GROUP BY ReportID, StatusKey

          ) E

       --ON C.ItemID = E.ReportID

       ON C.ReportID = E.ReportID

 WHERE DATEDIFF(DD,LastUsedDate,GETDATE()) >= @NotUsedDays And StatusKey <> 34 -- 34 = Non existing reports??? 

 ORDER BY NotUsedsince desc

Open in new window


As you can see I am guessing that 34 means the reports are not available out on the share.  I am also guessing that column "Statuskey" is the correct column?

As a result I get reports that are no longer available (they have been deleted)

I want only reports that are available to come up in the query.

Thank You,
0
Last weekend we moved our SQL Server from one server (Windows 2003, SQL 2005) to a new server (Windows 2012, SQL 2012) and copied over all the users and roles to the new server. The Migration went rather smoothly and the users are able to use the database without problem however all the notifications that come from that server are no longer sent. The accounts are still there the Jobs are still there and running without problem but the notifications are not going out. I have checked the SQL Agent and emailing is enabled and I can send out emails to my email from Database Email yet no notifications are sent.

What could be the issue? No firewall is on and the Exchange server it not rejecting the emails eventhough they are being sent from DB Mail. I Don't know where else to look.
0
I have a table having varbinary column which is primary key.
Whle trying to retrieve the data as below gives 0 result:

Select count(*) from Trn_Account where cast(TransID as varchar(20)) = '3038D'

below query gives me 1 result:
Select * from Trn_Account where  TransID=  cast('3038D' as varbinary(20))

Below is my table structure:
Trn_Account:

TransID      varbinary      no      20                            no      no      no      NULL
TDate      datetime      no      8                            no      (n/a)      (n/a)      NULL
TrnsNo      numeric      no      9      18      0      no      (n/a)      (n/a)      NULL


Please help.
0
Can anyone give me step-by-step instructions on how to just get this task to successfully execute my stored procedure.  The error messages are getting worse
  • "Value does not fall within the expected range.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly"
  • "The query failed to parse. Attempted to read or write protected memory. This is often an indication that other memory is corrupt."
  • "The EXEC SQL construct or statement is not supported."

At this point, I'd just like to get the stored procedure working.  All it's doing is having a parameter string value passed into it from a user defined variable in the package and then assigning a value to the SP output parameter which then gets assigned to a different package user variable.

My environment:  Windows 7 Professional, SQL Server/Visual Studio 2005

Any suggestions?
0
Hi,

I have some users in my company that access our Production SQL instance via SSMS. I would like to know if there a way to block all domain users from using SQL Management Studio, except domain admin, as domain admin has 'sysadmin' rights.

We have software that utilizing Integrated Security.  I would still like our users to be able to utilizing our software using the SQL Windows authenticate, but not able to logon via SSMS.

Thanks!!
0
Hi,

I'm using SSRS designing a report which will show
two different dates only at any one time
comparing activity type and customer engagement.

so like this:

Activity Type           Date1                 Date2
Running                   100                    150
Cycling                      200                    150

Currently I hold these three values in a table and I use SSRS matrix to display these values like the above.
I am trying to figure out how I can add details against each of the dates to show a % difference on activity week over week.
I'm thinking perhaps this can't be done using SSRS matrix?
Maybe  I need to hard code the design and "calculation" column?

What I would like this to look like is
Activity Type           Date1                 Date2         %Diff
Running                   100                    150               + 50%
Cycling                      200                    150              - 25%

Can anyone give me some guidance on this. I have spent time looking online, but I'm not seeing anything that is working for me.
Thank you in advance
P
0
Error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Verified that all services were started.
Named pipes were enabled.
TCPIP were allowed.
0

Microsoft SQL Server 2005

71K

Solutions

25K

Contributors

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.