Questions tagged as 'sql-server'

Tagged questions
1
answer

SqlConnection failed in C #

SqlConnection ABC = new SqlConnection( "Data Source=(local);Initial Catalog=Database1;Integrated Security=SSPI"); SqlCommand command = new SqlCommand(); SqlDataReader dataRead; I'm using this code to make a save button on...
asked by 27.04.2016 / 16:49
1
answer

How to restrict the manipulation time of a table?

I would like to know a way to create a trigger in sql-server to restrict the manipulation time of a table between two business hours (8:00 am to 6:00 p.m.).     
asked by 18.09.2015 / 04:15
1
answer

Bug script to delete the entire SQL SERVER database

I have the following script to drop EVERYTHING from the database, but in one of the database I have the processing that needs this script a bug happens, for some reason it can not run the first time I run, but in second wheel without any hindran...
asked by 19.12.2016 / 16:54
0
answers

How to monitor the progress of an INSERT VB.NET query?

I am storing files in a SQL server database using a varbinary (max) field. I would like to know if it is possible to detect the progress of the file upload (which in this case would be an INSERT in the table) using VB.NET. If progress can...
asked by 10.03.2016 / 22:50
2
answers

Stored Procedure for inserting log data

I need to create a Stored Procedure in my SQL Server database. The purpose of this Stored Procedure is to write data to a Log table, which has three fields: date, time, login ID. Date and time would be the time of login, while the Login ID co...
asked by 29.02.2016 / 13:14
1
answer

Migrating Microsoft SQL to Postgres

I need to migrate my SQL database to Postgre-SQL, but I do not have much intimacy with the database itself. Is there any tool that can help with migration? I have backup of generated MS SQL .bak is it possible to convert it? Thankful!     
asked by 07.10.2015 / 20:43
1
answer

SQL Server - How to guarantee permission from SELECT to View without giving permission in the base tables?

I need help with a problem involving permissioning objects in the database. I have the following scenario: 1 Database 4 Schemes with the following owners: schemaA ; owner dbo schemaB ; owner ownerX schemaC ; ow...
asked by 05.07.2016 / 15:06
0
answers

How to Merge Cell in Reporting Services

Hello Everyone, I need a help with a situation in Reporting Services. I need to merge cells into data in Reporting Services as shown in the image below, ie in image 1 is my current scenario and in image 2 is the scenario that I ne...
asked by 18.06.2016 / 00:21
1
answer

Problems with select in multiple tables

I'm trying to do the conversion from a select sql server to the Dapper, as it was too big, I'm wanting to make it leaner and readable ... But this error appearing in some parts SELECT email.assunto [Assunto], disp.cod_disparador [Dispa...
asked by 19.09.2016 / 17:46
0
answers

Connection problem with .mdf database [closed]

I'm having a hard time connecting my C # (Windows Forms ) application with a database with .MDF already inserted into the project folder . On the course computer it worked normally, however at home I already put the name of the insta...
asked by 23.05.2015 / 03:42