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 express lost sa password
Hi, We have a SQL Express server that we have lost the SA password, how can I reset the password or create a new sysadmin account ...Unanswered | 1 Replies | 30 Views | Created by Andreas2012- - 1 hour 40 minutes ago | Last reply by Olaf Helper - 58 minutes ago -
1 Votes
Can SQL Express 2008 R2 interact with SQL 2008 Standard Edition?
I/Net Seven is a building automation software in which standalone instances at different facilities maintain databases of their own passwords & trends, not much else, on SQL Express 2008 ...Proposed | 6 Replies | 203 Views | Created by phleezy - Wednesday, October 2, 2019 11:38 PM | Last reply by Dedmon Dai - 4 hours 52 minutes ago -
0 Votes
Function ran
I am using the below code to generate random values, however everytime i execute this code in function it generates only 2 char length data, I want it to generate at least 10char ...Unanswered | 7 Replies | 91 Views | Created by Neilcse - 18 hours 25 minutes ago | Last reply by SQLZealots - 7 hours 2 minutes ago -
0 Votes
Trying to always use DATETIME for specified time but changing date
Hello: I am trying to define a variable in SQL that the time always begins at '00:00:00.0000' but the date changes to whatever is needed So I have the following.. ...Proposed | 4 Replies | 74 Views | Created by runatyr - 18 hours 23 minutes ago | Last reply by Viorel_ - 7 hours 55 minutes ago -
0 Votes
sqlcmd -v parameter does not seem to be working on Linux
I've installed sqlcmd on a Linux server: /opt/mssql-tools/bin/sqlcmd -? Microsoft (R) SQL Server Command Line ...Proposed | 5 Replies | 148 Views | Created by JonJ Silver - Friday, October 4, 2019 5:06 PM | Last reply by José Diz - 22 hours 19 minutes ago -
0 Votes
Need to run XP_CMDSHELL via SQL agent job
Hi I need to move files from folder 1,Audit1 to folder 2 ,Audit1 using a SQL AGENT JOB the script is listed just ...Answered | 4 Replies | 215 Views | Created by chinna738 - Wednesday, October 2, 2019 11:31 PM | Last reply by chinna738 - Monday, October 7, 2019 9:33 AM -
0 Votes
How to link Access Front Ends to SQL Server tables
Just starting to explore using SQL Server for Access back end databases After much trial and many errors I am able to import Access tables into SQL Express 2017 from Access back end ...Proposed | 4 Replies | 153 Views | Created by BVitter - Thursday, October 3, 2019 3:14 PM | Last reply by pituach - Friday, October 4, 2019 5:04 PM -
0 Votes
How to limit number of maintenance file backups?
I'm creating a nightly "Database Maintenance" backup with Type=SQL Server Integration Services Package. The backup file name has a YYYYMMDDHHMM appended and any previous file was not ...Answered | 2 Replies | 107 Views | Created by Charlie2 - Friday, October 4, 2019 2:44 PM | Last reply by Charlie2 - Friday, October 4, 2019 4:10 PM -
1 Votes
SQL Backup Package 50% complete
There is a scheduled differential backup on our SQL server that runs every day. The backup job is supposed to back up each database and to store the backup files on the server. When ...Proposed | 5 Replies | 171 Views | Created by islandpelican - Thursday, October 3, 2019 2:36 PM | Last reply by TiborK - Friday, October 4, 2019 12:54 PM -
1 Votes
New to SQL server
I am new to deployment of a system. So there are few questions about SQL server from me. 1. Is it correct for me if I just install SQL server on window os for deployment? (I know ...Answered | 5 Replies | 394 Views | Created by Pin tech - Wednesday, October 2, 2019 8:14 AM | Last reply by Erland Sommarskog - Wednesday, October 2, 2019 9:26 PM -
3 Votes
Removing spaces between words in sql
I guess there is no built in functions to do this but I have a function that replaces anything that is not A-Z with a space and returns @data. What I additionally need the function to do is ...Answered | 4 Replies | 67651 Views | Created by whatawildridethisis - Tuesday, March 20, 2007 4:45 PM | Last reply by SevG - Wednesday, October 2, 2019 12:45 PM -
0 Votes
SQL to Excel
Hi, I need to do the following but not sure if it's possible in SQL and if it is, how I would go about doing it if anyone is able to help at all ...Proposed | 2 Replies | 149 Views | Created by Bone_12 - Wednesday, October 2, 2019 8:37 AM | Last reply by Uri Dimant - Wednesday, October 2, 2019 10:52 AM -
0 Votes
SQL Server login from client with server name extremely slow since ~September 25, 2019
Until last week I was able to access my SQLServer Express 2019 using the SQL autentification and the SERVER NAME. Suddenly the performance was extremely slow. Contacting the SQL Server from a Client ...Proposed | 2 Replies | 160 Views | Created by harald_kle - Tuesday, October 1, 2019 5:21 PM | Last reply by Dedmon Dai - Wednesday, October 2, 2019 8:38 AM -
0 Votes
Does admin need the license CAL for himself?
When purchasing SQL Server 2017 Standard No Open Government + 5 CAL licenses, does the server administrator (i.e. the one who installs and connects others to the database), but e.g. does ...Proposed | 2 Replies | 119 Views | Created by Eve36 - Wednesday, October 2, 2019 7:31 AM | Last reply by Dedmon Dai - Wednesday, October 2, 2019 8:34 AM -
0 Votes
While installing MS Sql server 2012 it hang at checking for update for long time
I have problem installing of ms sql server 2012 on my windows 8.1 64 bit processor.Proposed | 3 Replies | 160 Views | Created by Neeta Kadam - Tuesday, October 1, 2019 1:26 PM | Last reply by Dedmon Dai - Wednesday, October 2, 2019 6:47 AM -
0 Votes
How to retrieve master key with TDE enabled?
Is it possible to retrieve the master key (password) if TDE is enabled? Can I decrypt without the master key and then re-encrypt again?Proposed | 1 Replies | 172 Views | Created by Charlie2 - Tuesday, October 1, 2019 2:39 PM | Last reply by pituach - Wednesday, October 2, 2019 2:21 AM -
1 Votes
Do you want to be acknowledged as Microsoft SQL Server Guru? Submit your work to Oct 2019 competition!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. This is ... -
0 Votes
Question of delete statement
Hello experts, We have a database of size 100 GB. We have 1 table in specific which is of size 12 GB. We have a requirement where we purge data once in a week on ...Unanswered | 4 Replies | 241 Views | Created by Stu Nume - Monday, September 30, 2019 5:50 AM | Last reply by TiborK - Tuesday, October 1, 2019 10:32 AM -
0 Votes
Difference between WITH REPLACE and WITHOUT in restore
I am confused with Replace option Let's say I have Database A with 100 records I want to restore a backup of a database B with 500 records on Database ...Proposed | 3 Replies | 234 Views | Created by johnrp88 - Monday, September 30, 2019 7:09 PM | Last reply by Dedmon Dai - Tuesday, October 1, 2019 8:43 AM -
1 Votes
Is SQL Right For Me?
I've written several desktop apps that I use on my work laptop, personal PC, etc. I've used Access as a DB. I'm looking for a free DB solution so I'm not tied to Access (when my work ...Proposed | 3 Replies | 268 Views | Created by dcgall12529 - Tuesday, September 24, 2019 1:55 PM | Last reply by Jeff07 - Monday, September 30, 2019 3:39 PM - Items 1 to 20 of 21471 Next ›
No announcements
