View Full Version : sql server answers


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 [15] 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

  1. Problem with connection String for remote mssql Server
  2. performance tuning of stored procedure
  3. Store unicode
  4. Performance : Stored Pocedure taking more parameters
  5. Using SQL Scripts at runtime
  6. Split multirow resultset to single row, multicolumn resultset
  7. to generate all the dates for a given month and year..
  8. connecting to analysis server
  9. Retrieving data from database and displaying it in text box
  10. Help Using DTS to import multiple tables into Access Database
  11. Group By Problem
  12. Referencing a field in another table as part of a formula in a computed column
  13. VarChar being truncated.
  14. SQL division of cumulative totals on one select statement
  15. Want the number that passed the first time.
  16. SUM function adding two fields in one table
  17. Merge data in SQL Server databases
  18. PLS-00201 Error
  19. Excel Query to SQL Server and data type manipulation on SELECT
  20. stuck again, if else after where clause
  21. importing a database into ms sql server
  22. SQL Server Problem
  23. Update Status Field after Expiry Date
  24. Bulk insert error -- "Unknown version of format file"
  25. aggregation or what?
  26. SQL 2005 automatically partitioning?
  27. Full outer join issue
  28. SQLAgent 2005 SP1 failed to run .bat file.
  29. synchronize the database
  30. urgent deadlock problem on Sql Server 2000
  31. Trigger to update a master table
  32. Converting string to unicode string in T-SQL
  33. what are isolation levels in sqlserver
  34. hi
  35. How can I join your Group
  36. store and retrive audio file from/in database
  37. Concurrency Issue
  38. DB Maintenance Plan SQL 2005 on 6300+ Database
  39. Transfer data using SSIS
  40. how to update two table writing only one query?
  41. directly deleting sql view
  42. Crystal Report sub-report expert advice needed.
  43. newb - mutiple-column join
  44. Group SQL Select Statement
  45. Indexes on SQL Server 7.0
  46. Syntax error in the proximity of GO
  47. views not updateable
  48. Service Broker with offline application
  49. error connecting to sql server 2005 from a small c++ program
  50. Online Connection between Access and SQL Server
  51. SQL stored procedure returns duplicates
  52. dbmail failing
  53. bi-directional mirroring
  54. Attaching data at differnet levels in a heirchy
  55. I hate MS Management Studio Tabs, IS IT THAT HARD to fix.
  56. maximum from columns
  57. sql server
  58. Can I Use If Condition In View
  59. xml into mssql 2000
  60. Clarification on Joins
  61. Database table data modifications with PK/FK relationship
  62. help with parameter in WHERE
  63. cascading parameters in sql server 2005 reporting services
  64. Table name starting with prefix tbl
  65. Remove spaces in a column
  66. Senior Database Administrator, Toronto, Canada
  67. install SS 2005 on win2k3 ENT or STD, which is better??
  68. Using count() across multiple tables
  69. delete syntax
  70. Accessing external data from SQL Server
  71. sql server 2000 remotely
  72. Comparing two databases
  73. Converting Rows to Columns
  74. Converting Rows to Columns
  75. Mentored Learning
  76. XML, schema collection and "large value types out of row" problem
  77. shows all the months in the result
  78. Server is not responding.
  79. Sub-Query / Cross Join / or something else?
  80. Complete Newbie Help
  81. Procedure
  82. max no of rows which can be updated in a table which is replicated ?
  83. Multiple db query call from within different context into #temp table
  84. How to debug sql programme
  85. Quick SQL Select Statement ?
  86. Data Feed / Make / Model Catalog
  87. Help needed creating select statement
  88. user defined type as a primary key
  89. which is the role with minimum permissions including a one to execute jobs.
  90. Database error
  91. help to store audio file in database
  92. nulls
  93. Which is fater to search NUMERIC or ALPHABET
  94. SQLServer Login as sa vs dbo
  95. Access 2k adp
  96. Append Query from Access to SQL Server
  97. Date query help
  98. Connecting PHP to MSSQL 2000?
  99. MSSQLSERVER trying to load deleted extended procedure
  100. Help with Select and IN
  101. Inserting foreign keys
  102. C# to SQL Recursive CTE Translation help
  103. I cannot view table content in MS SQL Server Express
  104. Updating 2 tables
  105. Europe syntax for desimal
  106. Updating two different dbs once with same data
  107. Transaction not rolling back
  108. How to create a .BAK file
  109. SQL query in an ASPX "Expressions Web" page to a database (beginner)
  110. Find a newly inserted record from table without using MAX or TOP
  111. Date Format in MS Access using a query
  112. Features in 2005 that work in Compatibility Mode 80
  113. Change connected user to avoid owner prefix in queries
  114. JOIN without excluding non-joined rows?
  115. Auto Numbering Rows
  116. Query for Backup Model
  117. StoredProcedure help
  118. Is it possible to avoid a loop?
  119. selecting max and min year
  120. selecting records based on date
  121. Importing text file fails
  122. Cannot find sql express trigger in object explorer
  123. Importing a notepad txt file into SQL 2000 Server
  124. Set a value for identity key
  125. restaurant database
  126. Sql server 2005 Remoting Configuration
  127. sql server 2005 enterprise - Max CPUs
  128. SQL server and MSDE
  129. user defined type as a primary key
  130. Error while saving Maintainance Plan
  131. Dts Problem!
  132. Exam:070-229-An Excellent Resource
  133. Not able to read data from some columns of an excel sheet while using sql server DTS
  134. Case sensitivity in SQL -- ignore
  135. Query help needed
  136. How to spool output in MS SQL?
  137. SQL Server 2000 Install:
  138. How spool the output on MS SQL?
  139. How to increase the default row size in sql server 2000 only
  140. problem while declaring a a cursor
  141. 'Like' withing CASE statement ???
  142. language problem of ms sql 2005
  143. SQL Query help
  144. Wishful thinking: SourceSafe integration with SQL Server
  145. SQL 2005 Backup Problems
  146. SQL 2005 Backup File
  147. SELECT statement returns duplicate rows when a single row is desired
  148. MS Sql 2005 Master DB sysprocess with ASP
  149. Return error with Automated sp date Variable
  150. A Search for SQLFiles
  151. How to show roles with permissions to objects
  152. Configuring SQL Reporting Services for SSL
  153. Restoring a SQL Server 2005 database in SQL Server 2000
  154. How To write a query to get all Names without starting with an alphabet
  155. download pdf
  156. Sql Server - Jobs
  157. Can i write T-SQL statements to skip other job steps
  158. default filegroup for creating indexes
  159. move indexes via ALTER INDEX
  160. how to select 200 first records from table?
  161. displaying something else in results instead of value in DB
  162. Remotely accessing SQL database
  163. Conerting MS Access query to SQL
  164. Scripted CREATE INDEX
  165. Create indexes - own File Group
  166. Increasing field sizes in Microsoft SQL
  167. Trying to add a NON-DISTINCT field to a DISTINCT record set in a query.
  168. SQL field character limit change
  169. pulling ntext values sql server 2005
  170. Identity reused problem
  171. How to Join
  172. Performance of Partition Merge in 2005
  173. CREATE VIEW - script to automate column names?
  174. Sub query as multiline column
  175. connecting problem in ms-sql
  176. SQL Server and Oracle on the same server?
  177. update a field drom another table
  178. Finding the earliest datetime entry, and then updating the database on these reults
  179. Stored procedure limits??
  180. MSSQL 2005 SP2 install error 2259 - what gives?
  181. Possible to run MSDE (2000) and 2005 Express at the same time
  182. Transaction Logs
  183. What is SQL Server?
  184. Incorrect syntax near the keyword 'WHERE'.
  185. A belated thanks to all who have helped in the past!
  186. index fragmentation LogicalFragmentation -how bad is bad - silly question alter
  187. Merge two tables with conditions
  188. How do i connect and operate with data
  189. SQL 2000 renaming columns in tables
  190. Select question
  191. SQUirrel installation
  192. Europe to Test 1000s Chemicals on Millions of Animals
  193. Time based event
  194. Parse fields
  195. Change Tracking in SQLserver
  196. Removing the duplicate rows from a database
  197. how does SQL 2005 store Non-ASCII values and how it will be displayed in VB 6?
  198. Best approach to sending field names dynamically
  199. SQL to combine columns
  200. Incorrect syntax
  201. need emercency help DoCmd.RunSQL Sql error
  202. Partition Merge Performance - Sql Server 2005
  203. SQL Server 2005 Transactional Replication problem
  204. Sql Help
  205. Creating "Cross Tab tables in SQL?
  206. I am trying to convert a MS Access Query to a SQL query and I need help?
  207. Backup of a MS SQL 2000 DB
  208. Trying to get the right registry key through sql script to change listen port
  209. restore differential backup *
  210. Long query rollback - can I rename the table?
  211. restore differential backups
  212. How to increase the default row size in sql server
  213. Shift or Copy Data from Sqlserver to MS Access using Stored procedure
  214. connection Failure - -3709
  215. how to fetch all databases from server
  216. BETWEEN now() - 6days???? AND now()
  217. 2000 to 2005 query processng difference?
  218. How to delete records from 2 tables
  219. Transaction Register
  220. Retrieving an integer value from a database function via PHP
  221. textcopy.exe failure
  222. get value of last item in column?
  223. Simple SQL Help
  224. problem executing dts package using xp_cmdshell in querry analyzer
  225. MS SQL - Copying data from one table to another in two different databases
  226. Updating one table when Insert in other table
  227. Using raiseerror
  228. Urgent Help needed in Sybase query
  229. Query to find Number of Working days in a month.
  230. Triggers 101 - Invalid Column Name
  231. query
  232. Update query from Select
  233. system tables in MS SQL server 5
  234. Most recent meter reading in a database
  235. Problem with trigger
  236. how to recompile / refresh UDFs ?
  237. CXPACKET and contention within TempDb
  238. Help with SQL Server 2005 Publication
  239. insert into linked server problem
  240. Table copy from 1 db to another
  241. Retrieving Day, month and Year separately from the date
  242. Identity range managed by replication is full and must be updated by a replication agent. Error Message Makes NO SENSE.
  243. dbcc shrinkfile
  244. Problems with transactional Replication in sql 2005
  245. SELECT DISTINCT Problem
  246. Delete and update
  247. Recommended:How to get control of you life and time
  248. Real to datetime - how to...?
  249. Unique constraint in sybase
  250. Collation Conflict
  251. Year of the Pig brings good fortune to Yellowfin Business Intelligence
  252. Year of the Pig brings good fortune to Yellowfin Business Intelligence
  253. Viewing events as they happen?
  254. Difference between the querries.
  255. Merge Replication Error: 'Failure to connect to SQL Server with provided connection
  256. Need Help migrating VBA to TSQL
  257. SQL Server 2005 DTS problem: "Error 21776: General Error"
  258. Replication on W2KP
  259. Debugging a stored procedure
  260. Problem modifying out-of-the-box TFS Report
  261. SQL2000 New Index for replication
  262. SQL7 Add new fields for replication
  263. SSIS 64bit to Oracle 10G
  264. How to normalize these relationships?
  265. Grouping numbers
  266. Year, Month, Count on an Invoices Table
  267. Arrays and lists in SQL 2005
  268. cannot exit from if else block
  269. SQL 2005 Database to take to other pc
  270. Something I'm missing with condition?
  271. MS SQL BACKUP problem
  272. Heap table: why 454 rows of two INT columns use 2 data pages?
  273. Recursive CTE Question
  274. Reporting services - SQL server 2005
  275. SP2 Database Mirroring - "The remote copy of database "ABC" has not been rolled forward..."
  276. Write Data to two databases using SOAP/XML
  277. test
  278. how to change the first record go to last & 2nd record have to come to first??
  279. change rowset position at runtime
  280. How to Print Data directly to Text File using Stored Procedures
  281. CASE statement in Store Procedures
  282. Parallel Operation
  283. can any experts pl help me out in insert query..
  284. If statments in MSSQL
  285. Updating SQL 2000 server using VB6
  286. hi , query for displaying data
  287. bp server and e-mailing server lowest price Waiting for u
  288. Access and SQL Server Speed Comparison
  289. Access and SQL Server Speed Comparison
  290. SQL Query - distinct with 2 values
  291. Transaction Log File Compression
  292. SQL 2000 SP4 and SQL 2005 Express Co-Exist?
  293. Incorrect syntax near the keyword 'FROM'
  294. Excel DSN Query
  295. Can't attach 2005 DB on Vista - Erland? Anyone? Help me please!
  296. How to find last record in sql server 2000?
  297. Transfer logins using Dts package - sql server 2000 standard edition
  298. Row_Number Function
  299. SQL Serwer 2005 + HP LTO Ultrium
  300. SQL Server Upgrade Wizard
  301. Client-Server App vs MS Access Data Project
  302. Script to ammend column data
  303. Joining tables
  304. SQL Help with purging old data
  305. Parameters
  306. Stored procedure to create a new database with tables
  307. Does anyone use SSIS for database schema maintenance?
  308. Need help with CONVERT function
  309. How to view all triggers
  310. Accessing which data caused a trigger to fire
  311. How to restore sql server 7 backup to sql server 2000?
  312. table columns
  313. SQL database name Alias
  314. Query regarding Tiggers.
  315. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conn
  316. Reading a directory
  317. Help required!
  318. Last Table Access
  319. Stored procedures
  320. millions records archiving and delete
  321. help with a query
  322. SQL mail work around
  323. Problems with SQLXML bulk load
  324. Convert integer to datetime
  325. return duplicate records
  326. sum from two tables with two columns
  327. MS SQL SERVER via C programming
  328. Advantages and disadvantages
  329. How to get values from 2 tables
  330. export/import
  331. Create Table Script Incorrect syntax near 'Collate'
  332. Hexadecimal format .mdf file
  333. Importing DTS package to SSIS under x64 More options
  334. Visual Basic 6.0 + Crystal Reports XI + SQL Server
  335. newbe question: need a way to read in large query with .net
  336. SQL Server 2005
  337. How .BAK files are restored in SQL Server 2005
  338. which driver to use to make a linked server connection between MSSQL 2005 and Access 2007
  339. nvarchar & varchar
  340. maintaining a database?
  341. Is there an issue running SQL 2000 on a 2003 R2 64 bit operating system?
  342. Scheduling an Import in MS SQL 2005
  343. Which implementation will give faster result (Table design to Joins)
  344. faster count(*) or alternative
  345. Sql Query
  346. file share
  347. how many tables a dataset can store at a time?
  348. faster count(*) or alternative
  349. SQL Challenge - how to return a record set starting at a particular record?
  350. Copying .MDF & .LDF files for new server
  351. New database from backup
  352. INNER JOIN between a CLR-TVF and a table returns no rows
  353. unable to specify UNC path for restore through GUI??
  354. Help, did SP1 install work?? SQL Server 2005
  355. Splitting Date/Time Records
  356. Complicated count w/ subquery
  357. constraints across normalized tables
  358. SQL Help
  359. Non integer counting
  360. CASE in a Select Problem
  361. connect to ms sql from C# code
  362. CREATE TABLE and CONSTRAINTS
  363. Remove a character from a string
  364. Hi
  365. calling a php webservice in mssql server
  366. SQL 2005 compatability mode
  367. Current Database Context?
  368. ASP cannot run stored proc until the web user has run the proc in Query Analyzer
  369. SQL error
  370. Query for the first and latest wish
  371. How to run replace on all columns
  372. Methodology
  373. test
  374. test
  375. Return Columns along with MAX Value
  376. Format money value as padded string
  377. SQL statement - INSERT INTO and SELECT
  378. error for sending(saving) data to database
  379. error for sending(saving) data to database
  380. Insert Date as Formatted String
  381. SSIS declare output
  382. Getting an Error while attaching the database using System Architect Enterprise manag
  383. Struggling with date in query
  384. Move clustered indexes to new filegroup
  385. problem with date range
  386. parameterized view in SQL SERVER 2000
  387. How to Union dynamic tables
  388. T-SQL for the following?
  389. Somewhat complex report
  390. Output results to text with formatting
  391. timeout or re-trys.
  392. Replication and Reports
  393. Invalid column name using BCP
  394. Just a quickie..
  395. Restoring the .bak in MSSQL
  396. Iif MDX Strings
  397. Use RTRIM function on TEXTBLOB (text) field
  398. Error for saving data
  399. storage format of image in SQL server
  400. Microsoft Releases SQL Server 2005 Service Pack 2 (PR Newswire via Yahoo! Finance)
  401. Unicode characters (Japanese)
  402. How to run profiler from cmd
  403. What is the best availability and backup solution?
  404. Storing variable values whilst using cursors
  405. Subquery and display help
  406. Is there a Query Analyzer
  407. Help w/ installing SW on SQL server (2005).
  408. Partition Scheme using a function
  409. Stored Procedure, error when executing (
  410. Restore SQL DB with correct logical file names
  411. resetting Identity Seed on change of primary key
  412. Select Statement Issue - Date Formating/Selecting
  413. SQL Deployment tool
  414. Ho Do I Implement Ms Access Dsum() Function Within Ms Sql
  415. My Sql
  416. creating a database link between DB2 and SQL server
  417. Function to return "remaining" of field after it finds a character in the field.
  418. Simple function for returning a character based on search criteria..
  419. SHAPED SQL: Need help!
  420. Int / Int does not give decimal value
  421. Import Excel Spreadsheet (Residing in Internet) Data into SQL Server Database Table
  422. how to take backup through network in MS SQL 2000
  423. Support for Spanish and English language
  424. Stored procedure
  425. SELECT *
  426. SQL 2005 AND SQLXMLBulkLoad
  427. a substitute for UNION?
  428. Returning an existing column OR the scope_identity
  429. SP2 for SQL Server 2005 is out
  430. How can we insert data through triggers
  431. adding the vc express bundled sql server to odbc
  432. Installing Ms-SQL 2000 with Win XP Pro on Stand alone computer
  433. Performance of SPROC changed by dbo. prefix
  434. Best method for inventory insertion
  435. Improving performance
  436. Fresh SQL Server 2005 giving problem in accessing access 97 file through Jet Ole DB Provider
  437. sql server 2000 robo copy
  438. Inner Join on Partitioned View
  439. how to parse a string in mssql
  440. MSSQL and Unicode data
  441. SQL how to view the list of tables in DB, the columns in the table, stored procedure
  442. Ms Sql Server Giving Timeout Expired
  443. SQL Server Runtime?
  444. SQL Server Link Server
  445. query
  446. Question About a Check Constraint
  447. Violation of primay key
  448. Writing SQL Help
  449. sum a table within a table
  450. How to Access MS Access File in Stored Procedure ?
  451. count records in several months
  452. Question on deploying .SQL files
  453. A trick query.
  454. SQL 2005 AND SQLXMLBulkLoad
  455. ms sql server
  456. Connecting Sql Server 2005 on Windows 2003 using ASP local
  457. Full bakup of Data
  458. Change Object Ownership
  459. A list of autoexec stored procedures
  460. T-SQL Gathering fields from a table
  461. T-SQL in Mngmt Studio Express Doesnt affect change- obvious omission?
  462. Possibilities to restore an old database
  463. Sqlserver
  464. Sql Local Server
  465. SqlServer
  466. tempdb is full error in sqlserver2000
  467. Package 'Microsoft SQL Management Studio Package' failed to load
  468. trying to group by two diff criteria
  469. Invalid object name '#temp'
  470. Auto gen record id as alphanumeric values
  471. Encrypting mdf files
  472. Restoring from transaction logs to running database
  473. Where the database is in SQL Server 2005 ????????
  474. Syntax, please :-((((((((((((((
  475. show number of values as % of total records..?
  476. Blobs in SQL Server
  477. Kill connection
  478. Updating Multiple Records Based On Records Returned By A Select Statement
  479. Performance
  480. Whats wrong here?
  481. Sql server process memory question
  482. Put 3 tables with same fields into one
  483. ORA-04091: table is mutating, trigger/function may not see it
  484. cursor in Stored Procedures
  485. Merging contents of one db to another huge db.
  486. Imprting to a parent and child tables from two csv files using dts package
  487. Backup and restore database hourly: how to implement it?
  488. Replace Multiple Spaces with One Space?
  489. export database structure
  490. restoring to a point in time
  491. MS-SQL question about GROUP BY
  492. Delta compression of query results
  493. .BAK extension file ??
  494. SQL Server losing sql code in stored procs...HELP!
  495. need help and advise with database
  496. delete records from one table that occur in another
  497. Urgent Help
  498. cannot write logfile Error 1059 : Circular service dependency
  499. in query, how can I compare string?
  500. Trying To Change Identity On Field W/Data In SQL Manager
  501. string matching in T-sql
  502. Basic Questions
  503. Project Planning
  504. Can't Connect to SQL db
  505. Can't Connect to SQL db
  506. Running access 2000 ap on sql 2005 express edition
  507. How do I use a variable to modify this sproc?
  508. Counting Orders for the Day
  509. specific records returned from 3 views using sql
  510. Getting a best selling brands list
  511. PIVOT query - access to mssql - help wanted!
  512. Order by - testing on true/false
  513. Memory Config (2005 Standard + x64 Win2k3 Enterprise)
  514. scripting data
  515. updating a stored procedure
  516. Link Tables
  517. Java DatabaseMetaData and MS SQL 2005
  518. returning one single record rather than multiples
  519. Callable statements, SQLServer and JRun
  520. Callable statements, SQLServer and JRun
  521. Trigger does not affect the code written in the loop... pls help its urgent
  522. SQL Format Function "0000"
  523. Urgent: MS-BI (SQL Server 2005-AS/RS/IS)-CMM 5-Hyderabad (with possible onsite)
  524. SQL Scripts
  525. Migrating to 2005, need advice
  526. Problem with SQL server 2000
  527. SQL Data concatenation
  528. which one is faster...
  529. Replication to a Custom OLE DB Provider
  530. Problems loading SQL server 2000
  531. vb with sql server
  532. databases
  533. Text Functions in SQL ...
  534. SSIS Import
  535. sql 2005 upgrade problems
  536. Log File is Full error: How to prevent this happening?
  537. Can't connect to SQL Server(SQL Express) in VS 2005
  538. Large number of INSERT statements - not all are executed
  539. Hanging Query
  540. Learning SQL Server with Win XP Home
  541. get record with earliest datetime value
  542. DTS Package Execution (From Job)
  543. Where is my dts?
  544. How to move table data in one server to another server
  545. Convert Access to SQL Server
  546. Inserting wav data
  547. Creating maintenance plan wizard problem
  548. Importing DbaseIII data to sql 2005 using asp Coding
  549. CentOS2.6/apache2.0/MsSqlServer2005xpress/CFMX7
  550. sql data value unrecognized