Try coverting the text field to (N)VARCHAR (8000) this way the text field will be able to go into the variableDECLARE @VAR1 AS VARCHAR(n)SET @VAR1 = (SELECT CAST(Textfield AS VARCHAR(n)) FROM dbo.table1)Good luck
2004-05-25
Thank you, Edward, I will try to do it this way.However, I am not sure I have the same problem. I have only checked the box for "Include indexes", and not the "attempt to repair..." one. But you might be right, something is still connected to some of the databases but I don't know what (process) […]
2004-05-21
Are you able to use the maintenance plan to backup that database to a different drive on the same server?
2004-05-20
Check out http://www.sqlpass.org/community/usergroups/chapter_tour.cfm PASS is hosting some neat Reporting Services training in DC and NC
2004-05-20
i'm maintaining a sql database that i designed and built, and running an Access front end interface, also which i built. i've been doing this stuff for years, and personally, i've long thought that Access is not the ideal tool for the job. unless i'm missing something pretty significant, then it appears that Access's performance as a front-end […]
2004-05-19
586 reads
If I was to do a select statement from the [Warrants] table below off of intMasterAcctID I would get two rows returned for intMasterAcctID=1 The function basically returns the intMasterAcctID, Warrants and Warrant PercentsSo:Select * from WarrantCodesByAcct(2) returns2,'PP',100select * from WarrantCodesByAcct(1) (with 2 qualifying records)1,'PP,FA','50,50'Basic table layout w/datawarrantsintID,intMasterAcctID,intWarrantCodeID,intWarrantPerc1 1,1,1,50 2,2,1,100 3,3,1,100 4,1,2,50WarrantCodes intID,vchrCode,vchrDescription 1,'PP','Personal Property' […]
2004-04-12
That would probably be to difficult to administrate. I am thinking more in conceptual terms. By thinking of it in these terms questions could be tailored (made easier or harder). In the end all you really have is the consolation of the percentiles and maybe a new fact to add to your repertoire
2004-03-29
I'm trying to get some information about my DTS package via an activex script. I'm querying the DTS object model and have run into an issue.Here is the script:Dim oPackage 'Define a variable to hold this packages details Set oPackage=DTSGlobalVariables.Parent 'Place the active package into the variable oPackage Dim oTask 'Define a variable to hold a Task that […]
2004-03-18
Hi Gary,Thanx for the reply.Yes, a production server was backedup on Friday and restore on Saturday on the standby Server and the recovery model was full. The transaction logs were restored using the same undo file as well in sequence.Yes, I am aware about the undo file.and yes, on Saturday the server backuped up again […]
2004-03-15
Try putting this in your DTS script:http://support.microsoft.com/default.aspx?scid=kb%3BEN-US%3Bq230501&GSSNB=1HTHChris
2004-03-10
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