No announcements
-
0 VotesPOSTING TIPS - Code, Images, Hyperlinks, Details
When you're posting a question - please search the forum first! If that fails, and you wish to include T-SQL, C#, or VB code in your post, see below. If you want to show us what you see on ...
-
0 Votes
SQL Server 2012 Express edition
Hello All , I have SQL Server 2012 Express Edition (64-bit) with RTM version in my Server , i wanted to apply SP4 on it. My question is that do we have ...Answered | 2 Replies | 37 Views | Created by Chetan Vishwakarma - 1 hour 35 minutes ago | Last reply by Chetan Vishwakarma - 1 hour 17 minutes ago -
0 Votes
finding overlapping schedule in a table
Hi, I am new in SQL developing and have a question to find overlapping schedule based on Startdate/EventStatus/FunctionRoom/StartTime and End ...Unanswered | 2 Replies | 69 Views | Created by VENKAT YADAV - Tuesday, August 20, 2019 11:54 AM | Last reply by Viorel_ - Tuesday, August 20, 2019 1:52 PM -
1 Votes
migrate 1 TB database
How to migrate 1 TB database from one server to another with minimal or no downtime KiranProposed | 9 Replies | 133 Views | Created by juniorkiran - Monday, August 19, 2019 12:01 PM | Last reply by Dedmon Dai - Tuesday, August 20, 2019 9:19 AM -
0 Votes
How to Upload SQL Data Files to a Server
I have used my FTP tool to upload my php and sql data files to a server. The SQL database is basically a folder and in that folder is a single table that I use in my ...Unanswered | 3 Replies | 183 Views | Created by Mike Smith 2222 - Saturday, August 17, 2019 3:51 AM | Last reply by Jefferson Silva DBA - Monday, August 19, 2019 1:49 PM -
5 Votes
Problems with SQL Server 2012 Express Edition
When I installed Visual Studio Express 2012, I didn't have SP1 for Windows 7 installed. (This was the first version of VS which I tried installing). I do not remember if I received an ...Answered | 14 Replies | 4552 Views | Created by TemiU - Sunday, July 14, 2013 9:26 AM | Last reply by scott_morris-ga - Monday, August 19, 2019 11:58 AM -
0 Votes
SQL Jobs failed SQLState = 28000 NativeError = 18452
Hi All, Good Day!!!, Issue is when run the sql job from query its failed. Infra Brief SQL Ver: SQL Server 2017, OS : ...Unanswered | 4 Replies | 324 Views | Created by kesa_kara - Monday, August 5, 2019 7:38 AM | Last reply by kesa_kara - Monday, August 19, 2019 9:31 AM -
0 Votes
Update Single row which is latest row by ID
i have Stored Procedure which get table type, name varchar(50) last name (varchar(50) key varchar(50) and Sql Table with the same ...Unanswered | 2 Replies | 313 Views | Created by want 2 Learn - Wednesday, July 24, 2019 6:29 AM | Last reply by José Diz - Saturday, August 17, 2019 10:30 PM -
0 Votes
SQL Server Linked Server Windows Authentication Login
Trying to create a linked server connections from SQL2017 (server A) to SQL2017(server B).DB1.dbo.vwXYZ. Was looking at this article, but, the Windows Authentication Login did not ...Proposed | 5 Replies | 308 Views | Created by Ami2013 - Friday, August 9, 2019 8:30 PM | Last reply by Ami2013 - Friday, August 16, 2019 8:59 PM -
0 Votes
create view on linked server
I'm trying to create a view on a remote server with data from a local one. After doing some research, I found the "execute at". which I thought might be the answer. I run this from my local ...Unanswered | 10 Replies | 201 Views | Created by FLSojourner - Thursday, August 15, 2019 1:31 PM | Last reply by Olaf Helper - Friday, August 16, 2019 3:42 PM -
0 Votes
Keep Variable where another has multiple records
Hi, I have a variable called 'New_ID'. I need to bring back this variable where another variable 'UID' has more than one record linked to ...Proposed | 4 Replies | 188 Views | Created by Bone_12 - Wednesday, August 14, 2019 1:17 PM | Last reply by Cathy Ji - Friday, August 16, 2019 9:33 AM -
0 Votes
Test datasets for SQL Server Management Studio
Hello - I'm trying to dust off my SQL programming and analysis skills. Are there free datasets I can download and use for this purpose? Thanks.Proposed | 3 Replies | 171 Views | Created by johnwedeles - Thursday, August 15, 2019 6:41 PM | Last reply by Olaf Helper - Friday, August 16, 2019 5:35 AM -
1 Votes
View restrictions -permissions
Hi Team, I have to restrict the view permissions for two groups- consider the scenario. a)Can you share if you have the script to deny view ...Proposed | 9 Replies | 426 Views | Created by S_NO - Friday, August 2, 2019 9:32 AM | Last reply by Dedmon Dai - Thursday, August 15, 2019 5:23 AM -
0 Votes
How to fix timeout problem
I had to reinstall Windows 10 and, of course, SQL SERVER EXPRESS. I accepted all the default options when doing the reinstall. However, now when I try to run my applications develope4d in ...Answered | 4 Replies | 435 Views | Created by RogerSSB - Saturday, August 3, 2019 1:47 AM | Last reply by RogerSSB - Tuesday, August 13, 2019 5:11 PM -
0 Votes
Too Many Rows In Select Query
I copied this query from MS Access and was able to clean it up in SQL. The table tblFactReferrals has multiple records for each patient. Each patient usually has about 4 records with the same referral ...Proposed | 2 Replies | 206 Views | Created by ArtsNew - Monday, August 12, 2019 11:38 AM | Last reply by José Diz - Monday, August 12, 2019 3:12 PM -
2 Votes
SQL 2016 Licensing Server + CAL
Hi guys, Hey guys, i'm setting up a new SQL server, which will be licensed in the Server + CAL model. There will be an application server accessed by approximately 50 people through ...Proposed | 3 Replies | 260 Views | Created by KingstoneOchieng - Wednesday, August 7, 2019 6:35 PM | Last reply by Cathy Ji - Monday, August 12, 2019 8:29 AM -
0 Votes
first time opening sql server
I have tried without success at filling in the "connect to server" screen, "Server name" Field I am using the latest version (2018) also using windows ...Proposed | 3 Replies | 266 Views | Created by Robert Lassman - Thursday, August 8, 2019 6:31 AM | Last reply by Cathy Ji - Monday, August 12, 2019 8:29 AM -
0 Votes
Use Backup of Specific Table(s) using GUI
Hello, Is it possible to make a backup of a database by select specific table(s) using GUI? What I mean GUI is that to use drop and click and only using mouse ...Proposed | 4 Replies | 190 Views | Created by Sakura Data - Friday, August 9, 2019 8:45 AM | Last reply by Cathy Ji - Monday, August 12, 2019 7:39 AM -
0 Votes
Warning !Add an implementation of GetObjectData to type 'My_VersesDataSet' What should I do?
I have 5 warnings when I start the project. The lines are in the file that should not be edited. How do I clear this warning? TEHProposed | 3 Replies | 1352 Views | Created by Rocky48 - Sunday, August 11, 2019 5:03 PM | Last reply by Dedmon Dai - Monday, August 12, 2019 7:30 AM -
0 Votes
How to restrict internet on sql server and only allow to take backup to azure storage.
Hello, Is there any way to take backup to azure storage from on premises sql server with out opening to whole internet. I mean can i restrict connectivity to ...Proposed | 3 Replies | 250 Views | Created by Phaneendra Kalapatapu - Friday, August 9, 2019 10:08 AM | Last reply by pituach - Sunday, August 11, 2019 10:21 AM -
0 Votes
Publishing a database project from Visual Studio 2017
I am trying to understand how the Publisher works, so that I can understand whats going wrong. The project published OK and I installed on another PC, it installed the SQL server ...Unanswered | 5 Replies | 518 Views | Created by Rocky48 - Friday, July 26, 2019 7:27 PM | Last reply by Rocky48 - Friday, August 9, 2019 3:31 PM - Items 1 to 20 of 21396 Next ›
No announcements
