Change this: ''C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Diffs\''' to: ''C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Diffs\' I've removed two single quotes at the end. That tells SQL Server to add a single quote into the string.
2004-07-27
THX I have the starter kits running on my localhost, I see the code for the forgot password control, but I just get I will search more, or I will use the VWD Express 2005 beta, that ships with new cool controls for that task!THX to ALL!
2004-07-22
2 reads
I need to compare two dates in the stored procedure: one is datetime that gets value from the system by getDate() function and another is from the database.Both values have format "MMM DD YYYY HH:MM", but the system datetime gives current HH:MM, when the database values have 00:00. I don't care about time, I just […]
2004-07-15
3 reads
I'm trying to calculate a value and use that calculated value in a CASE statement without repeating it for each WHEN statement because of it's size and not wanting to cause processing to bog down. I've attemted the T-SQL below but get an error and the first inequality statement. Any help would be appreciated.SUM(CAST(ISNULL(o.Qty, 0) […]
2004-07-14
21 reads
Try these steps..1. Map the file location as a drive (like F:\folder) to the server where the sql server is running. Specifying direct server path does not work.2. Run 'dcomcnfg' exe and add in the account that SQL Server agent is running under. If it is running unde SA account, then choose 'Everyone'.Hope this helps!!!-sundar
2004-07-14
you could also try this:SELECT CAST(CONVERT(char(10), getdate(), 112) as datetime)
2004-07-13
2 reads
Couple of questions.... Why are you opening this workspace? Set mwspCalc = DBEngine.Workspaces(0) Why are you opening this database again? Why not just reuse "mdbCalc"? Set mdbExWk = CurrentDb Can you modify the SQL tables to put unique indexes on them? Then you should be able to open the tables just by using Set mrstCalc […]
2004-07-10
I have a stored procedure that is being executed constantly on the server , but is not being called from any of the asp code. I looked up this proc and found it is and undocumentated sp that will return detail information on the indexes of a table.Trace information: ( the trace shows hundreds of […]
2004-07-07
174 reads
Hi guys,Do you know where I can find some refrences for SAP IS-U running on SQLServer?I'm running for my customer (1300+ named users) the SAP core system for over 2 years already with an average dialog response time of 0.3s.Now he wants to migrate it's mainframe based billing system (2 M+ customers) to SAP IS-U. But […]
2004-07-01
3 reads
here's one i use... (just a shade faster than Julian's method ) declare @clientId int select ClientId into #ClientList from ... while 1=1 begin select @clientId = min(ClientId) from #ClientList where ClientId > isnull(@clientId, -1) if @clientId is NULL break -- some code endhowever, using a cursor is sometimes more efficient than this method because […]
2004-06-25
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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