Viewing 15 posts - 6,931 through 6,945 (of 13,469 total)
Sorry Rob; i thought it was a low hanging fruit question....
I assumed somethign i should not have.
August 19, 2011 at 6:55 am
oops i misread the question...no i do not know of a way to get the results of a procedure call into a dynamic table, oither than what you already asked...openrowset...
August 19, 2011 at 6:39 am
i think something like this would be better than sp_msForEachDB:
I prever to generate possible statements, review and prune,a nd then run them when I'm ready
/*
USE SandBox; create master key encryption...
August 18, 2011 at 2:18 pm
ok 3 years ago i posted this forum answer on the same subject, along with vb6 source code and sample stuff to download a web page:
http://www.sqlservercentral.com/Forums/Topic453789-5-1.aspx
read the article and see...
August 18, 2011 at 12:36 pm
built in it's not possible...anything outside of a sql database requires something special.
you can do it with sp_OACreate, and get the data back in 4000 byte chunks untiol you have...
August 18, 2011 at 12:19 pm
i think this does what you wanted;
i grabbed a subquery of the items that would be marked as closed....everything else would still be open, right?
SELECT
#TestTable.ParentId,
#TestTable.ChildId,
#TestTable.RecordType,
CASE
WHEN MyCloseItems.ParentId...
August 18, 2011 at 9:42 am
@Name varchar(5000),
all your variables must be nvarchar, including the procs definition and the final resulting column;
otherwise you get an implicit converison, which changes it to quesiton marks...
August 18, 2011 at 8:10 am
that error says the table already exists in the hwdata schema.
do a quick
select * from hwdata.DesktopSoft_Master
select * from dbo.DesktopSoft_Master
decide which one to keep (say dbo was the "good one"
then...
August 18, 2011 at 7:19 am
sounds like security: remember in SQL 2008, or whenever installed on win7/server2003 and above, local admins on a box are no longer admins in SQL.
connect as sa, add your...
August 17, 2011 at 12:17 pm
if the application is logging in with a SQL login, you cannot get the NT user information.
Going forward, you'd have to change the application to start passing thru the NT...
August 17, 2011 at 11:09 am
a server side trace typically has no performance impact, unless you create a trace that is logging everything; every column and every event would probably be a bad idea.
I'm in...
August 17, 2011 at 7:43 am
msdb has some tables which contain the errors and their details.
i create a view to make them eaiser to access, i think this might help you.
i get errors like this:
...
August 17, 2011 at 5:50 am
jamesnt (8/16/2011)
We have an issue where after data entry, certain fields need to be verified. I was hoping to create a SSIS package that end users could...
August 16, 2011 at 2:01 pm
a foreign key always prevents truncation.
to do the same thing it requires two separate steps.
instead you have to delete, and then maybe reseed the identity
DELETE FROM MyTable
DBCC CHECKIDENT( [MyTable],RESEED,1) --reset...
August 16, 2011 at 1:47 pm
no...SELECT * FROM sys.objects selected from the current database.
sp_msForEachDB 'select
''?'' as DbName,
name
,object_id from ?.sys.objects
where object_id = 2073058421 '
would show you all the objects that , buy...
August 16, 2011 at 1:05 pm
Viewing 15 posts - 6,931 through 6,945 (of 13,469 total)