A mapped drive is only available to the user who creates it. SQL Server runs under the system account and the mapping is not recognised by the system account(unless it is a share). UNC means the fully qualified path i.e. \\servername\drive_letter$\directory Can you try the below sqlmaint -D Database -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "\\servername\I$\DIRECTORY" […]
2004-06-30
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-08
2004-03-19
I was hoping that someone could help me figure out the appropriate query for the following situation. I have two tables, in two different datbases. For each row in table A, I need to replace a value in table A with the a value from a corresponding row in table B. There is a one-to-one key mapping between […]
2004-02-26
1 reads
create function fn_reverse (@strin varchar(4000)) returns varchar(4000) as begin declare @return varchar(4000) declare @ascii smallint, @numeric bit, @space smallint, @start smallint declare @i smallint, @j smallint select @i = 1, @start = 1 while @i <= len(@strin) begin set @ascii = ascii(substring(@strin, @i, 1)) if @ascii >= 48 and @ascii <= 57 --number […]
2004-02-24
Frank,Don't be so quick to give up on the data layer. I had a similar challenge... I've posted ALL the code including the example data and table creation. The actual code that does the work you are looking for is very short. If you don't need the delimiter, set the delimiter to '' and you'll […]
2004-02-16
You could try http://www.sqlserver-performance.com http://www.sqlteam.com
2004-02-14
Try setting SET NOCOUNT OFF in the stored procedure. I have had sp's return nothing because I did not set nocount to off.
2004-01-14
Not much other than failure error as shown below. I won't be back in my office til Monday so I'm not being rude by not replying... I really do appreciated your help on this. 2003-11-20 12:30:08.15 backup Database differential changes backed up: Database: TCPrd, creation date(time): 2003/06/24(07:38:28), pages dumped: 14395, first LSN: 16318:876:5, last LSN: […]
2003-11-20
1 reads
That is correct - I ran into that problem also a while back (no sp_executesql inside a function). Kind of an obstacle. Perhaps you can build the SQL like 'SELECT ' + @theField + ': + CONVERT( VARCHAR(50), ' + @theField + ' ) FROM ' + @theTable + ' WHERE ' + @theCondition Good […]
2003-09-02
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers