Search results for query: *

Hi, I copied one of my dbs using the method of copying the actual data files. It works gret, exept that i can't delete the old data from the new db. I get an error that looks something like this: "DELETE statement conflicted with the COLUMN REFERENCE constraint..." How can I fix this...

Hi, how can one access rows from a query from within the stored procedure?? The query is a dynamic one (because the DB-name is dynamic). This does'nt apparently work: declare @Var cursor for execute sp_executesql @sql open... Like this (working version) for the static query: declare @Var...

HI! I recently got this idea to start programming graphics. It's just a hobby, but it's really fun. I made some really basic stuff in OpenGL and some in DirectX. Any thoughts on which one I should start using? All comments appreciated! //adek

Hi ! I have the following situation: I have a table in which I specify a given DB. The table of the DB is known. I need to select info from that DB and table from inside a stored procedure. Follow? Like this: select * from @OtherDB.dbo.Table where Col = @Parameter The problem is that I get...

HI! How can I make the nice little plan i have in Visio to an actual db?? I have Visio 2002 Pro, do I need an udate, or something?

Hello! What do I need to extract a db plan so that it gets created in a db in Visio 2002 Pro?? Do I need the Enterprise package, or??

Hi! Can anyone with visio enterprise generate a script for database export from one of my visio files? Or is it that way it works? Anyway, if there is a possibility of you exporting for me, than it would be great... I have visio 2002 pro, so the db export function is not available... Leave...

Hi! Can I export my database model from Visio Pro 2002 to MS SQL Srv and if so, then how? Thanks!