Viewing 15 posts - 1 through 15 (of 28 total)
and when I put backonline get this error: Unable to open the physical file "J: filename Operating system error 5: "5(Access is denied.)".
December 14, 2023 at 9:30 pm
resore fixed it and I strted again moving files to new location:
USE master; --do this all from the master
ALTER DATABASE fuu MODIFY FILE (name='fuu',filename='J:\Data\fuu.mdf'); --Filename is new location
ALTER DATABASE fuu...
December 14, 2023 at 9:01 pm
i just did restore database with lates backup waiting for restore
December 14, 2023 at 8:17 pm
Thank you I get 11-12-2023 format, I need 11/12/2023
December 7, 2023 at 7:48 pm
Thank you
@JDate is getdate, i dont need that I have j_date that contains data, so pretty much this field j_date need format as mm/dd/yyyy
December 7, 2023 at 6:40 pm
I change drive and code and it is working now
EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT * FROM table1 " queryout G:\Backup\Test.txt -t"|" -c -T '
I need to know how to add headers...
December 5, 2023 at 2:07 pm
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Unable to open BCP host data-file
NULL
December 5, 2023 at 1:55 pm
i used this code:
EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT * FROM dbo.CustomerInformation " queryout C:\Data\Objects.txt -t"|" -c -T ' and it is not working
December 4, 2023 at 8:28 pm
(1) Is SQL indicating that it's short of memory?
No(2) How large are your databases?
806315 MB total size for all databases
(3) How many simultaneous users do you typically have? over 2000
Thank...
August 22, 2023 at 2:48 pm
Uninitialized subscription showing in my replication job,how can I fix it?
October 11, 2022 at 9:40 am
I go to properties of replication and get this:
SQL Server is unable to connect to server 'servername'.
------------------------------
===================================
SQL Server replication requires the actual server name to...
October 10, 2022 at 11:46 am
Thank you, I am concert about both and was looking for good articles
October 6, 2022 at 7:08 pm
Viewing 15 posts - 1 through 15 (of 28 total)