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. get DB name from within stored procedure?
  2. MSSQLSERVER service terminated unexpectedly
  3. Help with an import to SQL
  4. Problems running Enterprise Manager and Service Manager
  5. Data Retrieval From Online Database - Paid Consultant Required
  6. Media question
  7. Formatfile shortcut?
  8. Bulkadmin role (BULK INSERT)
  9. TOUGH INSERT: Copy Sale Record/Line Items for "Duplicate" Record
  10. question abot primary key
  11. Very serious bug with Materialized/Indexed views and SQL server
  12. Unicode in SQL queries
  13. Unix connectivity tools to sql sever 2000
  14. Unix connectivity tools to sql sever 2000
  15. Table Spool\ Lazy Spool
  16. Database restore question
  17. Recordset opens as read-only -- WHY??
  18. INDEX possible for reverse wildcards?
  19. Altering SQL Server 2000 table design
  20. Large Data Delete
  21. Data Modeling
  22. WriteBak Reaktime examples
  23. Count rows in a date interval
  24. Help with getting table information from sqlserver
  25. query regarding date format
  26. Print list of tables with Identity row set to NOT FOR REPLICATION
  27. OPENDATASOURCE: text file as input ?
  28. Build database application on Internet with ISP?
  29. Operating system error code 3(The system cannot find the path specified.).
  30. Setting maximum number of merge agents
  31. Volltextsuche mit contains
  32. SQL 6.5 with Delphi 1.0 on Win95 problem.
  33. Migrate VIEW from Access to SQLserver ???
  34. Input string was not in a correct format
  35. eliminating redundant data
  36. NULL vs. "Unknown Value"
  37. set a attribute to random values in a given list
  38. Logging to second disk -- what happens when it crashes?
  39. Representing rows as columns
  40. MSDE Maintenance Plan
  41. Comparing data in two consecutive rows from a single table
  42. Sum question
  43. accessing SQL 2000 table from within Excel
  44. HELP! Shopping Cart Solution Required. URGENT!!
  45. Count query problem :(
  46. slow query thousands of records.
  47. solve the proplems
  48. DTS Import not working after SP3a upgrade
  49. Generate a normalized XML doc from SQL Server
  50. Instances of SQL
  51. Nested Coalescing possible in SQL?
  52. Fundamental Functions MS SQL Server 7 or 2000 users VALUE MOST
  53. Control characters output in attachments from xp_sendmail
  54. Convert to Date
  55. Is any possible to run DTS package from Command Line ?
  56. SQL Query - Date, between dateadd problem
  57. wildcards in dropping constarints
  58. Selecting Values in CSV
  59. Advance SQL
  60. Help Required on Stored Procedure
  61. Possible Corrupt Table
  62. cross tab or derived table
  63. Creating roles
  64. can u help with my select ?
  65. cross tab or derived table
  66. Like statement
  67. sql server 2000
  68. possibile che ...
  69. Calling All T-SQL Gods & Goddesses
  70. How to Spec a SQL server
  71. SqlServer changes cursor to "read only"
  72. Yet another BCP issue
  73. Scripting "INSERT"s in an SQL database?
  74. Help setting up SQL2000
  75. CASE with empty parameter
  76. multiple result sets
  77. PRINT command Not Working For Database Client
  78. Select lookup code values problem
  79. How to transform fact table only by SQL?
  80. DBCC and Failed Assertion Errors - HELP!
  81. Why is my Data Import going so slowly?
  82. Full-Text Search Query Question - Performance
  83. SQL for Modeling Generalization Hierarchies
  84. Breaking out data from a text field type
  85. Functions with global variables
  86. update tables from a csv file?
  87. Who is in a database ?
  88. connection problem to sql 2000 on windows 2003 from Windows 95
  89. HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET
  90. Whats wrong with this nested while loop?
  91. password protecting data
  92. Problem in Right Outer join query
  93. Defining global function in DTS
  94. BCP utility replaces German with junk characters
  95. Right outer join problem
  96. Advanced SQL Query Problem ...
  97. Problem with a temp table
  98. Timeout / Obtaining a connection from the pool - Please Help!
  99. select into withidentity
  100. question about retrieval of client process IDs
  101. Update Top 30%
  102. last row
  103. how to drop all keys & indexes
  104. Update all tables in database
  105. Triggers
  106. Disabling primary key
  107. stored procedure result set
  108. last day of previous month
  109. long query alert
  110. changing one column in each row
  111. Access linked to SQL Server - 2 day offset error
  112. FOR SELECT
  113. Embedded select query?
  114. SQL Server makes our server reboot!
  115. Insert into two tables, both with auto increment fields
  116. Sudden xp_send mail error
  117. SQL pieces-parts
  118. Query: How can I get this result?
  119. Adding Identity Column to BIG table
  120. Date/Time select Problem
  121. are nulls bad
  122. Novice question regarding client notifications from a server
  123. Mapping SQL Server Data Types to C DataTypes
  124. Query to get the Domain from the email
  125. script to remove nulls from DB?
  126. Wrong record retrieved after move to SQL Svr
  127. Log shipping wizard doesn't show up in Enterprise Manager
  128. Cretae a view in one DB with a stored procedure from another DB
  129. Sql server-compi question
  130. @local_var really cannot hold table name ?
  131. Which is faster?
  132. data types
  133. Trouble with Update syntax
  134. Conversion Problem
  135. Correlated Subquery with distinct Record
  136. Inserting a select with an additional static field
  137. deadlocks in sql server
  138. Query in a Loop
  139. case-sensitive search in sql 7
  140. SQL Server DB Backup job problem
  141. Log Shipping for replication
  142. Performance Tuning for Row-by-Row Update Statement
  143. Displaying images clarafication
  144. Allow zero length
  145. 3rd party tools for job scheduling
  146. noob question how to make a mailto function
  147. NooB Scripting Question How to use mailto
  148. Date functions
  149. Stored Procedure Across SQL Servers
  150. Using alias in an expression
  151. Spacing problem in SQL Server
  152. Query too slow
  153. Tricky Record Locking Problems
  154. find missing/deleted records?
  155. Book recommendation on performance
  156. Closed transaction keeps running...awaiting command
  157. 1:m database relation "Flattened" for reporting purposes
  158. Performance problems with query
  159. SQL 7.0 to 2000 upgrade
  160. Risks of single MSSQL domain account for mult servers?
  161. MSDE and SQL Server 2000 design questions...
  162. sql server 2000
  163. Mainframe Datatype Scrubbing
  164. Securing mdf file
  165. unable to submit more than 8000 characters with stored procedure
  166. Backup/Restore locks up EM
  167. MSDE and NetUserAdd Error
  168. Analysis Services
  169. Update stmt with an Table alias?
  170. Access vs SQL
  171. Sql 2k Database Log file Full ... How to empty that
  172. Filter Criteria - Temp Table Join or Where clause?
  173. SQL Server Report Generator - beta testers needed
  174. TempDB Disk placement with Log files?
  175. Enterprise Mgr Can Not Sort?
  176. Linking to MS Word
  177. 'Primary' filegroup is full.
  178. Select Max query - please help
  179. Nulls in calculations
  180. Something like MIN(f1, f2)...?
  181. Can table ownership be changed?
  182. Help - how to concatinate strings from multiple rows?
  183. Translate Function?
  184. data dictionary
  185. SQL Server Performance varies by NT account
  186. Sorry: Trying to understand this piece of code
  187. help with sql script
  188. eseguire un dts
  189. update data in a field
  190. Which Raid?
  191. pick list values into a table
  192. multiple values into a table
  193. Recovering from transaction log deletion in 6.5
  194. MSDE
  195. MSDE
  196. A question of SP technique...
  197. MSDE & Web Pages
  198. memory utilization
  199. SQL Mail and SQL Agent Mail @!~$%!%#^$%&^#&#%
  200. export view table into excel
  201. Sintaxis mysql
  202. Is it possible to re-reference a column alias from a select clause in another column of the same select clause?
  203. CPU 100%
  204. "dbuse" fails when database name is larger than 28 characters
  205. xcopy command failed in sql server 2000 as scheduled task
  206. Entry point not found with MS SQL Server
  207. "GO" used in a stored procedure
  208. Exporting to Excel
  209. How do I copy a database
  210. View & SP's for just a few users
  211. row number.
  212. Can not create views, tables etc * URGENT*
  213. Caching UDF
  214. decreasing number of records.. is it important?
  215. MS-SQL Server equivalent to Oracle 9i?
  216. Anything wrong with this query?
  217. Help with TEXTCOPY
  218. Difficult query help
  219. help with nested Query
  220. Difficult query: return recordset from concatenated strings?
  221. Creating New Views on SQL 2000
  222. tempdb log full
  223. Link Pervasive SQL Server - how ?
  224. sql server sizing planning - architecture help
  225. DTS vs Excel numeric conversion
  226. Oracle9i: SQL Exam# 1Z0-007 wanted
  227. SELECT DISTINCT with JOIN
  228. how to break out of a cursor and out of a SP all together
  229. Looking for a db schema read/write/synch tool
  230. Representation for Deleted Entities: difficult question
  231. TSQL to run DBCC rebuild_repair on an MSDE 2000-hosted DB
  232. Database Design Question
  233. ms access query problem
  234. SQL Mail
  235. PK
  236. SQL Server Job Wanted - Philly Metro Area
  237. More on dependecies
  238. DTS Package is dropping trailing spaces
  239. Logging Sql queries
  240. Stored Procedure Syntax
  241. Data Access Laws In the UK
  242. How to Modify a views' SQL source from a program
  243. Scribe Report Generator - beta testers needed
  244. DTS package and Firewall
  245. Locks and "forever runnable" processes
  246. Calculating Hours with Overlapping Times
  247. can't connect to Oracle
  248. uso del top en el mysql
  249. one frontend different type of backends
  250. SELECT DISTINCT
  251. Total SQL users?
  252. SQL use statistics
  253. Alias name for addressing SQL databases
  254. How do I avoid this corelated subquery?
  255. How do i grab a simple list of SQL Server views, tables or sprocs?
  256. SQL and ASP
  257. SQL and ASP
  258. Index Tuning Wizard - headache
  259. SQL server and ASP
  260. SQL SERVER DBA
  261. convert Access DB to MS SQL with dtswiz(command line)
  262. SQL Server 7 switches to Windows Only Auth on Reboot
  263. How to redirect a DTS package and connections
  264. Stored Proc Recompiling over and over
  265. Get message : The query cannot be excuted because some files are missing...
  266. Remote hosted database - SQLServer 2000
  267. DB increased the size
  268. FTP from within T-SQL
  269. Database Wars: Oracle vs SQL Server Lock Escalation
  270. sqlserver access datatype differences
  271. SQL funnies :o)
  272. Q: Analysis Services Cube Design
  273. REQ:how does one run SQL 2000
  274. Schedule Local Package to perform FTP and DB restore
  275. Check null value of long data type
  276. Query help: need at least one row for each value in each of two columns
  277. Get Current Identity(Procedure)
  278. Generate XML file from stored procedure
  279. Cannot make server as Target server or link from Master Server
  280. SQL server installation reboots my machine
  281. Query length
  282. referencing to a function..
  283. Passing error message to ASP.NET
  284. tuning the sort step of execution plan
  285. How to setup default value using GETDATE?
  286. New version of AbaPerls available!
  287. Help loading data from Excel to Analysis Services
  288. using conditional statement in stored prcodure to build select statement
  289. Help with query
  290. Send formated query result by mail
  291. sql server certifcation website wanted
  292. floating point calculation
  293. System catalog tables?
  294. converting datetime int
  295. Disabilitazione trigger [DISABLE TRIGGER]
  296. Update in SQL Server 2000 slow?
  297. Thoughts about the smart way to a task
  298. Coding in standard SQL ?
  299. 1-multiple to string
  300. displaying related data from a table
  301. displaying related data from a table
  302. PRIMARY file group is full
  303. Recursive Query
  304. Update query
  305. UPDATE query problem
  306. Can There be a single Index
  307. Returning database schemas
  308. I inteded to ask a different question
  309. Maximum Date in a group of records
  310. RDBMS Report Generator - beta testers needed
  311. How to ensure data is no longer on disk
  312. Hiding a SP in Access under Query, but retain Execute on SP
  313. Adding comments to TEXT field...
  314. Inserts failed sometimes ...
  315. INSERT ... SELECT PROBLEM
  316. DTS w/dynamic source & query
  317. problem analyzing logs with lumigent's log explorer
  318. test post - ignore
  319. re-indexing job takes more time
  320. Column Count from Stored Procedure
  321. Comparing and Synchronizing Databases, Tables, Stored Procedures accross servers
  322. Data/Transaction log files for two databases have same file name
  323. SS 2000 Backup programatically
  324. Cannot set job alerts on Notifications tab if a non-sysadmin user
  325. About MDF file
  326. Restore puts copy of user tables in master
  327. sister caught with the kid next store 4033
  328. Quale tipo di indice sulla tabella? Wich kind of index on table..??
  329. problema con la funzione except
  330. Round funtion on entire columns in MSSQL?
  331. Cant create database with > 4 GB log
  332. Update multiple records
  333. Extended SP Questions
  334. INSERT ... SELECT PROBLEM
  335. xp_Sendmail does everything but actually sending the message
  336. DTS w/dynamic source & query
  337. What so special about PostgreSQL and other RDBMS?
  338. problem analyzing logs with lumigent's log explorer
  339. test post - ignore
  340. Equivalent of "Startswith", "Endswith", "Contains" string comparisons in t-sql?
  341. Export & import DTS Packages
  342. ODBC Connect from MS Access to SQL Server 2000-Viable?
  343. re-indexing job takes more time
  344. Column Count from Stored Procedure
  345. Non trovo il link
  346. Importare dati con bcp in sql server 2000
  347. third party sql tool
  348. Torn page error
  349. Comparing and Synchronizing Databases, Tables, Stored Procedures accross servers
  350. Data/Transaction log files for two databases have same file name
  351. Add Keywords to Query Analyzer's Syntax
  352. SS 2000 Backup programatically
  353. Cannot set job alerts on Notifications tab if a non-sysadmin user
  354. Dirty Read ?
  355. About MDF file
  356. Can not install Reporting Services, Help!
  357. Restore puts copy of user tables in master
  358. Merge Replication + Structure Changes
  359. Compressed Drive Support in Yukon (SQL2005)?
  360. sister caught with the kid next store 4033
  361. Retrieve a list of db roles from within T-SQL????
  362. Quale tipo di indice sulla tabella? Wich kind of index on table..??
  363. Compare 2 DateValues -> maxvalue in transact sql
  364. problema con la funzione except
  365. Data Structure -- It's been a while
  366. Round funtion on entire columns in MSSQL?
  367. Using results of query in a query
  368. Cant create database with > 4 GB log
  369. storage snapshot
  370. FlexGrid in VB
  371. alter identity property of a column to NOT FOR REPLICATION
  372. problem passing UDF scalar result to UDF table function
  373. SQL Server Report Generator - beta testers needed
  374. Update multiple records
  375. Extended SP Questions
  376. xp_Sendmail does everything but actually sending the message
  377. Inserting row and scope_identity()
  378. What so special about PostgreSQL and other RDBMS?
  379. Equivalent of "Startswith", "Endswith", "Contains" string comparisons in t-sql?
  380. Reverse Wildcard Searches Impossible?
  381. Export & import DTS Packages
  382. Measure data transfer between replicated servers
  383. ODBC Connect from MS Access to SQL Server 2000-Viable?
  384. Senior DBA Positions in Dallas, Austin, Atlanta.....
  385. SQL Server Alerts...
  386. how to discover either windows group or SQL login
  387. 3 Login failed every second
  388. Non trovo il link
  389. Method Execute of Object - Command Falied(Runtime error-2147217900)
  390. Importare dati con bcp in sql server 2000
  391. How do I calculate the sum of each number in a string of numbers?
  392. third party sql tool
  393. Torn page error
  394. multiquery in a store procedure...
  395. How to find out which field in a table is updated
  396. Help won't open up for Enterprise Manager or Query Analyser
  397. Limiting tables displayed in new window for SQL 2000 Enterprise Manager
  398. percent of executed procedure
  399. SQL Server
  400. how to get online/offline status
  401. Add Keywords to Query Analyzer's Syntax
  402. Migrating StarOffice spreadsheet data to SQL Server
  403. SQL user
  404. Dirty Read ?
  405. Importing Big Text fields with <CR><LF> in them
  406. Can not install Reporting Services, Help!
  407. Assigning parameters in a function
  408. Merge Replication + Structure Changes
  409. SQL Server Object Security
  410. Compressed Drive Support in Yukon (SQL2005)?
  411. How to identify fragmented index for rebuild
  412. How to identify fragmented index for rebuild
  413. Retrieve a list of db roles from within T-SQL????
  414. Compare 2 DateValues -> maxvalue in transact sql
  415. Bin Laden Captured - photos and video
  416. divide INT get decimal output
  417. Data Structure -- It's been a while
  418. Using results of query in a query
  419. After copying a record with an SP all textfields has max lenght
  420. Create a view in VBA
  421. DIsk quotas
  422. dumping data from database
  423. storage snapshot
  424. alter identity property of a column to NOT FOR REPLICATION
  425. FlexGrid in VB
  426. problem passing UDF scalar result to UDF table function
  427. SQL Server Report Generator - beta testers needed
  428. sybase driver
  429. Send email notification for Scheduled Job completion
  430. Output to the log file with XP_CMDSHELL
  431. Inserting row and scope_identity()
  432. LINK WITH SQL SERVER
  433. ISNUMERIC and CAST
  434. Reverse Wildcard Searches Impossible?
  435. Sql maint plan not removing .trn files
  436. Measure data transfer between replicated servers
  437. Senior DBA Positions in Dallas, Austin, Atlanta.....
  438. SQL Server Alerts...
  439. how to discover either windows group or SQL login
  440. User ID limit per database, Msg 15065
  441. DB2 ODBC Error using in DTS (MDAC 2.7)
  442. SQL Server - failure to replicate
  443. 3 Login failed every second
  444. Dynamic Cross Tab Using Cursors.
  445. SQL Web Services
  446. Method Execute of Object - Command Falied(Runtime error-2147217900)
  447. Connected to which database
  448. How do I calculate the sum of each number in a string of numbers?
  449. multiquery in a store procedure...
  450. Performance tuning and measure on MSSQL 2000
  451. OpenWithServiceComponents 5 times slower for Oracle than for SQL Server?
  452. How to find out which field in a table is updated
  453. Help won't open up for Enterprise Manager or Query Analyser
  454. SQL 2000: Inserting multiple rows into a single table
  455. Limiting tables displayed in new window for SQL 2000 Enterprise Manager
  456. SQL Server
  457. percent of executed procedure
  458. how to get online/offline status
  459. Migrating StarOffice spreadsheet data to SQL Server
  460. SQL user
  461. Importing Big Text fields with <CR><LF> in them
  462. Open up SQL Server for central server application...
  463. SQL Eliminate Duplicates
  464. reading Transaction Log.
  465. Assigning parameters in a function
  466. Can I carry my existing DB users to a new server and restore???
  467. SQL Server Object Security
  468. Need help
  469. How to identify fragmented index for rebuild
  470. How to identify fragmented index for rebuild
  471. Need Sql statement
  472. Index Performance
  473. Bin Laden Captured - photos and video
  474. divide INT get decimal output
  475. column update function
  476. DTS from Excel to SQL?
  477. After copying a record with an SP all textfields has max lenght
  478. Create a view in VBA
  479. DIsk quotas
  480. dumping data from database
  481. Problem When using Recordset paging
  482. Should SQL concatenation return a null value if one field is null?
  483. Problem: Stored Procedures not completing from Web Application
  484. sybase driver
  485. regarding: Least expensive way to develop SQL 7 or 2000
  486. Send email notification for Scheduled Job completion
  487. Least expensive way to develop SQL 7 or 2000 Database on website?
  488. Sum query
  489. Index is being rebuilt
  490. @ local variable makes query slower?
  491. Output to the log file with XP_CMDSHELL
  492. Count records when RecordSource is a Stored Procedure
  493. LINK WITH SQL SERVER
  494. ISNUMERIC and CAST
  495. Unique constraint index
  496. BackUp Quastions
  497. Sql maint plan not removing .trn files
  498. error in recordsource after converting to sql server 2000
  499. Pre-installed databases?
  500. local system privildges
  501. User ID limit per database, Msg 15065
  502. DB2 ODBC Error using in DTS (MDAC 2.7)
  503. SQL Server - failure to replicate
  504. Dynamic Cross Tab Using Cursors.
  505. SQL Web Services
  506. Connected to which database
  507. Performance tuning and measure on MSSQL 2000
  508. Help for best logic
  509. Sr. SQL DBA job open in Texas
  510. OpenWithServiceComponents 5 times slower for Oracle than for SQL Server?
  511. Installing SQL Server 2000 Developer on Windows XP Pro
  512. SQL 2000: Inserting multiple rows into a single table
  513. Updating statistics
  514. Enterprise manager
  515. Open up SQL Server for central server application...
  516. use of variables - why doesnt htis work
  517. Problems with 'sp_helpdb' stored procedure
  518. SQL Eliminate Duplicates
  519. reading Transaction Log.
  520. Can I carry my existing DB users to a new server and restore???
  521. What is faster? C++ vector sort or sort in database
  522. Need help
  523. Need Sql statement
  524. Index Performance
  525. column update function
  526. DTS from Excel to SQL?
  527. Access Front End and SQL Server 2000 Record Level Access Control
  528. Problem When using Recordset paging
  529. Replication
  530. Executing a reboot command from SQL
  531. Upgrade to Sql 2000 with minimal downtime
  532. SQL Trigger for trimming String fields
  533. Should SQL concatenation return a null value if one field is null?
  534. Help for Trigger
  535. Problem: Stored Procedures not completing from Web Application
  536. Help: Purge Table Stored Procedure
  537. error with linked server
  538. SQL query fails
  539. SQL server reboots my windows 2000 machine
  540. regarding: Least expensive way to develop SQL 7 or 2000
  541. Creating database and table on MS MSQL server
  542. [QUERY] Help...
  543. Least expensive way to develop SQL 7 or 2000 Database on website?
  544. Sum query
  545. SQL daily
  546. Index is being rebuilt
  547. @ local variable makes query slower?
  548. Count records when RecordSource is a Stored Procedure
  549. Replace function and regular expressions
  550. Unique constraint index