Topic profile page for test sql script.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: test sql script.
Started 12 hours, 10 minutes ago (2008-11-18 20:30:13)
by andy91
Hi I'm a moderate level PHP developer and I'm trying to move to asp.net for a project but finding this a very difficult and alien experience. The hole ASP.net world is so different from the traditional PHP/mysql way of doings things. My head hurts. What I want to do is generate a table dynamically in ASP.net by running an sql query and then loading the results into an array then ...
Started 16 hours, 49 minutes ago (2008-11-18 15:51:00)
by AAaron123
Thanks, I'd have to install sql express 2005 when I have already have sql server 2008. Not sure if doing that would upset sql server 2008 or vs 2008. thanks for the info "bruce barker" wrote in message news:1D6E4CAD-3A2B-4ACD-8596-23E4354F692F@microsof t.com... > unless you have the admin access to sqlserver you can...
Started 21 hours, 26 minutes ago (2008-11-18 11:14:00)
by Sakthivel Chidambaram
Hi Yoga, Since this happens only at 3 am, you can ignore the IE test incase you are not able to do it properly... Try like this... 1) Enable Execution Trace of Jobs are per below article http://www.sqlserverdba.co.cc/2008/10/troublshooti ng-sql-server-jobs.html 2) Create a batch script to copy some text file to the same network location where the backup is taken and schedule it using ...
Started 23 hours, 37 minutes ago (2008-11-18 09:03:16)
by raghav_khunger
Hi, fasterfenay Try This Create table TestCode ( ID int , CourseCode varchar ( 50 ), Expertise varchar ( 100 )) GO insert into TestCode select 1 , 'CSS-514' , 'Intro to computers' union all select 1 , 'CSS-515' , 'Networks' union all select 2 , 'CSS 234' ,...
Started 1 day, 4 hours ago (2008-11-18 04:39:00)
by aeblank
THE PROBLEM I'm running into performance issues generating and storing a randomly created graph in a SQL Server database. I have a T-SQL script that generates a graph, and then randomly connects the vertices in that graph to each other. I can see that my hard-drive is working very hard throughout the operation. The operation took about 2 hours (I just canceled it at this point, looked like...
Started 1 day, 7 hours ago (2008-11-18 01:35:16)
by albunix
Quote: Originally Posted by hyp959 Hey guys my load is always going hight when more than 50 users browsing my website. And my website can't be opened when the load average is more than 5, I have done many kind of mysql optimization and yet the load still wont go any down. Server Spec CentOS 5.2 Intel(R) Pentium(R)...
Started 1 day, 8 hours ago (2008-11-17 23:47:50)
by andy91
Hi great site! I'm currently trying to learn asp.net and c# in a visual studio 2008 environment. I come from a PHP back ground and have reached a moderate level in php, I know what I'm doing but not yet an expert. Anyway I'm finding moving from a standard HTML /CSS, PHP, mysql environment to ASP.net very difficult. I just cant get my head around the level of abstraction it trys to force ...
Started 1 day, 17 hours ago (2008-11-17 15:19:00)
by Birddog
On Nov 17, 12:23*pm, Birddog wrote: Quote: > I am having a problem with a script. *I am a amatuer at PowerShell > please drop me a life line! *The script works as designed aside from > the output. *The out put file looks like this: > > Jordan, Hal G > > TEST > Test, My > > TEST > Allen, Barry F > > TEST > > Name followed by title on a seperate...
Started 1 day, 19 hours ago (2008-11-17 12:45:00)
by Craig
Thanks! That worked! I know assigning the user to the role rpt_power user would also have worked, but I did want to assign access to all objects for DYNGRP. Thanks again! "Mariano Gomez" wrote: > Craig, > > There is certainly a quicker way. > > /*Count : 1 */ > > declare ...
Started 2 days ago (2008-11-17 08:39:00)
by sharma29
What to add header line as the first line to a file created from a sql(oracle) file. The sql file output(output.txt) is as follows; REV|23453253||TEST TEST|DUMP NE23 5SD REV|23454345|2|TEST TEST|TEST NE49 The header line I was trying to add is "3P_CREDITORS" "5" "" "31-OCT-2008" which is in another file(input file). I was trying like head -1 inputfile.dat > > output.txt understanably ...
Started 1 week ago (2008-11-11 20:26:00)
by Active Server
In the UAT Server I am receiving the following message whenever I am executing the Maintenance Plan for a full back up.The Job was successful.But still I am receiving the message,Any one Please help me to resolve this issue. Date 11/10/2008 11:31:21 AM Log SQL Agent (Current - 11/10/2008 11:31:00 AM) Message [298] SQLServer Error: 14262, The specified @job_id ('52102034-1B84-...
Started 6 days, 16 hours ago (2008-11-12 15:56:00)
by Warny
Hello, For application purpose, i have to log requests from several asp.net sites. I did create a log table in each sites databases in which i write some infos comming from the request object. Everything works well but the table are becoming really huge for wome sites. I'm trying to create a new database with one table that aim to regroup all informations coming from all sites sharing...
Started 1 week, 1 day ago (2008-11-10 20:30:00)
by JTBS
I searched for specific posts on 'one way' messages using SQL Broker and could not find related post. So I am posting new one. How I can send 'One way message' using SQL Brokre? I have a Broker queue that keeps posting timer messages to pool every few seconds. But someone has to put first START Message -so that Broker Queue calls activation stored procedure and rest is smooth....
Started 1 week ago (2008-11-11 15:06:00)
by Tom Brander
I'm looking for some "best Practice" advice. I'm a real newbie here but I have to use Views to calculate stuff that would be way worse with external queries. But I keep my development in SQL script files where I comment them and test, when I have it going I make it a view. The comments are stripped in the View source. And I'm also having a time keeping the external SQL and the view ...
