how to view the job in text in sql server 2005
- by kumar
hi,
how to view the job in text in sql server 2005?
Ex: for store procedure we use sp_helptext .is there any keyword for job in sql server 2005
regards
kumar
Search Results
Search found 5375 results on 215 pages for 'sqlserver 2005'.
Page 7/215 | < Previous Page | 3 4 5 6 7 8 9 10 11 12 13 14 | Next Page >
-
-
Differences between SSRS 2005 and 2008
- by Chenster
What the main differences between SQL Reporting Services 2005 and 2008 in terms of features? I read about 2008 has much better in scalability. How about the features? What's in SSRS 2008 but not 2005? Thanks!Read the article
-
Local help not working in Visual Studio 2005
The local help in Visual Studio 2005 never comes back with anything. Also, if I'm not connected to the Internet, of course I get nothing. When I run dexplore eventually it takes 100% of cpu. Also, the F1 help doesn't work (of course). I've repaired both VS 2005, MSDN in other orders. Any help will be appreciated! THanks -timRead the article
-
SQL Server Management Studio 2005 "Remember Password" doesn't work
- by Danimal
Folks, I connect to a large number of SQL Server 2005 databases through SQL Server Management Studio 2005. I frequently check off "Remember password", yet the next time I try to connect it doesn't actually remember it. Have you had this experience? Any workarounds?Read the article
-
How to upgrade VS2008 reporting Schema from 2005 to 2008
- by Nasser Hajloo
As you all know Visual Studio using 2005 schema to create RDLC reports. SSRS 2008 use 2008 schema to create RDL reports. So I'm looking for a solution to change VS 2005 schema to 2008 schema. How to do this. will this issue fix with installing Report Viewer 2010 or not ?Read the article
-
SQL server 2005 :Updating one record from 2 identical records
- by Shyju
I have 2 records in a table in SQL Server 2005 db which has exactly same data. I want to update one record.Is there anyway to do it?Unfortunately this table does not have an identity column and i cant use a direct update query because both will be updated since data is same.Is there anyway using rowid or something in SQL server 2005 ?Read the article
-
SQL Server 2005-data count
- by megala
hi i created project using asp.net and sql server 2005.I created table and inserted datainto sqlserver 2005. but i dont how to find the(count) number of records stored in the table.how to find this?Read the article
-
Move database from sql server 2008 to 2005
- by pencilslate
I have a database currently in SQL Server 2008 to be moved to SQL Server 2005. I would like to backup the 2008 db to a bak file and import it to 2005, but couldn't find any options in SSMS 2008 while taking backup. Has anyone had a similar need in the past? How did you manage this through?Read the article
-
run SQL Server 2005 Job from intranet page
- by Joshua Slocum
Is it possible to run a SQL Server 2005 job from an asp.net intranet page? I've been opening up SQL Server 2005 and manually running this and thought it would really be convenient if I could just click a button on a web page instead.Read the article
-
Generate XSD from 2005 SQL Server Database
- by Robert Finlayson
What is the easiest method to generate an XSD schema from a 2005 SQL Server Database? Would it be possible to generate one XSD schema for the entire Database (~100 tables)? I searched online and found a SQL example that generates one XSD for the one table: DECLARE @schema xml SET @schema = (SELECT * FROM MyTableName FOR XML AUTO, ELEMENTS,…Read the article
-
Stored procedure in scheduler , sql server 2005
- by Zerotoinfinite
Hi All, I am using Sql Server 2005. I have a stored procedure [say Sp_GetAllMaterialInfo], I want to put it in a scheduler that everyday this stored procedure execute on 2 P.M. daily. Please let me know the steps I have to follow to acheive in sql server 2005 Thanks in advanceRead the article
-
Problems loading a project in Visual Studio 2005 design view
- by Govind
Whenever I open Visual Studio 2005, it opens correctly and without any errors. But when I load my project and try opening it in the design view it does not load. Actually, I get the error "Visual Studio 2005 (not responding)." What should I do to fix this error?Read the article
-
convert xml file to sql server 2005 table?
- by subash
how to convert a xml file in to sql server 2005 table?can any one help me? do we have any query to convert xml file to sql server 2005 tableRead the article
-
SQLAuthority News – Microsoft SQL Server 2005 Service Pack 4 RTM
- by pinaldave
Service Pack 4 (SP4) for Microsoft SQL Server 2005 is now available for download. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP4 . Download Microsoft SQL Server 2005 Service Pack 4 RTM Reference: Pinal Dave (http://blog.SQLAuthority.com) Filed under: SQL, SQL…Read the article
-
SQL Server 2005 Reporting Services and the Report Viewer
- by Kendra
I am having an issue embedding my report into an aspx page. Here's my setup: 1 Server running SQL Server 2005 and SQL Server 2005 Reporting Services 1 Workstation running XP and VS 2005 The server is not on a domain. Reporting Services is a default installation. I have one report called TestMe in a folder called TestReports using a…Read the article
-
Convert query with system objects from SQL 2000 to 2005/2008
- by Dan
I have some SQL I need to get working on SQL 2005/2008. The SQL is from SQL 2000 and uses some system objects to make it work. master.dbo.spt_provider_types master.dbo.syscharsets systypes syscolumns sysobjects I know SQL 2005 does no longer use system tables and I can get the same information from views, but I am looking for a…Read the article
-
Migrating MOSS 2007 from SQL 2000 to SQL 2005 - Addendum
- by lunacrescens
This is a continuation of an earlier question I had about moving the databases for a MOSS 2007 installation from SQL 2000 to SQL 2005. Here's the URL for the original question: http://stackoverflow.com/questions/254517/migrating-moss-2007-from-sql-2000-to-sql-2005 In my test environment, I've successfully moved the databases to…Read the article
-
Question about Reporting and Data Warehousing Software bundled with SQL Server 2005
- by anonymous user
We currently use SQL Server 2005 Enterprise for our fairly large application, that has its roots in pre SQL Server 7.0. The tables are normalized and designed mainly for the application. The developers for the most part have the legacy SQL Server mindset. Only using the part of TSQL that existed back in 7.0, not using any of…Read the article
-
sqlserver.exe uses 100% CPU
- by Markus
I've created an application (asp.net) that once a day syncs an entire database through XML-files. The sync first creates an transaction and then clears the databases tables and then starts to parse and insert the new rows into the database. When all the parsing is complete it commits the transaction. This works fine on a SQL…Read the article
-
Error while configuring Sql server 2005 for full text search
- by San
I am trying to index a table for full text search on a SQL server 2005. When I select the change tracking as Automatic and click on the next button, I get the following error TITLE: Microsoft SQL Server This wizard will close because it encountered the following error: For help, click: …Read the article
-
Configuring Sql server 2005 for full text search
- by San
I am trying to index a table for full text search on a SQL server 2005. When I select the change tracking as Automatic and click on the next button, I get the following error TITLE: Microsoft SQL Server This wizard will close because it encountered the following error: For help, click: …Read the article
-
Setting collation property in the connection string to SQL Server 2005
- by user369745
I have a ASP.Net web application with connection string for SQL Server 2005 in the web.config. Data Source=ABCSERVER;Network Library=DBMSSOCN;Initial Catalog=myDataBase; User ID=myUsername;Password=myPassword; I want to specify the collation property in the web.config for different languages like…Read the article
-
SSRS 2005 tabs/newline characters display in table
- by Paul Creasey
Hi, How can i get a column in an SSRS 2005 report to render control chars like new lines and tabs? For example: SELECT VW.System_name + CHAR(13) + CHAR(9) + ' > ' + VW.PTS_NAME + CHAR(13) + CHAR(9) + CHAR(9) + ' > ' + VW.FEED_NAME as Name In SSRS (and SSMS Results to Grid Mode) table…Read the article
-
Running VSS 2005 Client on a the same server as VSS 6.0
- by Danny G
Is it possible to run client-server combination of VSS 2005 (client)/VSS 6.0 (server) on the same box?Read the article
-
SQL Server Management Studio Express 2005 has no Configuration Manager
- by brohjoe
Where is the configuration manager for SQL Express 2005? I need to configure SQL Server for TCP/IP but there is no configuration manager with the package. I see SQL Server Database Publishing Wizard, I see SQL Server Migration Assistant for Access, but no Configuration Manager. According to the…Read the article
