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. Web Page And Sql
  2. help with query
  3. database problem
  4. Creating stored procedures in SQL Server 2005 Express
  5. least currency
  6. Convert month into its number equivalent...(Ex. JAN=1,FEB=2...)
  7. identity
  8. how to access sql server 2000 on ms server from unix platform
  9. Regarding Integration services in Sql 2005
  10. Execute an schedule job from MSDE with LINKED servers in SQL Server
  11. MSDTC?
  12. "the data provider or other service returned an E_FAIL status"!?!?! WT-???
  13. CDOSYS Mail Using SQL Server
  14. SQLServer 8.0 Sp3 to sp4 upgrade
  15. automated role creation
  16. Recursive Stored Procedure?
  17. SQL Batch - Slow Response - Remote DB query
  18. can anyone solve this sql query?
  19. can anyone solve this sql query?
  20. 2005: T-SQL to download?
  21. MS SQL rollback!
  22. Related Tables: Help Needed With JOIN Query
  23. Er-win connection problem
  24. SQL standards
  25. Creating tables in SQL 2000 using C#
  26. SQL Server
  27. SQL Codings
  28. DB2 Reason Codes ?
  29. a beginner question
  30. How can I create a cool data model table map?
  31. user defined funcyions in sql server 2000
  32. Unable to create index 'PK_Contact_Table
  33. how to get the difference between two dates ,excluding weekends in ms sql?
  34. viable question
  35. reading log files mdse (sql server 7)
  36. Chain Multiplication on a column
  37. Sql Database marked suspect
  38. Select Range
  39. weird database back up sizes
  40. (datediff(ss,,) / 60) rounding down the minute
  41. Return percentages in the query.
  42. Update & Select in one?!
  43. Calling C# Code within DTS SQL SERVER 2000
  44. Trigger Fireing
  45. Using trigger to notify an assembly of changes.
  46. Case Statement in Where Clause
  47. Using Substring to Update data in a column
  48. T-SQL (Stored Procedure) upgrade from 7 to 2005
  49. Processor licensing
  50. what is wrong with sysfiles tab
  51. Hard Code the start date and the end date from an existing SQL query!!
  52. Subquery in DTS No Longer Works After Years
  53. cubes in sql
  54. Stored Procedure - Urgent
  55. table copy
  56. .DAT files to MS SQL ServerV7
  57. Want to Compile C embedded sql code by MSSQL server 2000 on linux
  58. Stored Procedure to run query and insert
  59. how to fetch case sensitive distinct data from sql server database
  60. Transfer user password from old database to a new one
  61. user/schema problem in SQL Server 2005!
  62. Parameterized Query Performance Help!
  63. Is there a way to view Stored Procedure, Trigger andFunction Usage in SQL Server?
  64. complex(?) query
  65. Tutorials on XML, XSL, Javascript, SQL & ISS
  66. How to Copy Users? Help
  67. SQL 2005 Processor VS Cal
  68. Updating part of an XML column in a sql server table
  69. Unique Identifiers & Select Queries to MSSQL in PHP
  70. Query Assistance Needed - Please
  71. Query Assistance Needed - Please
  72. Query Assistance Needed - Please
  73. run a Package from package
  74. [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax
  75. changing default value in alter statement
  76. C++ programmatically reconnection to SQL Server 2000 after stop/restart SQL service
  77. SQL WHERE CLAUSE HELP
  78. clever date to find most recent .bak file
  79. SQL 2000 - Initiate or Force Replication
  80. Replacement for ISAPI in SQL Server 2005
  81. Multiple table join
  82. Deleting duplicate rows in a table
  83. MS SQL 2000 Performance / Ram Usage
  84. T-SQL FROM SQL to DB2
  85. Dan <-- 香港IT界超级溅人
  86. Text too long to be edited
  87. Compare record count in table1 to qty in table2?
  88. Converting Access Query to SQL Server Query
  89. Synchronization of two SQL Server databases
  90. Double summation
  91. How to connect to MSSQL server from HP-UX environment
  92. how to retrieve random records from table
  93. provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specifie
  94. time out expired
  95. how to delete lines from text file
  96. Adding text to a text column
  97. sqlserver problem
  98. installing sql 2000 & 2005 side by side
  99. how i can import data from multiple servers
  100. Dynamic addition of columns to a View
  101. Database Connection
  102. Information No.of database deadlocks and No. of transactions per second/minute in MS Sql Server
  103. Sharepoint and MS Access
  104. Delay between CREATE DATABASE and ability to connect to that database
  105. Help with statement
  106. Drop all indexes in a table, how to drop all for user tables in database
  107. Value zero is being returned.
  108. Replacing the second carriage return
  109. diadvantage & advantage of identy column
  110. composite primary key...
  111. SQL Server 2005 Replication
  112. Incrementing within a Group/Subset
  113. cursor error must declare scalar variable
  114. complex merging query in sql server 2000
  115. Retriving multiline Value from a database
  116. Sum Comma Seperated string
  117. Peachtree to SQL Server
  118. dynamic cursor - sorting in declaration
  119. Stored procedure works, Agent job aborts
  120. need to open text file for datapump from activex script
  121. need to open text file for datapump from activex script
  122. Updating a sequence number (not identity insert)
  123. Output of international characters to text file
  124. SQL Query help
  125. running backups from a batch (.bat) file
  126. how to move data files from one location to another with MSSQL.
  127. SQL Build Scripts .bat files
  128. Changing compatibility level from 65 to 80 - Whats up?
  129. Artificial Mind - Part One - Basic Architecture and Cognitive Structure is now available
  130. How to retrieve query results with now field names, dotted line or footer
  131. Copying a DTS Package and Jobs
  132. Selecting a different field from a group.
  133. Passing parameters to stored proc from Crystal reports
  134. How to delete repeated entries from table using T-SQL statement
  135. How to find All Permissions in the Current Database for a particular User
  136. After a corrupted publisher
  137. sql statement
  138. data types
  139. Calrification on number of columns fetched to server memory
  140. DB2 ver.4
  141. execute command - urgent!!
  142. How to transfer data from Oracle Table to SQL Table
  143. Sql Backup
  144. Date overlapping
  145. Problem Copying Table
  146. Spectra force @@@@@ HOT LIST@@@@@
  147. MSSQL Script execute in .bat
  148. How to copy data from MS Excel to MS SQL Server using DTS
  149. MSDTC error in Windows xp environment.
  150. List users and permissions in a SQLSERVER2000
  151. mmc.exe - .dll files are corrupted
  152. CONTAINS in SQL Server
  153. Insert statement conflicted with foreight key contrait.
  154. Connection string problem.
  155. Urgent requirements ----- Oracle Apps Finance Functional
  156. Migrate from MS Access to SQL
  157. Problem with stored proc.
  158. Creating a text file
  159. Could not find installable ISAM
  160. Blank Password Policy problem
  161. [help] ALTER TABLE: error message 4929
  162. Need to utilize exec('use '+@nvcDatabaseName+';
  163. INSER at runtime?
  164. Select Statement.
  165. transaction log file is full
  166. Best way to force a varchar column to have no whitespace
  167. MS SQL server uses 3.7 gb memory and %100 of my huge server
  168. MS SQL 2000 import from MS SQL 2000
  169. Installing SQLServer2005 but Preserve Current SQLServer2000
  170. White space in a field
  171. drop down list
  172. Not In / Not Exists
  173. A script to delete views
  174. keep running process even killed
  175. Replace Multiple LIKEs
  176. Building data base on local machine.
  177. query to obtain files whose last status=2
  178. how to query for text containing parens?
  179. Snap-in creation failed
  180. please if you no how to fix this help me please
  181. build a query which access to multiple databases
  182. Exporting Data from tables to text file all at once
  183. ALL and empty set
  184. Need help with SELECT Query. dont know what topic
  185. connecting oracle and sql
  186. Unexpected Casting With Sum & Coalesce
  187. call stored proc on sql 2005 from 2000
  188. how to change default data directory for SQL 2005
  189. SQL SERVER 2005 maintenance plan
  190. Recover Mode set to Simple for Unknown Reason (not MSDB)
  191. Update Query containg static data and data from another table.
  192. Invalid column name 'ProjectQuestionContentDateTime'
  193. Insert Japanese from ASP page into MSSQL Server 2000 database
  194. Searching problem
  195. Sql Server 2005 Maitenance Plan
  196. get todays date and a certain time
  197. Q on joining tables with nullable fields
  198. Passing multiple values into a stored procedure...
  199. Sql Server 7 To Sql 2000 Upgrade
  200. Non English Characters
  201. Use of LIKE in Cursor degrades the performance?
  202. question on reindex
  203. SQL 2005 hogging resources
  204. datetime columns
  205. Update Query Help!!
  206. Install Problem
  207. How accurate is GetDate() ?
  208. software RAID-100
  209. CVS with SQl
  210. Text Data Type Problem
  211. concatenation
  212. getting problem while inserting using linked server
  213. MSSQL arguments in PHP
  214. Alter Table name
  215. concatenation with space
  216. one of the tab in SSISS is not working correctly.
  217. Sql server 2000 performance tunning
  218. Invisible stored procedure?
  219. store db objects in *.ndf vs. *.mdf??
  220. set default value for a char column??
  221. SQL Server 2000 Transaction Log Backup Question
  222. Date comparison problem
  223. Date comparison problem
  224. SQL Server Slow
  225. Cursor help please
  226. query
  227. SQL Server Agent
  228. insert statement blocked
  229. DTS from excel file (excel filename is different everyday)
  230. stored procedure compile
  231. what should i do when i want to save a select resultset,but not in a new table,in memory is the best?
  232. reset sa password msde (sql server 7)
  233. Problem displaying extended ascii characters from sql server in html
  234. Better way to use BETWEEN Begin and End Dates
  235. SQL Transaction Log File
  236. ODBC: Call Failed
  237. how to get this resultset...
  238. DTS Works, job fails!(data source Foxpro and destination SQL Server 2000
  239. Master File not Accessible for Copying
  240. Regarding Replication Concept
  241. MD5 encryption
  242. Help with Crystal Reports subselect
  243. Insert trigger to populate other columns in same row
  244. xp_cmdshell problem
  245. SQL Address
  246. SQL help Needed
  247. Interesting Data Mining Forum
  248. SQL and MSMQ
  249. Keyword Search Help
  250. Point in Time Backup (impossible for some points?)
  251. Where to Begin
  252. Using USER value in SQL code
  253. QUESTION: Performance issue on *one* database on a server
  254. Breaking down Total Hours worked into Day and Evening hours
  255. How to Delete Login (SQL-DMO)? - SQL 2005
  256. Upate table using ADOX in VBScript
  257. Question on moving logs
  258. Dyamic view/function based on table data (?)
  259. FK - urgent
  260. UNION / INTERSECT / EXCEPT in SQL Server 2000
  261. How To Calculate Database Size In Sql 2000
  262. Obtain the query plan of a running process
  263. data is not exporting to excel in sql server 2005 client edition
  264. Create Procedure Permission ONLY
  265. Migrating data from SQL Server 6.5 to SQL Server 2005
  266. Trigger to reset Table Rows
  267. composite primary key
  268. about efficiency(rephrased)
  269. Converting from String to Numeric Problem
  270. cursor to compare/report on the same fields in 2 tables
  271. lookup data in form
  272. Export/Import data
  273. how many times Identity value has been reset?
  274. What queries were run?
  275. Question on System and Data Restore
  276. Foreign Key Relation with composite primary key table
  277. Sql-dmo
  278. Trace file in MySQL
  279. about Efficiency
  280. help with Select statement
  281. Character set support
  282. DELETE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'
  283. dba activities
  284. SQL server connection
  285. Foreign Key
  286. Cannot Open .bak File from ms sql database. either 2000 or 2007
  287. DTS Packages from 1 SQL Server to another
  288. Help needed with DATETIME Arithmetic
  289. SQL Server "Light"
  290. Replicate SQL Server to MS Access MDB
  291. Microsoft OLE DB Provider for ODBC Drivers error '80004005'
  292. Updating columns in sql server from text files
  293. Show data in ASP.NET datagrid control in cyrillic
  294. Download Ebooks
  295. Why cannot set Unicode string
  296. Why cannot set Unicode string?
  297. Go to the last record
  298. rebuild
  299. Send Sms From SQLServer2005 to MobilePhone
  300. optimization
  301. Looping a stored procedure in a dts package
  302. How To Select a Certain Limited Number of Rows Per ID
  303. Appending data to an existing record
  304. Copying table data from a different database
  305. Update using Substring
  306. Help - Finding the newest date without using max()
  307. import txt-file via batchscript to SQL 2005
  308. Update sub query
  309. Update sub query
  310. time stamp data type
  311. Indexes vs Clustered Indexes
  312. SQL 7 to SQL2005 Migration
  313. Trigger - On insert ~ if [column] value = XX, change it to YY, then insert
  314. howto use the query results as view column?
  315. formatting for a birth date field??
  316. Problem running stored procedure inside another store procedure
  317. Yellowfin Reporting Release 3 OLAP Connectivity
  318. The scripts in the store procedure run slowly, but quickly exec in the Query Analyzer
  319. Using a trigger to generate an ID value
  320. Select and Insert Question
  321. looking to tune query...
  322. Removing HASH Match / Inner Join
  323. Deletion on multiple tables
  324. Dynamic Select in MSSQL
  325. last record in table
  326. Row versioning in SQL 2000?
  327. Line Break in T-SQL
  328. Actual and Estimated Rows
  329. how to run the servlet
  330. Can I avoid temp tables, etc.
  331. Synchronizing Access and SQL Server
  332. sql server i/o bottle neck ?
  333. For SQL Buffs
  334. sql 2005 client tools
  335. Excel Inserts Null Values in DTS package
  336. How do I send query output to a file?
  337. DTS Automation - Huge Problem
  338. SQLRef - Website Created by Programmer to Programmers
  339. database migration using DTS help
  340. The user does not have permission to perform this action.
  341. urgent!!! convert to datetime format from varchar...someone please help...
  342. PKZip issue
  343. Trouble with converting time/date
  344. sp_executesql in triggers
  345. Query is slow sometimes
  346. Error 18024
  347. stored proc bug with datetime variable
  348. export to sql 2005
  349. SQL Between Dates
  350. Recurring Scheduled Job
  351. database converters
  352. Union or Join or or
  353. Flattening Parent Child, an issue, please help
  354. How to make this an efficient query?
  355. Select * and display days overdue
  356. SQL troubles with VPN connection
  357. est
  358. test
  359. Best practice for storing long text fields
  360. Managing MS SQL on Linux
  361. Error in my SQL Syntac
  362. Find out the percentage complete of Stored Procedure
  363. Tree table
  364. sql profiler
  365. Memory setting right ?
  366. Database Maintenance Plan
  367. How to get a SP return value on another SP?
  368. convert column into datetime format
  369. Moving objects from 1 SQL Server to another
  370. Permissions for ODBC to SQL
  371. Want to get monthname from a date
  372. DTS Automation - a tuffy
  373. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name on Linked Server
  374. return values and recordset in one stored procedure
  375. Top and Views
  376. Passing SELECTed rows to a calling SP
  377. cross server update problem
  378. HOW TO Transfer my sql server 2000 data base to server on the internet
  379. Computed Column Specification
  380. One more connection problem-Security Issue
  381. I have no blog
  382. SQL Server E-Learning
  383. ADO.NET problem?
  384. need query...its urgent
  385. query in msaccess
  386. Order of Merge Replication
  387. See Sql server but not databases
  388. .NET assembly for BULK INSERT
  389. Problems with DTS
  390. Please evaluate this approach to shrinking log files
  391. why the difference in DTS?
  392. Osql join command
  393. how to use SP's output in the SELECT Statement
  394. trigger - v.urgent
  395. how to get all records of a person in perticular month
  396. SQL Server 2K Database Name Problem
  397. How to display the managers and the employees working under that Manager
  398. Reg: database connectivity between SQL and ORACLE
  399. Finding a line number
  400. How to converting float to date
  401. Is it possible to move a database from 2005 to 2000?
  402. Need advice on reading material
  403. SQL Server 2005 connection unusually slow even errors.
  404. Unable to Insert in Temp table through RPC
  405. transaction inside sp_executesql
  406. How to use result set returned by Stored Procedures?
  407. How to use result set returned by Stored Procedures?
  408. Replication between SQL7 and SQL2000?
  409. Finding name of DTS package thats called from scheduled job
  410. trigger
  411. About Creating Relationship
  412. Sql Server 2005 Image Storage and Retreival
  413. Creating a dynamic Global Temp Table within a stored procedure
  414. Trigger problem
  415. What is the meaning of "LTRIM(N' ')" ?
  416. what is the system requirement installing ms sql server 2003 client version?
  417. Which to install first, VSTO or SS 2005 Developer??
  418. move/copy database objects from SQL Server Express to SQL Server Standard??
  419. Getting non matching records from 2 tables?
  420. Upgrade SQL Server 2000 Failover Cluster from SP3 to SP4
  421. Are these DB's required??
  422. Running MS Access db as a Linked Server on SQL Server
  423. specjalista od mssql2000 na jednorazowe zlecenie
  424. Download the JAVA , .NET and SQL Server interview question with answers
  425. An interesting Lastname, Firstname, Middlename challenge
  426. How to convert rows into columns?
  427. Server configuration for MSSQL 2000 and MSSQL 2005
  428. BULK INSERT Help needed bad!
  429. MSDE
  430. Facing some problem in Instead of Trigger for MultiRow Insert
  431. Query performence about nText
  432. collation
  433. difference between BCP and DTS
  434. How can i see all trigers that i created
  435. ldf & mdf
  436. SQL Server 2005 - BULK INSERT
  437. installation of ms sql server 2000 developer edition on windows xp pro
  438. login failed for user
  439. procdures and functions
  440. foreign key
  441. rowid is there?
  442. Sql Server connection problem
  443. Can't Keep Primary Key Columns when moving db to SQL 2005 from 2000
  444. Storage usage for Enterprise Applications
  445. Comparing two tables and spitting out an XLS
  446. besoin d'un petit coup de pouce
  447. Drop Replication components
  448. Stored Procedure To Update Columns
  449. Restore Messed Up Table Names
  450. BULK INSERT into table with identity column?
  451. Does SQLMail require a mail account on the Exchange Server?
  452. DTS that does HouseHolding with Millions of records
  453. Basic TSQL - DISTINCT in PK
  454. need help on normalizing the tables
  455. Column order/presentation in virtual table (result set from viewor UDF)
  456. Text Column question
  457. Insert Uniqueidentifier after the fact
  458. Need advice, new to VB 6.0 and SQL server 7
  459. need a query please help
  460. Replication Query
  461. estimation the buffer cache hit ratio
  462. CREATE FUNCTION with COBOL doesn't work!!
  463. identity insert
  464. Create CUBE Roles automatically: Please help
  465. Import data from excel sheet to ms sql server table
  466. primary key
  467. Cursor Problems
  468. Foreign Key Constraints problems
  469. Databases updating simultaneously
  470. Self-Reference cascading deletes
  471. SuperSocket info: (SpnRegister) : Error 1355.
  472. Return a string representing the day of the week
  473. Need most recent record from views.
  474. Stored Procedure to return table?
  475. Concatenation and Formatting output in T-SQL
  476. About LogShipping-Urgent
  477. Inserting Data
  478. Calculating Positions Query Required...........
  479. Looking for database backup command
  480. Microsoft SQL Server 2005 - DB
  481. Deleting record in table B on deleting record in table A using Trigger
  482. Changing schedules for a Job outside SQL Server
  483. sql server case sensitive?????????
  484. Mssql
  485. Easy cross referencing question
  486. Error 8115, Level 16, State 2
  487. How do you create ##Temp tables if they don't exist, use them if they do?
  488. Converting strings to dates
  489. [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error
  490. books online download link please
  491. Distinct
  492. How to install SQL Server 2000
  493. SQL server Back up
  494. Update a column
  495. cross server insert @@error
  496. Import ASCII Data
  497. DTS From SQL Server 2000 to Btrieve
  498. Tough Correlated Subquery issue
  499. How to allow FULLTEXT SEARCH INDEXING to non-admin user?
  500. Is there a way to transfer ntext data from one table to another? MSSQL2000
  501. functions and procedures
  502. is rollback possible here?
  503. Using DAO to access binary data in Sql Server 2005?
  504. OLE error code:80040E14
  505. MSDTC and Delete transactions
  506. MSSQL2K5 Install Path
  507. dbcc checkdb
  508. Installation of local database
  509. grant access to extended properties
  510. delete sql server registration in tsql
  511. MSX/TSX
  512. problem on login: user is inactive
  513. Database indipendent queries
  514. [Sql2000] how to limit table size
  515. How to change db owner for SQL Server 2000 database
  516. how to change password?
  517. Checking if DB Connection is active or not
  518. Row mapping from one table to another
  519. Counting the occurence of a string ...
  520. OPENOFFICE BASE
  521. Moving from mssql to postgres, advice needed
  522. joins
  523. SSIS Standard Edition and Script Task
  524. Totals on change
  525. SQL Http Interface
  526. Finding a creator of object
  527. sql server is not starting
  528. can we provide security for .war file in java
  529. deleting duplicate records
  530. Import Excel into Ms SQL 2005 Automatically
  531. When DTS hits a bad date
  532. Normalizing a Crosstab
  533. Variable Math in Stored Procedure
  534. Primary key generating
  535. Transaction log keeps growing
  536. Replication performance - how to measure it ?
  537. Candidate key
  538. Problem with export of a table to a text file
  539. Can any one explain this query behavior
  540. Temp Table Column Type?
  541. Table Query Timeout Problem very specific
  542. Merging two tables with selection
  543. Help me with this query please.
  544. Help me with this query please.
  545. Case help and Identity help
  546. Efficient Store Proc for Paging Very large DataSet using Cursor Approach
  547. minimun installation
  548. wow
  549. Performance: Server Agent v's Query Analyser
  550. SQL Running process