2019-04-15 (first published: 2009-10-27)
14,390 reads
Enhancement
RE: SQL Server Restore
Hi again... Now it'sServer: Msg 3206, Level 16, State 1, Line 1 No entry in sysdevices for backup device 'f:\cp.bak'. Update sysdevices and rerun statement. Server: Msg 3013, Level 16, State 1, Line 1 VERIFY DATABASE is terminating abnormally. The backup is NOT from that server... undestand ?
2005-03-14
RE: String Tokening
Not aware of a function, per se but you could try thisSELECT CASE WHEN PATINDEX('%[^0-9]%',[Input])>0 THEN LEFT([Input],PATINDEX('%[^0-9]%',[Input])-1) ELSE [Input] END
2005-03-14
2005-03-14
Disappearing distribution job
I am copying all data from a production database to a development counterpart (both SQL Server 7) weekly by means of snapshot replication, but I am mystified by the repeated disappearance of the distribution job. I use the Enterprise Manager wizard to create the push subscription on Friday, creating a distribution job in the SQL Server […]
2004-09-08
RE: Database recovery
Hi James,what do you mean with the database is corrupted ? What error does it give. Can you access the database ?If the status of the database is loading, check your settings in BackupExec. I know that older versions did leave the database in that status in order to restore Tlog backups. If you don't […]
2004-09-07
RE: Passing variables
Hi Lane,Please check the length of the datatype you have used in ur stored proc(sp). I assume u have used varchar as ur datatype. If u have not given any length than it will take the first character of the string that u have passed as a parameter to u r sp.by the way please […]
2004-05-21
Error of no mapping between account names and security IDs was done
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-04-15
RE: SQL Server Scheduled Job - Status: Failed - Unable to determine ...
I am using the domain administrator account for the SQL agent startup as indicated on services...I have also verified that the administrator account has the owner role given to it under the roles section of this particular database in Enterprise Management Console...This user account has full rights to the \\backupserver\share\path that I wish to back up […]
2004-04-12
RE: Execute an Oracle 9i PL/SQL from SQL SERVER 2000 PL
How i can have this? do have any example about extend stored procedure?I'm not an expert in sql server, i'm expert oracle
2004-03-11
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers